Startsida Utforska Hjälp
Registrera dig Logga in
URBANMS
/
EXCELIA_DBARR
2
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 094af98cb5
Grenar Taggar
EXCELIA_DBARR
/
install
/
mysql
/
data
/
llx_accounting_account_ch.sql

llx_accounting_account_ch.sql 56 KB
Historik Rå

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261 
  1. 

  2. -- Descriptif plan comptable Suisse
    3. 

  3. -- ID 13000 - 13299
    4. 

  4. -- ADD 600000 to rowid # Do no remove this comment --
    5. 

  5. 

  6. INSERT INTO llx_const (name, value, type, note, visible, entity) values ('ACCOUNTING_MANAGE_ZERO','1','chaine','Manage the  0 for the accountancy account',1,0);
    7. 

  7. 

  8. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13000,'PCG_SUISSE','XXXXXX','1',0,'Actifs','1');
    9. 

  9. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13001,'PCG_SUISSE','XXXXXX','10',13000,'Actifs circulants','1');
    10. 

  10. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13002,'PCG_SUISSE','XXXXXX','100',13001,'Liquidités','1');
    11. 

  11. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13003,'PCG_SUISSE','XXXXXX','1000',13002,'Caisse','1');
    12. 

  12. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13004,'PCG_SUISSE','XXXXXX','1020',13002,'Banque (Avoir)','1');
    13. 

  13. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13005,'PCG_SUISSE','XXXXXX','106',13001,'Avoirs à courts terme côtés en bourse','1');
    14. 

  14. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13006,'PCG_SUISSE','XXXXXX','1060',13005,'Titres','1');
    15. 

  15. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13007,'PCG_SUISSE','XXXXXX','1069',13005,'Ajustement de la valeur des titres','1');
    16. 

  16. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13008,'PCG_SUISSE','XXXXXX','110',13001,'Créances résultant de livraisons et prestations','1');
    17. 

  17. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13009,'PCG_SUISSE','XXXXXX','1100',13008,'Créances provenant de livraisons et de prestations (Débiteurs)','1');
    18. 

  18. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13010,'PCG_SUISSE','XXXXXX','1109',13008,'Ducroire','1');
    19. 

  19. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13011,'PCG_SUISSE','XXXXXX','1110',13008,'Créances résultant de livr. et prest. envers les sociétés du groupe','1');
    20. 

  20. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13012,'PCG_SUISSE','XXXXXX','114',13001,'Autres créances à court terme','1');
    21. 

  21. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13013,'PCG_SUISSE','XXXXXX','1140',13012,'Avances et prêts','1');
    22. 

  22. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13014,'PCG_SUISSE','XXXXXX','1149',13012,'Ajustement de la valeur des avances et des prêts','1');
    23. 

  23. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13015,'PCG_SUISSE','XXXXXX','1170',13008,'Impôt préalable: TVA s/matériel, marchandises, prestations et énergie','1');
    24. 

  24. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13016,'PCG_SUISSE','XXXXXX','1171',13008,'Impôt préalable: TVA s/investissements et autres charges d''exploitation','1');
    25. 

  25. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13017,'PCG_SUISSE','XXXXXX','1176',13008,'Impôt anticipé','1');
    26. 

  26. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13018,'PCG_SUISSE','XXXXXX','1180',13008,'Créance envers les assurances sociales et institutions de prévoyance','1');
    27. 

  27. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13019,'PCG_SUISSE','XXXXXX','1189',13008,'Impôt à la source','1');
    28. 

  28. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13020,'PCG_SUISSE','XXXXXX','1190',13008,'Autres créances à court terme','1');
    29. 

  29. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13021,'PCG_SUISSE','XXXXXX','1199',13008,'Ajustement de la valeur des créances à court terme','1');
    30. 

  30. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13022,'PCG_SUISSE','XXXXXX','120',13001,'Stocks et prestations non facturées','1');
    31. 

  31. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13023,'PCG_SUISSE','XXXXXX','1200',13022,'Marchandises commerciales','1');
    32. 

  32. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13024,'PCG_SUISSE','XXXXXX','1210',13022,'Matières premières','1');
    33. 

  33. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13025,'PCG_SUISSE','XXXXXX','1220',13022,'Matières auxiliaires','1');
    34. 

  34. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13026,'PCG_SUISSE','XXXXXX','1230',13022,'Matières consommables','1');
    35. 

  35. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13027,'PCG_SUISSE','XXXXXX','1250',13022,'Marchandises en consignation','1');
    36. 

  36. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13028,'PCG_SUISSE','XXXXXX','1260',13022,'Stocks de produits fnis','1');
    37. 

  37. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13029,'PCG_SUISSE','XXXXXX','1280',13022,'Travaux en cours','1');
    38. 

  38. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13030,'PCG_SUISSE','XXXXXX','130',13001,'Compte de régularisation de l''actif','1');
    39. 

  39. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13031,'PCG_SUISSE','XXXXXX','1300',13030,'Charges payées d''avance','1');
    40. 

  40. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13032,'PCG_SUISSE','XXXXXX','1301',13030,'Produits à recevoir','1');
    41. 

  41. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13033,'PCG_SUISSE','XXXXXX','14',13000,'Actifs immobilisés','1');
    42. 

  42. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13034,'PCG_SUISSE','XXXXXX','140',13033,'Immobilisations financières','1');
    43. 

  43. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13035,'PCG_SUISSE','XXXXXX','1400',13034,'Titres à long terme','1');
    44. 

  44. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13036,'PCG_SUISSE','XXXXXX','1409',13034,'Ajustement de la valeur des titres','1');
    45. 

  45. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13037,'PCG_SUISSE','XXXXXX','1440',13034,'Prêts','1');
    46. 

  46. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13038,'PCG_SUISSE','XXXXXX','1441',13034,'Hypothèques','1');
    47. 

  47. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13039,'PCG_SUISSE','XXXXXX','1449',13034,'Ajustement de la valeur des créances à long terme','1');
    48. 

  48. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13040,'PCG_SUISSE','XXXXXX','148',13033,'Participations','1');
    49. 

  49. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13041,'PCG_SUISSE','XXXXXX','1480',13040,'Participations','1');
    50. 

  50. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13042,'PCG_SUISSE','XXXXXX','1489',13040,'Ajustement de la valeur des participations','1');
    51. 

  51. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13043,'PCG_SUISSE','XXXXXX','150',13000,'Immobilisations corporelles meublés','1');
    52. 

  52. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13044,'PCG_SUISSE','XXXXXX','1500',13043,'Machines et appareils','1');
    53. 

  53. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13045,'PCG_SUISSE','XXXXXX','1509',13043,'Ajustement de la valeur des machines et appareils','1');
    54. 

  54. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13046,'PCG_SUISSE','XXXXXX','1510',13043,'Mobilier et installations','1');
    55. 

  55. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13047,'PCG_SUISSE','XXXXXX','1519',13043,'Ajustement de la valeur du mobilier et des installations','1');
    56. 

  56. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13048,'PCG_SUISSE','XXXXXX','1520',13043,'Machines de bureau, informatique, système de communication','1');
    57. 

  57. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13049,'PCG_SUISSE','XXXXXX','1529',13043,'Ajustement de la valeur des machines de bureau, inf. et syst. comm.','1');
    58. 

  58. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13050,'PCG_SUISSE','XXXXXX','1530',13043,'Véhicules','1');
    59. 

  59. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13051,'PCG_SUISSE','XXXXXX','1539',13043,'Ajustement de la valeur des véhicules','1');
    60. 

  60. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13052,'PCG_SUISSE','XXXXXX','1540',13043,'Outillages et appareils','1');
    61. 

  61. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13053,'PCG_SUISSE','XXXXXX','1549',13043,'Ajustement de la valeur des outillages et appareils','1');
    62. 

  62. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13054,'PCG_SUISSE','XXXXXX','160',13000,'Immobilisations corporelles Immeubles','1');
    63. 

  63. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13055,'PCG_SUISSE','XXXXXX','1600',13054,'Immeubles d''exploitation','1');
    64. 

  64. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13056,'PCG_SUISSE','XXXXXX','1609',13054,'Ajustements de la valeur des immeubles d''exploitation','1');
    65. 

  65. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13057,'PCG_SUISSE','XXXXXX','170',13000,'Immobilisations incorporelles','1');
    66. 

  66. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13058,'PCG_SUISSE','XXXXXX','1700',13057,'Brevets, know-how, licences, droits, dév.','1');
    67. 

  67. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13059,'PCG_SUISSE','XXXXXX','1709',13057,'Ajustement de la valeur des brevets, know-how, licences, droits, dév.','1');
    68. 

  68. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13060,'PCG_SUISSE','XXXXXX','1770',13057,'Goodwill','1');
    69. 

  69. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13061,'PCG_SUISSE','XXXXXX','1779',13057,'Ajustement de la valeur du goodwill','1');
    70. 

  70. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13062,'PCG_SUISSE','XXXXXX','180',13000,'Capital non versé : capital social, capital de fondation','1');
    71. 

  71. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13063,'PCG_SUISSE','XXXXXX','1850',13062,'Capital actions, capital social, droits de participations ou capital de fondation non versés','1');
    72. 

  72. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13064,'PCG_SUISSE','XXXXXX','2',0,'Passif','1');
    73. 

  73. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13065,'PCG_SUISSE','XXXXXX','20',13064,'Dettes à court terme','1');
    74. 

  74. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13066,'PCG_SUISSE','XXXXXX','200',13065,'Dettes à court terme résultant d''achats et de prestations de services','1');
    75. 

  75. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13067,'PCG_SUISSE','XXXXXX','2000',13066,'Dettes résultant d''achats et des prestations de services (créanciers)','1');
    76. 

  76. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13068,'PCG_SUISSE','XXXXXX','2030',13066,'Acomptes de clients','1');
    77. 

  77. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13069,'PCG_SUISSE','XXXXXX','2050',13066,'Dettes résultant d''achats et de prestations de services envers des sociétés du groupe','1');
    78. 

  78. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13070,'PCG_SUISSE','XXXXXX','210',13065,'Dettes à court terme rémunérés','1');
    79. 

  79. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13071,'PCG_SUISSE','XXXXXX','2100',13070,'Dettes bancaires','1');
    80. 

  80. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13072,'PCG_SUISSE','XXXXXX','2120',13070,'Engagements de financement par leasing','1');
    81. 

  81. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13073,'PCG_SUISSE','XXXXXX','2140',13070,'Autres dettes à court terme rémunérées','1');
    82. 

  82. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13074,'PCG_SUISSE','XXXXXX','2151',13070,'Salaires à payer','1');
    83. 

  83. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13075,'PCG_SUISSE','XXXXXX','2152',13070,'Charges sociales à payer (AVS/AC/ALFA)','1');
    84. 

  84. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13076,'PCG_SUISSE','XXXXXX','21521',13075,'Créancier AVS/AI/APG/AC','1');
    85. 

  85. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13077,'PCG_SUISSE','XXXXXX','21522',13075,'Créancier Allocations Familiales','1');
    86. 

  86. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13078,'PCG_SUISSE','XXXXXX','2153',13070,'Assurances sociales à payer (LAA, IJM, FT, LPP)','1');
    87. 

  87. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13079,'PCG_SUISSE','XXXXXX','21531',13078,'Créancier Assurance Accidents','1');
    88. 

  88. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13080,'PCG_SUISSE','XXXXXX','21532',13078,'Créancier Assurance Accidents complémentaire','1');
    89. 

  89. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13081,'PCG_SUISSE','XXXXXX','21533',13078,'Créancier Prévoyance Professionnelle','1');
    90. 

  90. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13082,'PCG_SUISSE','XXXXXX','21534',13078,'Créancier Prévoyance Professionnelle complémentaire','1');
    91. 

  91. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13083,'PCG_SUISSE','XXXXXX','21535',13078,'Créancier Assurance Indemnités Journalières Maladie','1');
    92. 

  92. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13084,'PCG_SUISSE','XXXXXX','21536',13078,'Créancier Assurance Indemnités Journalières Maladie complémentaire','1');
    93. 

  93. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13085,'PCG_SUISSE','XXXXXX','21539',13078,'Créancier autres caisses et assurances','1');
    94. 

  94. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13086,'PCG_SUISSE','XXXXXX','2154',13070,'Impôt source','1');
    95. 

  95. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13087,'PCG_SUISSE','XXXXXX','2155',13070,'Autres charges','1');
    96. 

  96. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13088,'PCG_SUISSE','XXXXXX','21551',13087,'Taxe réfugiés','1');
    97. 

  97. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13089,'PCG_SUISSE','XXXXXX','21552',13087,'Office des Poursuites','1');
    98. 

  98. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13090,'PCG_SUISSE','XXXXXX','21553',13087,'Retraite anticipée','1');
    99. 

  99. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13091,'PCG_SUISSE','XXXXXX','21554',13087,'Caisse professionnelle','1');
    100. 

  100. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13092,'PCG_SUISSE','XXXXXX','21559',13087,'Autres retenues employé à payer','1');
    101. 

  101. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13093,'PCG_SUISSE','XXXXXX','2158',13070,'Provisions 13ème et vacances à payer','1');
    102. 

  102. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13094,'PCG_SUISSE','XXXXXX','2160',13070,'Indemnités d''assurances','1');
    103. 

  103. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13095,'PCG_SUISSE','XXXXXX','21601',13094,'Indemnités d''assurance accidents','1');
    104. 

  104. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13096,'PCG_SUISSE','XXXXXX','21602',13094,'Indemnités d''assurance maladie','1');
    105. 

  105. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13097,'PCG_SUISSE','XXXXXX','21603',13094,'Indemnités d''assurance maternité','1');
    106. 

  106. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13098,'PCG_SUISSE','XXXXXX','21604',13094,'Indemnités d''assurance maternité complémentaire','1');
    107. 

  107. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13099,'PCG_SUISSE','XXXXXX','21605',13094,'Indemnités d''assurance APG militaire','1');
    108. 

  108. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13100,'PCG_SUISSE','XXXXXX','21606',13094,'Indemnités d''assurance militaire','1');
    109. 

  109. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13101,'PCG_SUISSE','XXXXXX','21607',13094,'Indemnités d''assurance chômage','1');
    110. 

  110. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13102,'PCG_SUISSE','XXXXXX','21608',13094,'Indemnités d''assurance AI','1');
    111. 

  111. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13103,'PCG_SUISSE','XXXXXX','21609',13094,'Autres','1');
    112. 

  112. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13104,'PCG_SUISSE','XXXXXX','220',13065,'Autres dettes à court terme','1');
    113. 

  113. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13105,'PCG_SUISSE','XXXXXX','2200',13104,'TVA due','1');
    114. 

  114. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13106,'PCG_SUISSE','XXXXXX','2201',13104,'Décompte TVA','1');
    115. 

  115. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13107,'PCG_SUISSE','XXXXXX','2206',13104,'Impôt anticipé dû','1');
    116. 

  116. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13108,'PCG_SUISSE','XXXXXX','2208',13104,'Impôts directs','1');
    117. 

  117. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13109,'PCG_SUISSE','XXXXXX','2210',13104,'Autres dettes à court terme','1');
    118. 

  118. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13110,'PCG_SUISSE','XXXXXX','2261',13104,'Dividendes','1');
    119. 

  119. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13111,'PCG_SUISSE','XXXXXX','2270',13104,'Assurances sociales et institutions de prévoyance','1');
    120. 

  120. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13112,'PCG_SUISSE','XXXXXX','2279',13104,'Impôt à la source','1');
    121. 

  121. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13113,'PCG_SUISSE','XXXXXX','230',13065,'Passifs de régularisation et provision à court terme','1');
    122. 

  122. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13114,'PCG_SUISSE','XXXXXX','2300',13113,'Charges à payer','1');
    123. 

  123. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13115,'PCG_SUISSE','XXXXXX','2301',13113,'Produits constatés d''avance','1');
    124. 

  124. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13116,'PCG_SUISSE','XXXXXX','2330',13113,'Provisions à court terme','1');
    125. 

  125. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13117,'PCG_SUISSE','XXXXXX','24',13064,'Dettes à long terme','1');
    126. 

  126. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13118,'PCG_SUISSE','XXXXXX','240',13117,'Dettes à long terme rémunérées','1');
    127. 

  127. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13119,'PCG_SUISSE','XXXXXX','2400',13118,'Dettes bancaires','1');
    128. 

  128. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13120,'PCG_SUISSE','XXXXXX','2420',13118,'Engagements de financement par leasing','1');
    129. 

  129. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13121,'PCG_SUISSE','XXXXXX','2430',13118,'Emprunts obligataires','1');
    130. 

  130. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13122,'PCG_SUISSE','XXXXXX','2450',13118,'Emprunts','1');
    131. 

  131. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13123,'PCG_SUISSE','XXXXXX','2451',13118,'Hypothèques','1');
    132. 

  132. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13124,'PCG_SUISSE','XXXXXX','250',13117,'Autres dettes à long terme','1');
    133. 

  133. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13125,'PCG_SUISSE','XXXXXX','2500',13124,'Autres dettes à long terme','1');
    134. 

  134. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13126,'PCG_SUISSE','XXXXXX','260',13117,'Provisions à long terme et provisions légales','1');
    135. 

  135. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13127,'PCG_SUISSE','XXXXXX','2600',13126,'Provisions','1');
    136. 

  136. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13128,'PCG_SUISSE','XXXXXX','28',13064,'Fonds propres (personnes morales)','1');
    137. 

  137. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13129,'PCG_SUISSE','XXXXXX','280',13128,'Capital social ou capital de fondation','1');
    138. 

  138. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13130,'PCG_SUISSE','XXXXXX','2800',13129,'Capital-actions, capital social, capital de fondation','1');
    139. 

  139. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13131,'PCG_SUISSE','XXXXXX','290',13064,'Réserves / bénéfices et pertes','1');
    140. 

  140. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13132,'PCG_SUISSE','XXXXXX','2900',13131,'Réserves légales issues du capital','1');
    141. 

  141. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13133,'PCG_SUISSE','XXXXXX','2930',13131,'Réserves sur participations propres au capital','1');
    142. 

  142. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13134,'PCG_SUISSE','XXXXXX','2940',13131,'Réserves d''évaluation','1');
    143. 

  143. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13135,'PCG_SUISSE','XXXXXX','2950',13131,'Réserves légales issues du bénéfice','1');
    144. 

  144. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13136,'PCG_SUISSE','XXXXXX','2960',13131,'Réserves libres','1');
    145. 

  145. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13137,'PCG_SUISSE','XXXXXX','2970',13131,'Bénéfice / perte reporté','1');
    146. 

  146. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13138,'PCG_SUISSE','XXXXXX','2979',13131,'Bénéfice / perte de l''exercice','1');
    147. 

  147. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13139,'PCG_SUISSE','XXXXXX','2980',13131,'Propres actions, parts sociales, droits de participations (poste négatif)','1');
    148. 

  148. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13140,'PCG_SUISSE','XXXXXX','3',0,'Chiffre d''affaires résultant des ventes et des prestations de services','1');
    149. 

  149. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13141,'PCG_SUISSE','XXXXXX','3000',13140,'Ventes de produits fabriqués','1');
    150. 

  150. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13142,'PCG_SUISSE','XXXXXX','3200',13140,'Ventes de marchandises','1');
    151. 

  151. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13143,'PCG_SUISSE','XXXXXX','3400',13140,'Ventes de prestations','1');
    152. 

  152. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13144,'PCG_SUISSE','XXXXXX','3600',13140,'Autres ventes et prestations de services','1');
    153. 

  153. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13145,'PCG_SUISSE','XXXXXX','3700',13140,'Prestations propres','1');
    154. 

  154. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13146,'PCG_SUISSE','XXXXXX','3710',13140,'Consommations propres','1');
    155. 

  155. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13147,'PCG_SUISSE','XXXXXX','3800',13140,'Déductions sur ventes','1');
    156. 

  156. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13148,'PCG_SUISSE','XXXXXX','3805',13140,'Pertes sur clients, variations du ducroire','1');
    157. 

  157. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13149,'PCG_SUISSE','XXXXXX','3900',13140,'Variation des stocks de produits semis-finis','1');
    158. 

  158. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13150,'PCG_SUISSE','XXXXXX','3901',13140,'Variation des stocks de produits finis','1');
    159. 

  159. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13151,'PCG_SUISSE','XXXXXX','3904',13140,'Variation de la valeur des prestations non facturées','1');
    160. 

  160. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13152,'PCG_SUISSE','XXXXXX','4',0,'Charges de matériel, de marchandises et de prestations de tiers','1');
    161. 

  161. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13153,'PCG_SUISSE','XXXXXX','4000',13152,'Charges de matériel de l''atelier','1');
    162. 

  162. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13154,'PCG_SUISSE','XXXXXX','4200',13152,'Achats de marchandises destinées à la revente','1');
    163. 

  163. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13155,'PCG_SUISSE','XXXXXX','4400',13152,'Prestations / travaux de tiers','1');
    164. 

  164. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13156,'PCG_SUISSE','XXXXXX','4500',13152,'Charges d''énergie pour l''exploitation','1');
    165. 

  165. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13157,'PCG_SUISSE','XXXXXX','4900',13152,'Déductions sur les charges','1');
    166. 

  166. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13158,'PCG_SUISSE','XXXXXX','5',0,'Charges de personnel','1');
    167. 

  167. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13159,'PCG_SUISSE','XXXXXX','5000',13158,'Salaires','1');
    168. 

  168. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13160,'PCG_SUISSE','XXXXXX','5200',13158,'Charges de personnel','1');
    169. 

  169. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13161,'PCG_SUISSE','XXXXXX','5201',13158,'Salaires variables, commissions et primes régulières','1');
    170. 

  170. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13162,'PCG_SUISSE','XXXXXX','5202',13158,'Primes occasionnelles et participations au bénéfice','1');
    171. 

  171. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13163,'PCG_SUISSE','XXXXXX','5203',13158,'Divers soumis','1');
    172. 

  172. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13164,'PCG_SUISSE','XXXXXX','5204',13158,'Divers non soumis','1');
    173. 

  173. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13165,'PCG_SUISSE','XXXXXX','5210',13158,'Honoraires et indemnités CA','1');
    174. 

  174. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13166,'PCG_SUISSE','XXXXXX','5270',13158,'AVS, AI, APG, assurance-chômage','1');
    175. 

  175. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13167,'PCG_SUISSE','XXXXXX','5271',13158,'Caisse d''allocations familiales','1');
    176. 

  176. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13168,'PCG_SUISSE','XXXXXX','52721',13167,'Prévoyance professionnelle','1');
    177. 

  177. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13169,'PCG_SUISSE','XXXXXX','52722',13167,'Prévoyance professionnelle complémentaire','1');
    178. 

  178. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13170,'PCG_SUISSE','XXXXXX','52731',13167,'Assurance-accidents','1');
    179. 

  179. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13171,'PCG_SUISSE','XXXXXX','52732',13167,'Assurance-accidents complémentaire','1');
    180. 

  180. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13172,'PCG_SUISSE','XXXXXX','52741',13167,'Assurance IJM','1');
    181. 

  181. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13173,'PCG_SUISSE','XXXXXX','52742',13167,'Assurance IJM complémentaire','1');
    182. 

  182. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13174,'PCG_SUISSE','XXXXXX','5275',13158,'Autres assurances','1');
    183. 

  183. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13175,'PCG_SUISSE','XXXXXX','5276',13158,'Impôts à la source payé par employeur','1');
    184. 

  184. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13176,'PCG_SUISSE','XXXXXX','5278',13158,'Caisse professionnelle','1');
    185. 

  185. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13177,'PCG_SUISSE','XXXXXX','5279',13158,'Arrondis sur charges sociales','1');
    186. 

  186. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13178,'PCG_SUISSE','XXXXXX','5280',13158,'Autres charges de personnel','1');
    187. 

  187. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13179,'PCG_SUISSE','XXXXXX','5281',13158,'Frais de voyages/transport','1');
    188. 

  188. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13180,'PCG_SUISSE','XXXXXX','5282',13158,'Frais de repas/hébergement','1');
    189. 

  189. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13181,'PCG_SUISSE','XXXXXX','5283',13158,'Frais forfaitaires','1');
    190. 

  190. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13182,'PCG_SUISSE','XXXXXX','5284',13158,'Frais de représentation, téléphones, divers','1');
    191. 

  191. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13183,'PCG_SUISSE','XXXXXX','5288',13158,'Frais de formation','1');
    192. 

  192. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13184,'PCG_SUISSE','XXXXXX','5289',13158,'Autres frais de personnel','1');
    193. 

  193. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13185,'PCG_SUISSE','XXXXXX','5290',13158,'Prestations de travail de tiers','1');
    194. 

  194. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13186,'PCG_SUISSE','XXXXXX','5700',13158,'Charges sociales','1');
    195. 

  195. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13187,'PCG_SUISSE','XXXXXX','5800',13158,'Autres charges du personnel','1');
    196. 

  196. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13188,'PCG_SUISSE','XXXXXX','5900',13158,'Charges de personnels temporaires','1');
    197. 

  197. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13189,'PCG_SUISSE','XXXXXX','6',0,'Autres charges d''exploitation, amortissements et ajustement de valeur, résultat financier','1');
    198. 

  198. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13190,'PCG_SUISSE','XXXXXX','6000',13189,'Charges de locaux','1');
    199. 

  199. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13191,'PCG_SUISSE','XXXXXX','6100',13189,'Entretien, réparations et remplacement des inst. servant à l''exploitation','1');
    200. 

  200. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13192,'PCG_SUISSE','XXXXXX','6105',13189,'Leasing immobilisations corporelles meubles','1');
    201. 

  201. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13193,'PCG_SUISSE','XXXXXX','6200',13189,'Charges de véhicules et de transport','1');
    202. 

  202. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13194,'PCG_SUISSE','XXXXXX','6260',13189,'Leasing et location de véhicule','1');
    203. 

  203. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13195,'PCG_SUISSE','XXXXXX','6300',13189,'Assurances-choses, droits, taxes, autorisations','1');
    204. 

  204. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13196,'PCG_SUISSE','XXXXXX','6400',13189,'Charges d''énergie et évacuation des déchets','1');
    205. 

  205. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13197,'PCG_SUISSE','XXXXXX','6500',13189,'Charges d''administration','1');
    206. 

  206. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13198,'PCG_SUISSE','XXXXXX','6510',13189,'Téléphone','1');
    207. 

  207. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13199,'PCG_SUISSE','XXXXXX','6511',13189,'Internet','1');
    208. 

  208. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13200,'PCG_SUISSE','XXXXXX','6512',13189,'Frais de port','1');
    209. 

  209. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13201,'PCG_SUISSE','XXXXXX','6560',13189,'Informatique','1');
    210. 

  210. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13202,'PCG_SUISSE','XXXXXX','6570',13189,'Charges et leasing d''informatique','1');
    211. 

  211. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13203,'PCG_SUISSE','XXXXXX','6571',13189,'Entretien/Hotline Hardware','1');
    212. 

  212. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13204,'PCG_SUISSE','XXXXXX','6573',13189,'Disquettes, CD-Rom, etc. Fourniture d''exploitation','1');
    213. 

  213. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13205,'PCG_SUISSE','XXXXXX','6600',13189,'Publicité','1');
    214. 

  214. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13206,'PCG_SUISSE','XXXXXX','6610',13189,'Imprimés publicitaires','1');
    215. 

  215. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13207,'PCG_SUISSE','XXXXXX','6640',13189,'Frais de voyage et conseils à la clientèle','1');
    216. 

  216. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13208,'PCG_SUISSE','XXXXXX','6641',13189,'Frais de représentation','1');
    217. 

  217. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13209,'PCG_SUISSE','XXXXXX','6700',13189,'Autres charges d''exploitation','1');
    218. 

  218. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13210,'PCG_SUISSE','XXXXXX','6800',13189,'Amortissement et ajustement de valeur des postes sur immobilisations corporelles','1');
    219. 

  219. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13211,'PCG_SUISSE','XXXXXX','6801',13189,'Intérêts pour emprunts','1');
    220. 

  220. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13212,'PCG_SUISSE','XXXXXX','6840',13189,'Frais de banque et des chèques postaux','1');
    221. 

  221. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13213,'PCG_SUISSE','XXXXXX','6850',13189,'Produits financiers','1');
    222. 

  222. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13214,'PCG_SUISSE','XXXXXX','6900',13189,'Charges financières','1');
    223. 

  223. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13215,'PCG_SUISSE','XXXXXX','6920',13189,'Amortissement s/immobilisé. corporelles meubles','1');
    224. 

  224. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13216,'PCG_SUISSE','XXXXXX','6930',13189,'Amortissement s/immobilisé. corporelles immeubles','1');
    225. 

  225. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13217,'PCG_SUISSE','XXXXXX','6940',13189,'Amortissement s/immobilisé. incorporelles','1');
    226. 

  226. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13218,'PCG_SUISSE','XXXXXX','6950',13189,'Produits financiers','1');
    227. 

  227. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13219,'PCG_SUISSE','XXXXXX','7',0,'Résultat des activités annexes d''exploitation','1');
    228. 

  228. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13220,'PCG_SUISSE','XXXXXX','7000',13219,'Produits accessoires','1');
    229. 

  229. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13221,'PCG_SUISSE','XXXXXX','7010',13219,'Charges accessoires','1');
    230. 

  230. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13222,'PCG_SUISSE','XXXXXX','7400',13219,'Produits sur placements financiers','1');
    231. 

  231. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13223,'PCG_SUISSE','XXXXXX','7410',13219,'Charges sur placements financiers','1');
    232. 

  232. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13224,'PCG_SUISSE','XXXXXX','7500',13219,'Produits des immeubles d''exploitation','1');
    233. 

  233. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13225,'PCG_SUISSE','XXXXXX','7510',13219,'Charges des immeubles d''exploitation','1');
    234. 

  234. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13226,'PCG_SUISSE','XXXXXX','8',0,'Charges hors exploitation','1');
    235. 

  235. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13227,'PCG_SUISSE','XXXXXX','8000',13226,'Charges hors exploitation','1');
    236. 

  236. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13228,'PCG_SUISSE','XXXXXX','8100',13226,'Produits hors exploitation','1');
    237. 

  237. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13229,'PCG_SUISSE','XXXXXX','8500',13226,'Charges extraordinaires, exceptionnelles ou hors période','1');
    238. 

  238. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13230,'PCG_SUISSE','XXXXXX','8510',13226,'Produits extraordinaires, exceptionnels ou hors période','1');
    239. 

  239. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13231,'PCG_SUISSE','XXXXXX','8900',13226,'Impôts directs','1');
    240. 

  240. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13232,'PCG_SUISSE','XXXXXX','9',0,'Produits de vente et de services','1');
    241. 

  241. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13233,'PCG_SUISSE','XXXXXX','9001',13232,'Charges de vente et de services','1');
    242. 

  242. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13234,'PCG_SUISSE','XXXXXX','9002',13232,'Résultat brut 1','1');
    243. 

  243. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13235,'PCG_SUISSE','XXXXXX','9006',13232,'Charges de personnel de production','1');
    244. 

  244. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13236,'PCG_SUISSE','XXXXXX','9007',13232,'Résultat brut 2','1');
    245. 

  245. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13237,'PCG_SUISSE','XXXXXX','9008',13232,'Autres charges de personnel','1');
    246. 

  246. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13238,'PCG_SUISSE','XXXXXX','9009',13232,'Résultat brut 3','1');
    247. 

  247. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13239,'PCG_SUISSE','XXXXXX','9010',13232,'Autres charges d''exploitation','1');
    248. 

  248. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13240,'PCG_SUISSE','XXXXXX','9011',13232,'Résultat d''exploitation 1','1');
    249. 

  249. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13241,'PCG_SUISSE','XXXXXX','9012',13232,'Résultat financier','1');
    250. 

  250. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13242,'PCG_SUISSE','XXXXXX','9013',13232,'Résultat d''exploitation 2','1');
    251. 

  251. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13243,'PCG_SUISSE','XXXXXX','9014',13232,'Amortissements','1');
    252. 

  252. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13244,'PCG_SUISSE','XXXXXX','9015',13232,'Résultat d''exploitation 3','1');
    253. 

  253. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13245,'PCG_SUISSE','XXXXXX','9016',13232,'Résultat activités annexes exploitation','1');
    254. 

  254. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13246,'PCG_SUISSE','XXXXXX','9017',13232,'Résultat d''exploitation 4','1');
    255. 

  255. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13247,'PCG_SUISSE','XXXXXX','9018',13232,'Résultats extraordinaires','1');
    256. 

  256. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13248,'PCG_SUISSE','XXXXXX','9019',13232,'Résultat d''entreprise avant impôts','1');
    257. 

  257. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13249,'PCG_SUISSE','XXXXXX','9020',13232,'Charges d''impôts','1');
    258. 

  258. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13250,'PCG_SUISSE','XXXXXX','9090',13232,'Résultat d''entreprise','1');
    259. 

  259. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13251,'PCG_SUISSE','XXXXXX','9100',13232,'Bilan d''ouverture','1');
    260. 

  260. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13252,'PCG_SUISSE','XXXXXX','9101',13232,'Bilan de clôture','1');
    261. 

  261. INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (__ENTITY__, 13253,'PCG_SUISSE','XXXXXX','9200',13232,'Bénéfice / perte de l''exercice','1');
    262.