INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES (140, 'PCN2020-LUXEMBURG', 'Plan comptable normalisé 2020 Luxembourgeois', 1);

INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17000, 'PCN2020-LUXEMBURG', 'LIABILIT', '101', 0, "Capital souscrit", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17001, 'PCN2020-LUXEMBURG', 'LIABILIT', '102', 0, "Capital souscrit non appelé", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17002, 'PCN2020-LUXEMBURG', 'LIABILIT', '103', 0, "Capital souscrit appelé et non versé", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17003, 'PCN2020-LUXEMBURG', 'LIABILIT', '104', 0, "Cap. Entr. Indiv/soc. de pers. et assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17004, 'PCN2020-LUXEMBURG', 'LIABILIT', '105', 0, "Dotation des succursales", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17005, 'PCN2020-LUXEMBURG', 'LIABILIT', '10611', 0, "Prélèvements en numéraire (train de vie)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17006, 'PCN2020-LUXEMBURG', 'LIABILIT', '10612', 0, "Prélèvements en nature de marchandises,", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17007, 'PCN2020-LUXEMBURG', 'LIABILIT', '10613', 0, "Part personnelle des frais de maladie", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17008, 'PCN2020-LUXEMBURG', 'LIABILIT', '106141', 0, "Vie", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17009, 'PCN2020-LUXEMBURG', 'LIABILIT', '106142', 0, "Accident", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17010, 'PCN2020-LUXEMBURG', 'LIABILIT', '106143', 0, "Incendie", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17011, 'PCN2020-LUXEMBURG', 'LIABILIT', '106144', 0, "Responsabilité civile", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17012, 'PCN2020-LUXEMBURG', 'LIABILIT', '106145', 0, "Multirisques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17013, 'PCN2020-LUXEMBURG', 'LIABILIT', '106148', 0, "Autres primes d’assurances privées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17014, 'PCN2020-LUXEMBURG', 'LIABILIT', '106151', 0, "Assurances sociales (assurance dépendanc", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17015, 'PCN2020-LUXEMBURG', 'LIABILIT', '106152', 0, "Allocations familiales", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17016, 'PCN2020-LUXEMBURG', 'LIABILIT', '106153', 0, "Cotisations pour mutuelles", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17017, 'PCN2020-LUXEMBURG', 'LIABILIT', '106154', 0, "Caisse de décès, médico-chirurgicale, Pr", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17018, 'PCN2020-LUXEMBURG', 'LIABILIT', '106158', 0, "Autres cotisations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17019, 'PCN2020-LUXEMBURG', 'LIABILIT', '106161', 0, "Salaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17020, 'PCN2020-LUXEMBURG', 'LIABILIT', '106162', 0, "Loyer", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17021, 'PCN2020-LUXEMBURG', 'LIABILIT', '106163', 0, "Chauffage, gaz, électricité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17022, 'PCN2020-LUXEMBURG', 'LIABILIT', '106164', 0, "Eau", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17023, 'PCN2020-LUXEMBURG', 'LIABILIT', '106165', 0, "Téléphone", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17024, 'PCN2020-LUXEMBURG', 'LIABILIT', '106166', 0, "Voiture", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17025, 'PCN2020-LUXEMBURG', 'LIABILIT', '106168', 0, "Autres prélèvements en nature", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17026, 'PCN2020-LUXEMBURG', 'LIABILIT', '106171', 0, "Mobilier privé", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17027, 'PCN2020-LUXEMBURG', 'LIABILIT', '106172', 0, "Voiture privée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17028, 'PCN2020-LUXEMBURG', 'LIABILIT', '106173', 0, "Titres privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17029, 'PCN2020-LUXEMBURG', 'LIABILIT', '106174', 0, "Immeubles privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17030, 'PCN2020-LUXEMBURG', 'LIABILIT', '106178', 0, "Autres acquisitions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17031, 'PCN2020-LUXEMBURG', 'LIABILIT', '106181', 0, "Impôt sur le revenu payé (IRPP)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17032, 'PCN2020-LUXEMBURG', 'LIABILIT', '106183', 0, "Impôt commercial communal (ICC) - arriér", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17033, 'PCN2020-LUXEMBURG', 'LIABILIT', '106188', 0, "Autres impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17034, 'PCN2020-LUXEMBURG', 'LIABILIT', '106191', 0, "Réparations aux immeubles privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17035, 'PCN2020-LUXEMBURG', 'LIABILIT', '106192', 0, "Placements sur comptes financiers privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17036, 'PCN2020-LUXEMBURG', 'LIABILIT', '106193', 0, "Remboursements de dettes privées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17037, 'PCN2020-LUXEMBURG', 'LIABILIT', '106194', 0, "Dons et dotations aux enfants", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17038, 'PCN2020-LUXEMBURG', 'LIABILIT', '106195', 0, "Droits de succession et droits de mutati", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17039, 'PCN2020-LUXEMBURG', 'LIABILIT', '106198', 0, "Autres prélèvements privés particuliers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17040, 'PCN2020-LUXEMBURG', 'LIABILIT', '10621', 0, "Héritage ou donation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17041, 'PCN2020-LUXEMBURG', 'LIABILIT', '10622', 0, "Avoirs privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17042, 'PCN2020-LUXEMBURG', 'LIABILIT', '10623', 0, "Emprunts privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17043, 'PCN2020-LUXEMBURG', 'LIABILIT', '106241', 0, "Mobilier privé", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17044, 'PCN2020-LUXEMBURG', 'LIABILIT', '106242', 0, "Voiture privée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17045, 'PCN2020-LUXEMBURG', 'LIABILIT', '106243', 0, "Titres privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17046, 'PCN2020-LUXEMBURG', 'LIABILIT', '106244', 0, "Immeubles privés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17047, 'PCN2020-LUXEMBURG', 'LIABILIT', '106248', 0, "Autres cessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17048, 'PCN2020-LUXEMBURG', 'LIABILIT', '10625', 0, "Loyers encaissés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17049, 'PCN2020-LUXEMBURG', 'LIABILIT', '10626', 0, "Salaires ou rentes touchés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17050, 'PCN2020-LUXEMBURG', 'LIABILIT', '10627', 0, "Allocations familiales reçues", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17051, 'PCN2020-LUXEMBURG', 'LIABILIT', '106281', 0, "Impôt sur le revenu (IRPP)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17052, 'PCN2020-LUXEMBURG', 'LIABILIT', '106284', 0, "Impôt commercial communal (ICC)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17053, 'PCN2020-LUXEMBURG', 'LIABILIT', '106288', 0, "Autres remboursements d’impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17054, 'PCN2020-LUXEMBURG', 'LIABILIT', '10629', 0, "Quote-part professionnelle de frais priv", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17055, 'PCN2020-LUXEMBURG', 'LIABILIT', '111', 0, "Primes d'émission", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17056, 'PCN2020-LUXEMBURG', 'LIABILIT', '112', 0, "Primes de fusion", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17057, 'PCN2020-LUXEMBURG', 'LIABILIT', '113', 0, "Primes d'apport", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17058, 'PCN2020-LUXEMBURG', 'LIABILIT', '114', 0, "Primes de convers. d'obligat. en actions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17059, 'PCN2020-LUXEMBURG', 'LIABILIT', '115', 0, "App. en cap. prop. non rému. par titres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17060, 'PCN2020-LUXEMBURG', 'LIABILIT', '122', 0, "Réserves de mise en équivalence", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17061, 'PCN2020-LUXEMBURG', 'LIABILIT', '123', 0, "Plus-values sur écarts de conver. immun.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17062, 'PCN2020-LUXEMBURG', 'LIABILIT', '128', 0, "Autres réserves de réévaluation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17063, 'PCN2020-LUXEMBURG', 'LIABILIT', '131', 0, "Réserve légale", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17064, 'PCN2020-LUXEMBURG', 'LIABILIT', '132', 0, "Rés. pour act. propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17065, 'PCN2020-LUXEMBURG', 'LIABILIT', '133', 0, "Réserves statutaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17066, 'PCN2020-LUXEMBURG', 'LIABILIT', '1381', 0, "Autres réserves disponibles", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17067, 'PCN2020-LUXEMBURG', 'LIABILIT', '13821', 0, "Réserve pour l'impôt sur la fortune (IF)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17068, 'PCN2020-LUXEMBURG', 'LIABILIT', '13822', 0, "Réserves en application de la juste val.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17069, 'PCN2020-LUXEMBURG', 'LIABILIT', '138231', 0, "Plus-values immunisées à réinvestir", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17070, 'PCN2020-LUXEMBURG', 'LIABILIT', '138232', 0, "Plus-values immunisées réinvesties", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17071, 'PCN2020-LUXEMBURG', 'LIABILIT', '13828', 0, "Réserves non disp. non visées ci-dessus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17072, 'PCN2020-LUXEMBURG', 'LIABILIT', '1411', 0, "Résultats reportés en instance d'affect.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17073, 'PCN2020-LUXEMBURG', 'LIABILIT', '1412', 0, "Résultats reportés (affectés)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17074, 'PCN2020-LUXEMBURG', 'LIABILIT', '142', 0, "Résultat de l'exercice", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17075, 'PCN2020-LUXEMBURG', 'LIABILIT', '15', 0, "Acomptes sur dividendes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17076, 'PCN2020-LUXEMBURG', 'LIABILIT', '1611', 0, "Frais de développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17077, 'PCN2020-LUXEMBURG', 'LIABILIT', '16121', 0, "acquis à titre onéreux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17078, 'PCN2020-LUXEMBURG', 'LIABILIT', '16122', 0, "créés par l'entreprise elle-même", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17079, 'PCN2020-LUXEMBURG', 'LIABILIT', '1613', 0, "Fonds de comm., acquis à titre onéreux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17080, 'PCN2020-LUXEMBURG', 'LIABILIT', '1621', 0, "Subv. sur terrains, aménag. et constr.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17081, 'PCN2020-LUXEMBURG', 'LIABILIT', '1622', 0, "Subv. sur installations techn. et mach.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17082, 'PCN2020-LUXEMBURG', 'LIABILIT', '1623', 0, "Subv. autr. instal./outil./mob./m. roul.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17083, 'PCN2020-LUXEMBURG', 'LIABILIT', '168', 0, "Autres subventions d'invest. en capital", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17084, 'PCN2020-LUXEMBURG', 'LIABILIT', '181', 0, "Prov. pour pensions et oblig. simil.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17085, 'PCN2020-LUXEMBURG', 'LIABILIT', '182', 0, "Provisions pour impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17086, 'PCN2020-LUXEMBURG', 'LIABILIT', '183', 0, "Provisions pour impôts différés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17087, 'PCN2020-LUXEMBURG', 'LIABILIT', '1881', 0, "Provisions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17088, 'PCN2020-LUXEMBURG', 'LIABILIT', '1882', 0, "Provisions financières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17089, 'PCN2020-LUXEMBURG', 'LIABILIT', '1921', 0, "dont la durée résiduelle est <1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17090, 'PCN2020-LUXEMBURG', 'LIABILIT', '1922', 0, "dont la durée résiduelle est >1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17091, 'PCN2020-LUXEMBURG', 'LIABILIT', '1931', 0, "dont la durée résiduelle est <1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17092, 'PCN2020-LUXEMBURG', 'LIABILIT', '1932', 0, "dont la durée résiduelle est >1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17093, 'PCN2020-LUXEMBURG', 'LIABILIT', '1941', 0, "dont la durée résiduelle est <1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17094, 'PCN2020-LUXEMBURG', 'LIABILIT', '1942', 0, "dont la durée résiduelle est >1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17095, 'PCN2020-LUXEMBURG', 'ASSETS', '201', 0, "Frais de constit. et de premier établis.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17096, 'PCN2020-LUXEMBURG', 'ASSETS', '203', 0, "Frais d'aug. cap., d'opé. div. (F, S, T)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17097, 'PCN2020-LUXEMBURG', 'ASSETS', '204', 0, "Frais d'émission d'emprunts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17098, 'PCN2020-LUXEMBURG', 'ASSETS', '208', 0, "Autres frais assimilés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17099, 'PCN2020-LUXEMBURG', 'ASSETS', '211', 0, "Frais de développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17100, 'PCN2020-LUXEMBURG', 'ASSETS', '21211', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17101, 'PCN2020-LUXEMBURG', 'ASSETS', '21212', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17102, 'PCN2020-LUXEMBURG', 'ASSETS', '21213', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17103, 'PCN2020-LUXEMBURG', 'ASSETS', '21214', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17104, 'PCN2020-LUXEMBURG', 'ASSETS', '212151', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17105, 'PCN2020-LUXEMBURG', 'ASSETS', '212152', 0, "Quotas d'ém. de gaz à effet de serre", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17106, 'PCN2020-LUXEMBURG', 'ASSETS', '212158', 0, "Aut. drts et val. sim. acq. à tit. onér.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17107, 'PCN2020-LUXEMBURG', 'ASSETS', '21221', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17108, 'PCN2020-LUXEMBURG', 'ASSETS', '21222', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17109, 'PCN2020-LUXEMBURG', 'ASSETS', '21223', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17110, 'PCN2020-LUXEMBURG', 'ASSETS', '21224', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17111, 'PCN2020-LUXEMBURG', 'ASSETS', '212251', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17112, 'PCN2020-LUXEMBURG', 'ASSETS', '212258', 0, "Aut.drts/val.sim. créés par ent. elle-m.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17113, 'PCN2020-LUXEMBURG', 'ASSETS', '213', 0, "Fonds de comm. acquis à tit. onéreux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17114, 'PCN2020-LUXEMBURG', 'ASSETS', '214', 0, "Acomp. versés et immob. Incorp en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17115, 'PCN2020-LUXEMBURG', 'ASSETS', '221111', 0, "Terrains bâtis", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17116, 'PCN2020-LUXEMBURG', 'ASSETS', '221112', 0, "Droits immobiliers et assimilés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17117, 'PCN2020-LUXEMBURG', 'ASSETS', '221118', 0, "Autres terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17118, 'PCN2020-LUXEMBURG', 'ASSETS', '22112', 0, "Terrains à l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17119, 'PCN2020-LUXEMBURG', 'ASSETS', '22121', 0, "Agencem. et aménag. de terrains au Lux.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17120, 'PCN2020-LUXEMBURG', 'ASSETS', '22122', 0, "Agencem. et aménag. de terrains étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17121, 'PCN2020-LUXEMBURG', 'ASSETS', '221311', 0, "Constructions / Bâtiments résidentiels", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17122, 'PCN2020-LUXEMBURG', 'ASSETS', '221312', 0, "Constructions / Bâtiments non résiden.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17123, 'PCN2020-LUXEMBURG', 'ASSETS', '221313', 0, "Constructions / Bâtiments à usage mixte", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17124, 'PCN2020-LUXEMBURG', 'ASSETS', '221318', 0, "Autres constructions / bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17125, 'PCN2020-LUXEMBURG', 'ASSETS', '22132', 0, "Constructions / Bâtiments à l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17126, 'PCN2020-LUXEMBURG', 'ASSETS', '22141', 0, "Agen. et amén. de constr./bâtim. au Lux.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17127, 'PCN2020-LUXEMBURG', 'ASSETS', '22142', 0, "Agen. et amén. de constr./bâtim. étrang.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17128, 'PCN2020-LUXEMBURG', 'ASSETS', '22151', 0, "Immeubles de placement au Luxembourg", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17129, 'PCN2020-LUXEMBURG', 'ASSETS', '22152', 0, "Immeubles de placement à l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17130, 'PCN2020-LUXEMBURG', 'ASSETS', '2221', 0, "Installations techniques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17131, 'PCN2020-LUXEMBURG', 'ASSETS', '2222', 0, "Machines", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17132, 'PCN2020-LUXEMBURG', 'ASSETS', '2231', 0, "Equip. de transport et de manutention", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17133, 'PCN2020-LUXEMBURG', 'ASSETS', '2232', 0, "Véhicules de transport", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17134, 'PCN2020-LUXEMBURG', 'ASSETS', '2233', 0, "Outillage", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17135, 'PCN2020-LUXEMBURG', 'ASSETS', '2234', 0, "Mobilier", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17136, 'PCN2020-LUXEMBURG', 'ASSETS', '2235', 0, "Matériel informatique", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17137, 'PCN2020-LUXEMBURG', 'ASSETS', '223501', 0, "Amortissement sur Matériel roulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17138, 'PCN2020-LUXEMBURG', 'ASSETS', '223509', 0, "Amortissement sur MAC Book Air", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17139, 'PCN2020-LUXEMBURG', 'ASSETS', '2236', 0, "Cheptel", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17140, 'PCN2020-LUXEMBURG', 'ASSETS', '2237', 0, "Emballages récupérables", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17141, 'PCN2020-LUXEMBURG', 'ASSETS', '2238', 0, "Autres installations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17142, 'PCN2020-LUXEMBURG', 'ASSETS', '22411', 0, "Terrains, aménag. et constr. au Lux.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17143, 'PCN2020-LUXEMBURG', 'ASSETS', '22412', 0, "Terrains, aménag. et constr. étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17144, 'PCN2020-LUXEMBURG', 'ASSETS', '2242', 0, "Installations techniques et machines", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17145, 'PCN2020-LUXEMBURG', 'ASSETS', '2243', 0, "Aut. install., outil., mob., mat. roul.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17146, 'PCN2020-LUXEMBURG', 'ASSETS', '231', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17147, 'PCN2020-LUXEMBURG', 'ASSETS', '232', 0, "Créances sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17148, 'PCN2020-LUXEMBURG', 'ASSETS', '233', 0, "Participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17149, 'PCN2020-LUXEMBURG', 'ASSETS', '234', 0, "Créances sur des entr. lien particip.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17150, 'PCN2020-LUXEMBURG', 'ASSETS', '235111', 0, "Actions cotées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17151, 'PCN2020-LUXEMBURG', 'ASSETS', '235112', 0, "Actions non cotées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17152, 'PCN2020-LUXEMBURG', 'ASSETS', '23518', 0, "Aut. titres immob. (droit de propriété)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17153, 'PCN2020-LUXEMBURG', 'ASSETS', '23521', 0, "Obligations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17154, 'PCN2020-LUXEMBURG', 'ASSETS', '23528', 0, "Autres titres immob. (droit de créance)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17155, 'PCN2020-LUXEMBURG', 'ASSETS', '2353', 0, "Parts d'OPC", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17156, 'PCN2020-LUXEMBURG', 'ASSETS', '2358', 0, "Autres titres ayant le caractère d'immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17157, 'PCN2020-LUXEMBURG', 'ASSETS', '2361', 0, "Prêts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17158, 'PCN2020-LUXEMBURG', 'ASSETS', '2362', 0, "Dépôts et cautionnements versés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17159, 'PCN2020-LUXEMBURG', 'ASSETS', '2363', 0, "Créances immobilisées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17160, 'PCN2020-LUXEMBURG', 'ASSETS', '301', 0, "Stocks de matières premières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17161, 'PCN2020-LUXEMBURG', 'ASSETS', '303', 0, "Stocks de matières et fourn. consom.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17162, 'PCN2020-LUXEMBURG', 'ASSETS', '304', 0, "Stocks d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17163, 'PCN2020-LUXEMBURG', 'ASSETS', '311', 0, "Stocks de produits en cours de fabric.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17164, 'PCN2020-LUXEMBURG', 'ASSETS', '312', 0, "Commandes en cours - produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17165, 'PCN2020-LUXEMBURG', 'ASSETS', '313', 0, "Commandes en cours - prest. de serv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17166, 'PCN2020-LUXEMBURG', 'ASSETS', '314', 0, "Immeubles en construction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17167, 'PCN2020-LUXEMBURG', 'ASSETS', '315', 0, "Ac.déd./stks.prod.en co. fabr./com.en c.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17168, 'PCN2020-LUXEMBURG', 'ASSETS', '321', 0, "Stocks de produits finis", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17169, 'PCN2020-LUXEMBURG', 'ASSETS', '322', 0, "Stocks de produits intermédiaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17170, 'PCN2020-LUXEMBURG', 'ASSETS', '323', 0, "Stks prod.résid.(déch.,reb.,mat.récup.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17171, 'PCN2020-LUXEMBURG', 'ASSETS', '361', 0, "Stocks de marchandises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17172, 'PCN2020-LUXEMBURG', 'ASSETS', '3621', 0, "Stocks de terrains au Luxembourg", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17173, 'PCN2020-LUXEMBURG', 'ASSETS', '3622', 0, "Stocks de terrains à l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17174, 'PCN2020-LUXEMBURG', 'ASSETS', '3631', 0, "Stocks d'immeubles au Luxembourg", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17175, 'PCN2020-LUXEMBURG', 'ASSETS', '3632', 0, "Stocks d'immeubles à l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17176, 'PCN2020-LUXEMBURG', 'ASSETS', '37', 0, "Acomptes versés sur stocks", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17177, 'PCN2020-LUXEMBURG', 'ASSETS', '4011', 0, "Clients", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17178, 'PCN2020-LUXEMBURG', 'ASSETS', '4012', 0, "Clients - Effets à recevoir", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17179, 'PCN2020-LUXEMBURG', 'ASSETS', '4013', 0, "Clients douteux ou litigieux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17180, 'PCN2020-LUXEMBURG', 'ASSETS', '4014', 0, "Clients - Factures à établir", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17181, 'PCN2020-LUXEMBURG', 'ASSETS', '4015', 0, "Clients créditeurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17182, 'PCN2020-LUXEMBURG', 'ASSETS', '4019', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17183, 'PCN2020-LUXEMBURG', 'ASSETS', '4021', 0, "Clients", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17184, 'PCN2020-LUXEMBURG', 'ASSETS', '4025', 0, "Clients créditeurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17185, 'PCN2020-LUXEMBURG', 'ASSETS', '4029', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17186, 'PCN2020-LUXEMBURG', 'ASSETS', '41111', 0, "Ventes et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17187, 'PCN2020-LUXEMBURG', 'ASSETS', '41112', 0, "Prêts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17188, 'PCN2020-LUXEMBURG', 'ASSETS', '41118', 0, "Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17189, 'PCN2020-LUXEMBURG', 'ASSETS', '41119', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17190, 'PCN2020-LUXEMBURG', 'ASSETS', '41121', 0, "Ventes et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17191, 'PCN2020-LUXEMBURG', 'ASSETS', '41122', 0, "Prêts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17192, 'PCN2020-LUXEMBURG', 'ASSETS', '41128', 0, "Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17193, 'PCN2020-LUXEMBURG', 'ASSETS', '41129', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17194, 'PCN2020-LUXEMBURG', 'ASSETS', '41211', 0, "Ventes et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17195, 'PCN2020-LUXEMBURG', 'ASSETS', '41212', 0, "Prêts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17196, 'PCN2020-LUXEMBURG', 'ASSETS', '41218', 0, "Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17197, 'PCN2020-LUXEMBURG', 'ASSETS', '41219', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17198, 'PCN2020-LUXEMBURG', 'ASSETS', '41221', 0, "Ventes et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17199, 'PCN2020-LUXEMBURG', 'ASSETS', '41222', 0, "Prêts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17200, 'PCN2020-LUXEMBURG', 'ASSETS', '41228', 0, "Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17201, 'PCN2020-LUXEMBURG', 'ASSETS', '41229', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17202, 'PCN2020-LUXEMBURG', 'ASSETS', '42111', 0, "Avances et acomptes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17203, 'PCN2020-LUXEMBURG', 'ASSETS', '42119', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17204, 'PCN2020-LUXEMBURG', 'ASSETS', '4212', 0, "Cr./assoc. ou act.(aut. qu'ent. liées)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17205, 'PCN2020-LUXEMBURG', 'ASSETS', '42121', 0, "De Franco Vincent", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17206, 'PCN2020-LUXEMBURG', 'ASSETS', '42131', 0, "Subventions d'investissement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17207, 'PCN2020-LUXEMBURG', 'ASSETS', '42132', 0, "Subventions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17208, 'PCN2020-LUXEMBURG', 'ASSETS', '42138', 0, "Autres subventions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17209, 'PCN2020-LUXEMBURG', 'ASSETS', '42141', 0, "Impôt sur le revenu des coll. (IRC)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17210, 'PCN2020-LUXEMBURG', 'ASSETS', '42142', 0, "Impôt commercial communal (ICC)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17211, 'PCN2020-LUXEMBURG', 'ASSETS', '42143', 0, "Impôt sur la fortune (IF)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17212, 'PCN2020-LUXEMBURG', 'ASSETS', '42144', 0, "Retenue d'impôt sur trait. et salaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17213, 'PCN2020-LUXEMBURG', 'ASSETS', '42145', 0, "Retenue d'impôt sur rev. de cap. mobil.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17214, 'PCN2020-LUXEMBURG', 'ASSETS', '42146', 0, "Retenue d'impôt sur les tantièmes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17215, 'PCN2020-LUXEMBURG', 'ASSETS', '42148', 0, "ACD - Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17216, 'PCN2020-LUXEMBURG', 'ASSETS', '4215', 0, "Admin. des Douanes et Accises (ADA)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17217, 'PCN2020-LUXEMBURG', 'ASSETS', '421611', 0, "TVA en amont", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17218, 'PCN2020-LUXEMBURG', 'ASSETS', '421612', 0, "TVA à recevoir", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17219, 'PCN2020-LUXEMBURG', 'ASSETS', '421613', 0, "TVA acomptes versés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17220, 'PCN2020-LUXEMBURG', 'ASSETS', '421618', 0, "TVA - Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17221, 'PCN2020-LUXEMBURG', 'ASSETS', '421621', 0, "Droits d'enregistrement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17222, 'PCN2020-LUXEMBURG', 'ASSETS', '421622', 0, "Taxe d'abonnement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17223, 'PCN2020-LUXEMBURG', 'ASSETS', '421628', 0, "Autres impôts indirects", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17224, 'PCN2020-LUXEMBURG', 'ASSETS', '42168', 0, "AED - Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17225, 'PCN2020-LUXEMBURG', 'ASSETS', '42171', 0, "Centre Commun de Sécurité Sociale (CCSS)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17226, 'PCN2020-LUXEMBURG', 'ASSETS', '42172', 0, "Remboursement mutualité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17227, 'PCN2020-LUXEMBURG', 'ASSETS', '42178', 0, "Autres organismes sociaux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17228, 'PCN2020-LUXEMBURG', 'ASSETS', '421811', 0, "TVA étrangères", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17229, 'PCN2020-LUXEMBURG', 'ASSETS', '421818', 0, "Autres impôts étrangers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17230, 'PCN2020-LUXEMBURG', 'ASSETS', '42187', 0, "Instruments financiers dérivés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17231, 'PCN2020-LUXEMBURG', 'ASSETS', '42188', 0, "Autres créances diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17232, 'PCN2020-LUXEMBURG', 'ASSETS', '42189', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17233, 'PCN2020-LUXEMBURG', 'ASSETS', '4221', 0, "Personnel - Avances et acomptes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17234, 'PCN2020-LUXEMBURG', 'ASSETS', '4222', 0, "Cr./assoc. ou act.(aut. qu'ent. liées)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17235, 'PCN2020-LUXEMBURG', 'ASSETS', '42231', 0, "Subventions d'investissement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17236, 'PCN2020-LUXEMBURG', 'ASSETS', '42232', 0, "Subventions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17237, 'PCN2020-LUXEMBURG', 'ASSETS', '42238', 0, "Autres subventions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17238, 'PCN2020-LUXEMBURG', 'ASSETS', '42287', 0, "Instruments financiers dérivés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17239, 'PCN2020-LUXEMBURG', 'ASSETS', '42288', 0, "Autres créances diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17240, 'PCN2020-LUXEMBURG', 'ASSETS', '42289', 0, "Corrections de valeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17241, 'PCN2020-LUXEMBURG', 'LIABILIT', '4311', 0, "Acomptes reçus sur commandes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17242, 'PCN2020-LUXEMBURG', 'LIABILIT', '4312', 0, "Stks pr. en c.fab.,com. en c. - ac. reç.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17243, 'PCN2020-LUXEMBURG', 'LIABILIT', '4321', 0, "Acomptes reçus sur commandes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17244, 'PCN2020-LUXEMBURG', 'LIABILIT', '4322', 0, "Stk. pr. en c. fab., com. en c.-ac. reç.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17245, 'PCN2020-LUXEMBURG', 'LIABILIT', '44111', 0, "Fournisseurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17246, 'PCN2020-LUXEMBURG', 'LIABILIT', '44112', 0, "Fournisseurs - Factures non parvenues", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17247, 'PCN2020-LUXEMBURG', 'LIABILIT', '44113', 0, "Fournisseurs débiteurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17248, 'PCN2020-LUXEMBURG', 'LIABILIT', '44121', 0, "Fournisseurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17249, 'PCN2020-LUXEMBURG', 'LIABILIT', '44123', 0, "Fournisseurs débiteurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17250, 'PCN2020-LUXEMBURG', 'LIABILIT', '4421', 0, "Effets à payer dont la durée résid. <1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17251, 'PCN2020-LUXEMBURG', 'LIABILIT', '4422', 0, "Effets à payer dont la durée résid. >1an", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17252, 'PCN2020-LUXEMBURG', 'LIABILIT', '45111', 0, "Achats et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17253, 'PCN2020-LUXEMBURG', 'LIABILIT', '45112', 0, "Emprunts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17254, 'PCN2020-LUXEMBURG', 'LIABILIT', '45118', 0, "Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17255, 'PCN2020-LUXEMBURG', 'LIABILIT', '45121', 0, "Achats et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17256, 'PCN2020-LUXEMBURG', 'LIABILIT', '45122', 0, "Emprunts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17257, 'PCN2020-LUXEMBURG', 'LIABILIT', '45128', 0, "Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17258, 'PCN2020-LUXEMBURG', 'LIABILIT', '45211', 0, "Achats et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17259, 'PCN2020-LUXEMBURG', 'LIABILIT', '45212', 0, "Emprunts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17260, 'PCN2020-LUXEMBURG', 'LIABILIT', '45218', 0, "Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17261, 'PCN2020-LUXEMBURG', 'LIABILIT', '45221', 0, "Achats et prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17262, 'PCN2020-LUXEMBURG', 'LIABILIT', '45222', 0, "Emprunts et avances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17263, 'PCN2020-LUXEMBURG', 'LIABILIT', '45228', 0, "Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17264, 'PCN2020-LUXEMBURG', 'LIABILIT', '4611', 0, "Administrations communales", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17265, 'PCN2020-LUXEMBURG', 'LIABILIT', '461211', 0, "IRC - charge fiscale estimée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17266, 'PCN2020-LUXEMBURG', 'LIABILIT', '461212', 0, "IRC - dette fiscale à payer", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17267, 'PCN2020-LUXEMBURG', 'LIABILIT', '461221', 0, "ICC - charge fiscale estimée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17268, 'PCN2020-LUXEMBURG', 'LIABILIT', '461222', 0, "ICC - dette fiscale à payer", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17269, 'PCN2020-LUXEMBURG', 'LIABILIT', '461231', 0, "IF - charge fiscale estimée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17270, 'PCN2020-LUXEMBURG', 'LIABILIT', '461232', 0, "IF - dette fiscale à payer", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17271, 'PCN2020-LUXEMBURG', 'LIABILIT', '46124', 0, "Retenue d'impôt sur trait. et sal. (RTS)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17272, 'PCN2020-LUXEMBURG', 'LIABILIT', '46125', 0, "Retenue d'impôt sur revenus de capitaux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17273, 'PCN2020-LUXEMBURG', 'LIABILIT', '46126', 0, "Retenue d'impôt sur les tantièmes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17274, 'PCN2020-LUXEMBURG', 'LIABILIT', '46128', 0, "ACD - Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17275, 'PCN2020-LUXEMBURG', 'LIABILIT', '4613', 0, "Admin. des Douanes et Accises (ADA)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17276, 'PCN2020-LUXEMBURG', 'LIABILIT', '461411', 0, "TVA en aval", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17277, 'PCN2020-LUXEMBURG', 'LIABILIT', '461412', 0, "TVA à payer", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17278, 'PCN2020-LUXEMBURG', 'LIABILIT', '461413', 0, "TVA acomptes reçus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17279, 'PCN2020-LUXEMBURG', 'LIABILIT', '461418', 0, "TVA - Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17280, 'PCN2020-LUXEMBURG', 'LIABILIT', '461421', 0, "Droits d'enregistrement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17281, 'PCN2020-LUXEMBURG', 'LIABILIT', '461422', 0, "Taxe d'abonnement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17282, 'PCN2020-LUXEMBURG', 'LIABILIT', '461428', 0, "Autres impôts indirects", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17283, 'PCN2020-LUXEMBURG', 'LIABILIT', '46148', 0, "AED - Autres dettes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17284, 'PCN2020-LUXEMBURG', 'LIABILIT', '46151', 0, "TVA étrangères", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17285, 'PCN2020-LUXEMBURG', 'LIABILIT', '46158', 0, "Autres impôts étrangers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17286, 'PCN2020-LUXEMBURG', 'LIABILIT', '461611', 0, "TVA AMONT", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17287, 'PCN2020-LUXEMBURG', 'LIABILIT', '4621', 0, "Centre Commun de Sécurité Sociale (CCSS)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17288, 'PCN2020-LUXEMBURG', 'LIABILIT', '4622', 0, "Organismes étrangers de sécurité sociale", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17289, 'PCN2020-LUXEMBURG', 'LIABILIT', '4628', 0, "Autres organismes sociaux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17290, 'PCN2020-LUXEMBURG', 'LIABILIT', '4711', 0, "Dépôts et cautionnements reçus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17291, 'PCN2020-LUXEMBURG', 'LIABILIT', '4712', 0, "Dettes/ass. et act. (aut. qu'ent. liées)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17292, 'PCN2020-LUXEMBURG', 'LIABILIT', '4713', 0, "Dettes / admin., gér., aut. org. assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17293, 'PCN2020-LUXEMBURG', 'LIABILIT', '4714', 0, "De Franco Vincent", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17294, 'PCN2020-LUXEMBURG', 'LIABILIT', '47141', 0, "Desloges Mickael", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17295, 'PCN2020-LUXEMBURG', 'LIABILIT', '4715', 0, "Etat-Q.ém.gaz à eff.serre à rest.à l'ac.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17296, 'PCN2020-LUXEMBURG', 'LIABILIT', '47161', 0, "Autres emprunts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17297, 'PCN2020-LUXEMBURG', 'LIABILIT', '47162', 0, "Dettes de leasing", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17298, 'PCN2020-LUXEMBURG', 'LIABILIT', '47163', 0, "Rentes viagères", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17299, 'PCN2020-LUXEMBURG', 'LIABILIT', '47168', 0, "Autres dettes assimilées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17300, 'PCN2020-LUXEMBURG', 'LIABILIT', '4717', 0, "Instruments financiers dérivés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17301, 'PCN2020-LUXEMBURG', 'LIABILIT', '4718', 0, "Autres dettes diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17302, 'PCN2020-LUXEMBURG', 'LIABILIT', '4721', 0, "Dépôts et cautionnements reçus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17303, 'PCN2020-LUXEMBURG', 'LIABILIT', '4722', 0, "Dettes/ass. et act. (aut. qu'ent. liées)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17304, 'PCN2020-LUXEMBURG', 'LIABILIT', '4723', 0, "Dettes / admin., gér., aut. org. assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17305, 'PCN2020-LUXEMBURG', 'LIABILIT', '4724', 0, "Dettes envers le personnel", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17306, 'PCN2020-LUXEMBURG', 'LIABILIT', '47261', 0, "Autres emprunts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17307, 'PCN2020-LUXEMBURG', 'LIABILIT', '47262', 0, "Dettes de leasing", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17308, 'PCN2020-LUXEMBURG', 'LIABILIT', '47263', 0, "Rentes viagères", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17309, 'PCN2020-LUXEMBURG', 'LIABILIT', '47268', 0, "Autres dettes assimilées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17310, 'PCN2020-LUXEMBURG', 'LIABILIT', '4727', 0, "Instruments financiers dérivés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17311, 'PCN2020-LUXEMBURG', 'LIABILIT', '4728', 0, "Autres dettes diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17312, 'PCN2020-LUXEMBURG', 'LIABILIT', '481', 0, "Charges à report. (sur 1 ou plus. exer.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17313, 'PCN2020-LUXEMBURG', 'LIABILIT', '482', 0, "Produits à report.(sur 1 ou plus. exer.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17314, 'PCN2020-LUXEMBURG', 'LIABILIT', '483', 0, "Etat-Q.ém.gaz à eff.serre assim. ou all.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17315, 'PCN2020-LUXEMBURG', 'LIABILIT', '484', 0, "Comptes transit. ou d'attente - Actif", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17316, 'PCN2020-LUXEMBURG', 'LIABILIT', '485', 0, "Comptes transit. ou d'attente - Passif", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17317, 'PCN2020-LUXEMBURG', 'LIABILIT', '486', 0, "Comptes de liaison (succursales) - Actif", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17318, 'PCN2020-LUXEMBURG', 'LIABILIT', '487', 0, "Comptes de liaison (succurs.) - Passif", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17319, 'PCN2020-LUXEMBURG', 'ASSETS', '501', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17320, 'PCN2020-LUXEMBURG', 'ASSETS', '502', 0, "Actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17321, 'PCN2020-LUXEMBURG', 'ASSETS', '503', 0, "Parts dans des entrep. lien particip.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17322, 'PCN2020-LUXEMBURG', 'ASSETS', '5081', 0, "Actions - Titres cotés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17323, 'PCN2020-LUXEMBURG', 'ASSETS', '5082', 0, "Actions - Titres non cotés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17324, 'PCN2020-LUXEMBURG', 'ASSETS', '5083', 0, "Obl.,aut.cr.émis.par l'ent.rach.par elle", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17325, 'PCN2020-LUXEMBURG', 'ASSETS', '5084', 0, "Obligations - Titres cotés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17326, 'PCN2020-LUXEMBURG', 'ASSETS', '5085', 0, "Obligations - Titres non cotés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17327, 'PCN2020-LUXEMBURG', 'ASSETS', '5088', 0, "Autres valeurs mobilières diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17328, 'PCN2020-LUXEMBURG', 'ASSETS', '5131', 0, "Raiffeisen LU83 - 6555", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17329, 'PCN2020-LUXEMBURG', 'ASSETS', '5132', 0, "Banques et CCP : découverts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17330, 'PCN2020-LUXEMBURG', 'ASSETS', '516', 0, "Caisse", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17331, 'PCN2020-LUXEMBURG', 'ASSETS', '5171', 0, "Virements internes : solde débiteur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17332, 'PCN2020-LUXEMBURG', 'ASSETS', '5172', 0, "Virements internes : solde créditeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17333, 'PCN2020-LUXEMBURG', 'ASSETS', '518', 0, "Autres avoirs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17334, 'PCN2020-LUXEMBURG', 'EXPENSE', '601', 0, "Achats de matières premières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17335, 'PCN2020-LUXEMBURG', 'EXPENSE', '60311', 0, "Combustibles solides", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17336, 'PCN2020-LUXEMBURG', 'EXPENSE', '60312', 0, "Combustibles liquides", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17337, 'PCN2020-LUXEMBURG', 'EXPENSE', '60313', 0, "Gaz", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17338, 'PCN2020-LUXEMBURG', 'EXPENSE', '60314', 0, "Eau et eaux usées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17339, 'PCN2020-LUXEMBURG', 'EXPENSE', '60315', 0, "Electricité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17340, 'PCN2020-LUXEMBURG', 'EXPENSE', '6032', 0, "Produits d'entretien", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17341, 'PCN2020-LUXEMBURG', 'EXPENSE', '6033', 0, "Fourn., pet.équip.-atelier, usine, maga.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17342, 'PCN2020-LUXEMBURG', 'EXPENSE', '6034', 0, "Vêtements professionnels", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17343, 'PCN2020-LUXEMBURG', 'EXPENSE', '6035', 0, "Fournitures administratives et de bureau", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17344, 'PCN2020-LUXEMBURG', 'EXPENSE', '6036', 0, "Carburants", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17345, 'PCN2020-LUXEMBURG', 'EXPENSE', '6037', 0, "Lubrifiants", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17346, 'PCN2020-LUXEMBURG', 'EXPENSE', '6038', 0, "Autres fournitures consommables", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17347, 'PCN2020-LUXEMBURG', 'EXPENSE', '604', 0, "Achats d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17348, 'PCN2020-LUXEMBURG', 'EXPENSE', '6061', 0, "Achats de marchandises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17349, 'PCN2020-LUXEMBURG', 'EXPENSE', '6062', 0, "Achats de terrains destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17350, 'PCN2020-LUXEMBURG', 'EXPENSE', '6063', 0, "Achats d'immeubles destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17351, 'PCN2020-LUXEMBURG', 'EXPENSE', '6071', 0, "Variation des stocks de matières prem.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17352, 'PCN2020-LUXEMBURG', 'EXPENSE', '6073', 0, "Variation stks mat. et fournit. consomm.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17353, 'PCN2020-LUXEMBURG', 'EXPENSE', '6074', 0, "Variation des stocks d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17354, 'PCN2020-LUXEMBURG', 'EXPENSE', '60761', 0, "Marchandises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17355, 'PCN2020-LUXEMBURG', 'EXPENSE', '60762', 0, "Terrains destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17356, 'PCN2020-LUXEMBURG', 'EXPENSE', '60763', 0, "Immeubles destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17357, 'PCN2020-LUXEMBURG', 'EXPENSE', '60811', 0, "Travail à façon", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17358, 'PCN2020-LUXEMBURG', 'EXPENSE', '60812', 0, "Recherche et développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17359, 'PCN2020-LUXEMBURG', 'EXPENSE', '60813', 0, "Frais d'architectes et d'ingénieurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17360, 'PCN2020-LUXEMBURG', 'EXPENSE', '60814', 0, "Sous-trait. Incorp. aux ouvrag. et prod.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17361, 'PCN2020-LUXEMBURG', 'EXPENSE', '6082', 0, "Aut. ach. mat. inco. aux ouvr. et prod.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17362, 'PCN2020-LUXEMBURG', 'EXPENSE', '6083', 0, "Ach. quo. d'ém.gaz eff. serre et assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17363, 'PCN2020-LUXEMBURG', 'EXPENSE', '6088', 0, "Autres achats incorp. aux ouvr. et prod.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17364, 'PCN2020-LUXEMBURG', 'EXPENSE', '6091', 0, "RRR sur achats de matières premières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17365, 'PCN2020-LUXEMBURG', 'EXPENSE', '6093', 0, "RRR sur achats mat. et fourn. consomm.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17366, 'PCN2020-LUXEMBURG', 'EXPENSE', '6094', 0, "RRR sur achats d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17367, 'PCN2020-LUXEMBURG', 'EXPENSE', '6096', 0, "RRR/ach.march., autr.biens dest. revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17368, 'PCN2020-LUXEMBURG', 'EXPENSE', '6098', 0, "RRR / achats incorp. aux ouvra. et prod.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17369, 'PCN2020-LUXEMBURG', 'EXPENSE', '6099', 0, "RRR non affectés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17370, 'PCN2020-LUXEMBURG', 'EXPENSE', '61111', 0, "Terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17371, 'PCN2020-LUXEMBURG', 'EXPENSE', '61112', 0, "Constructions / Bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17372, 'PCN2020-LUXEMBURG', 'EXPENSE', '61123', 0, "Matériel roulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17373, 'PCN2020-LUXEMBURG', 'EXPENSE', '61128', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17374, 'PCN2020-LUXEMBURG', 'EXPENSE', '6113', 0, "Charges locatives et de copropriété", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17375, 'PCN2020-LUXEMBURG', 'EXPENSE', '6114', 0, "Leasing financier immobilier", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17376, 'PCN2020-LUXEMBURG', 'EXPENSE', '61153', 0, "Matériel roulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17377, 'PCN2020-LUXEMBURG', 'EXPENSE', '61158', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17378, 'PCN2020-LUXEMBURG', 'EXPENSE', '6121', 0, "S.-trait.géné.(non inc. aux ouv.et pro.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17379, 'PCN2020-LUXEMBURG', 'EXPENSE', '61221', 0, "Constructions / Bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17380, 'PCN2020-LUXEMBURG', 'EXPENSE', '61223', 0, "Matériel roulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17381, 'PCN2020-LUXEMBURG', 'EXPENSE', '61228', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17382, 'PCN2020-LUXEMBURG', 'EXPENSE', '6131', 0, "Commissions et courtages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17383, 'PCN2020-LUXEMBURG', 'EXPENSE', '61311', 0, "CCSS Santé", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17384, 'PCN2020-LUXEMBURG', 'EXPENSE', '6132', 0, "Services informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17385, 'PCN2020-LUXEMBURG', 'EXPENSE', '61332', 0, "Frais sur émission d'emprunts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17386, 'PCN2020-LUXEMBURG', 'EXPENSE', '61333', 0, "Frais cpts,comm. banc.,drts garde/tit.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17387, 'PCN2020-LUXEMBURG', 'EXPENSE', '61334', 0, "Frais sur moyens de paiements électro.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17388, 'PCN2020-LUXEMBURG', 'EXPENSE', '61336', 0, "Rémunérations d'affacturage", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17389, 'PCN2020-LUXEMBURG', 'EXPENSE', '61338', 0, "Aut.serv.banc.et ass.(<> int.&fr.assim.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17390, 'PCN2020-LUXEMBURG', 'EXPENSE', '61341', 0, "Honoraires juridiq.,de conten. et assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17391, 'PCN2020-LUXEMBURG', 'EXPENSE', '61342', 0, "Honoraires compta.,fisc.,audit et assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17392, 'PCN2020-LUXEMBURG', 'EXPENSE', '61348', 0, "Autres honoraires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17393, 'PCN2020-LUXEMBURG', 'EXPENSE', '6135', 0, "Frais d'actes notariés et assimilés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17394, 'PCN2020-LUXEMBURG', 'EXPENSE', '6138', 0, "Aut. rémunérat. d'interméd., honoraires.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17395, 'PCN2020-LUXEMBURG', 'EXPENSE', '61411', 0, "Constructions / Bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17396, 'PCN2020-LUXEMBURG', 'EXPENSE', '61412', 0, "Matériel roulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17397, 'PCN2020-LUXEMBURG', 'EXPENSE', '61418', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17398, 'PCN2020-LUXEMBURG', 'EXPENSE', '6142', 0, "Assurance sur biens pris en location", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17399, 'PCN2020-LUXEMBURG', 'EXPENSE', '6143', 0, "Assurance-transport", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17400, 'PCN2020-LUXEMBURG', 'EXPENSE', '6144', 0, "Assurance risque d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17401, 'PCN2020-LUXEMBURG', 'EXPENSE', '6145', 0, "Assurance insolvabilité clients", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17402, 'PCN2020-LUXEMBURG', 'EXPENSE', '6146', 0, "Assurance responsabilité civile", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17403, 'PCN2020-LUXEMBURG', 'EXPENSE', '6148', 0, "Autres assurances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17404, 'PCN2020-LUXEMBURG', 'EXPENSE', '61511', 0, "Annonces et insertions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17405, 'PCN2020-LUXEMBURG', 'EXPENSE', '61512', 0, "Echantillons", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17406, 'PCN2020-LUXEMBURG', 'EXPENSE', '61513', 0, "Foires et expositions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17407, 'PCN2020-LUXEMBURG', 'EXPENSE', '61514', 0, "Cadeaux à la clientèle", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17408, 'PCN2020-LUXEMBURG', 'EXPENSE', '61515', 0, "Catalogues et imprimés et publications", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17409, 'PCN2020-LUXEMBURG', 'EXPENSE', '61516', 0, "Dons courants", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17410, 'PCN2020-LUXEMBURG', 'EXPENSE', '61517', 0, "Sponsoring", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17411, 'PCN2020-LUXEMBURG', 'EXPENSE', '61518', 0, "Autres achats de services publicitaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17412, 'PCN2020-LUXEMBURG', 'EXPENSE', '615211', 0, "Direction(le cas éch. exploit.et assoc.)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17413, 'PCN2020-LUXEMBURG', 'EXPENSE', '615212', 0, "Personnel", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17414, 'PCN2020-LUXEMBURG', 'EXPENSE', '61522', 0, "Frais de déménagement de l'entreprise", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17415, 'PCN2020-LUXEMBURG', 'EXPENSE', '61523', 0, "Missions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17416, 'PCN2020-LUXEMBURG', 'EXPENSE', '61524', 0, "Réceptions et frais de représentation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17417, 'PCN2020-LUXEMBURG', 'EXPENSE', '61531', 0, "Frais postaux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17418, 'PCN2020-LUXEMBURG', 'EXPENSE', '61532', 0, "Frais de télécommunication", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17419, 'PCN2020-LUXEMBURG', 'EXPENSE', '6161', 0, "Transports sur achats", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17420, 'PCN2020-LUXEMBURG', 'EXPENSE', '6162', 0, "Transports sur ventes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17421, 'PCN2020-LUXEMBURG', 'EXPENSE', '6165', 0, "Transports collectifs du personnel", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17422, 'PCN2020-LUXEMBURG', 'EXPENSE', '6168', 0, "Autres transports", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17423, 'PCN2020-LUXEMBURG', 'EXPENSE', '6171', 0, "Personnel intérimaire", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17424, 'PCN2020-LUXEMBURG', 'EXPENSE', '6172', 0, "Personnel prêté à l'entreprise", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17425, 'PCN2020-LUXEMBURG', 'EXPENSE', '6181', 0, "Documentation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17426, 'PCN2020-LUXEMBURG', 'EXPENSE', '6182', 0, "Frais format., colloq., sémin., confér.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17427, 'PCN2020-LUXEMBURG', 'EXPENSE', '6183', 0, "Elimination déchets indust.& non indust.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17428, 'PCN2020-LUXEMBURG', 'EXPENSE', '61841', 0, "Combustibles solides", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17429, 'PCN2020-LUXEMBURG', 'EXPENSE', '61842', 0, "Combustibles liquid.(mazout, carbur,...)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17430, 'PCN2020-LUXEMBURG', 'EXPENSE', '61843', 0, "Gaz", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17431, 'PCN2020-LUXEMBURG', 'EXPENSE', '61844', 0, "Eau et eaux usées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17432, 'PCN2020-LUXEMBURG', 'EXPENSE', '61845', 0, "Electricité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17433, 'PCN2020-LUXEMBURG', 'EXPENSE', '61851', 0, "Fournitures administratives et de bureau", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17434, 'PCN2020-LUXEMBURG', 'EXPENSE', '61852', 0, "Petit équipement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17435, 'PCN2020-LUXEMBURG', 'EXPENSE', '61853', 0, "Vêtements professionnels", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17436, 'PCN2020-LUXEMBURG', 'EXPENSE', '61854', 0, "Produits d'entretien", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17437, 'PCN2020-LUXEMBURG', 'EXPENSE', '61858', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17438, 'PCN2020-LUXEMBURG', 'EXPENSE', '6186', 0, "Frais de surveillance et de gardiennage", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17439, 'PCN2020-LUXEMBURG', 'EXPENSE', '6187', 0, "Cotisations aux associations profession.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17440, 'PCN2020-LUXEMBURG', 'EXPENSE', '6188', 0, "Autres charges externes diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17441, 'PCN2020-LUXEMBURG', 'EXPENSE', '619', 0, "RRR obt.&non direct.déd.des autr.ch.ext.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17442, 'PCN2020-LUXEMBURG', 'EXPENSE', '62111', 0, "Salaires de base", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17443, 'PCN2020-LUXEMBURG', 'EXPENSE', '621121', 0, "Dimanche", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17444, 'PCN2020-LUXEMBURG', 'EXPENSE', '621122', 0, "Jours fériés légaux", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17445, 'PCN2020-LUXEMBURG', 'EXPENSE', '621123', 0, "Heures supplémentaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17446, 'PCN2020-LUXEMBURG', 'EXPENSE', '621128', 0, "Autres suppléments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17447, 'PCN2020-LUXEMBURG', 'EXPENSE', '62114', 0, "Gratifications, primes et commissions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17448, 'PCN2020-LUXEMBURG', 'EXPENSE', '62115', 0, "Avantages en nature", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17449, 'PCN2020-LUXEMBURG', 'EXPENSE', '62116', 0, "Indemnités de licenciement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17450, 'PCN2020-LUXEMBURG', 'EXPENSE', '62117', 0, "Trimestre de faveur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17451, 'PCN2020-LUXEMBURG', 'EXPENSE', '6218', 0, "Autres avantages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17452, 'PCN2020-LUXEMBURG', 'EXPENSE', '6219', 0, "Remboursements sur salaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17453, 'PCN2020-LUXEMBURG', 'EXPENSE', '6221', 0, "Etudiants", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17454, 'PCN2020-LUXEMBURG', 'EXPENSE', '6222', 0, "Salaires occasionnels", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17455, 'PCN2020-LUXEMBURG', 'EXPENSE', '6228', 0, "Autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17456, 'PCN2020-LUXEMBURG', 'EXPENSE', '6231', 0, "Charges sociales couvrant les pensions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17457, 'PCN2020-LUXEMBURG', 'EXPENSE', '62311', 0, "CCSS", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17458, 'PCN2020-LUXEMBURG', 'EXPENSE', '62312', 0, "Caisse nationale de pension", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17459, 'PCN2020-LUXEMBURG', 'EXPENSE', '6232', 0, "Autr.ch.soc.(inclus maladie, accid.,...)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17460, 'PCN2020-LUXEMBURG', 'EXPENSE', '62411', 0, "Primes à des fonds de pensions extérieur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17461, 'PCN2020-LUXEMBURG', 'EXPENSE', '62412', 0, "Variations / prov. pour pensions compl.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17462, 'PCN2020-LUXEMBURG', 'EXPENSE', '62413', 0, "Retenue d'impôt sur pension complément.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17463, 'PCN2020-LUXEMBURG', 'EXPENSE', '62414', 0, "Prime d'assurance insolvabilité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17464, 'PCN2020-LUXEMBURG', 'EXPENSE', '62415', 0, "Pensions complém.versées par l'employeur", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17465, 'PCN2020-LUXEMBURG', 'EXPENSE', '6248', 0, "Autr. frais de perso.non visés ci-dessus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17466, 'PCN2020-LUXEMBURG', 'EXPENSE', '6311', 0, "DCV sur frais de constit. & 1er établis.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17467, 'PCN2020-LUXEMBURG', 'EXPENSE', '6313', 0, "DCV frais augm.capit.&d'opér.div.(F,S,T)", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17468, 'PCN2020-LUXEMBURG', 'EXPENSE', '6314', 0, "DCV sur frais d'émission d'emprunts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17469, 'PCN2020-LUXEMBURG', 'EXPENSE', '6318', 0, "DCV sur autres frais assimilés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17470, 'PCN2020-LUXEMBURG', 'EXPENSE', '6321', 0, "DCV sur frais de développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17471, 'PCN2020-LUXEMBURG', 'EXPENSE', '6322', 0, "DCV/conc.,brev.,lic.,marq.,drt&vals sim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17472, 'PCN2020-LUXEMBURG', 'EXPENSE', '6323', 0, "DCV/fonds de comm. si acq. à titre onér.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17473, 'PCN2020-LUXEMBURG', 'EXPENSE', '6324', 0, "DCV/acomp. versés&immo, incorp. en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17474, 'PCN2020-LUXEMBURG', 'EXPENSE', '63311', 0, "DCV sur terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17475, 'PCN2020-LUXEMBURG', 'EXPENSE', '63312', 0, "DCV/agencements et aménag. de terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17476, 'PCN2020-LUXEMBURG', 'EXPENSE', '63313', 0, "DCV sur constructions / bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17477, 'PCN2020-LUXEMBURG', 'EXPENSE', '63314', 0, "DCV sur agencem.&aménag. constr./bâtim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17478, 'PCN2020-LUXEMBURG', 'EXPENSE', '63315', 0, "AJV sur immeubles de placement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17479, 'PCN2020-LUXEMBURG', 'EXPENSE', '6332', 0, "DCV sur install. techniques et machines", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17480, 'PCN2020-LUXEMBURG', 'EXPENSE', '6333', 0, "DCV/aut. Install.,outill.,mob.,mat.roul.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17481, 'PCN2020-LUXEMBURG', 'EXPENSE', '6334', 0, "DCV/acom. versés et immo. copr. en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17482, 'PCN2020-LUXEMBURG', 'EXPENSE', '6341', 0, "DCV sur stocks de mat. prem. et consomm.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17483, 'PCN2020-LUXEMBURG', 'EXPENSE', '6342', 0, "DCV/stks prod. en c. fab. et comm. en c.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17484, 'PCN2020-LUXEMBURG', 'EXPENSE', '6343', 0, "DCV sur stocks de produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17485, 'PCN2020-LUXEMBURG', 'EXPENSE', '6344', 0, "DCV/stks de march.&aut.biens dest. vente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17486, 'PCN2020-LUXEMBURG', 'EXPENSE', '6345', 0, "DCV sur acomptes versés sur stocks", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17487, 'PCN2020-LUXEMBURG', 'EXPENSE', '6351', 0, "DCV/créan. résult. de ventes&prest serv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17488, 'PCN2020-LUXEMBURG', 'EXPENSE', '6352', 0, "DCV/créan./entrep. liées&liens de part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17489, 'PCN2020-LUXEMBURG', 'EXPENSE', '6353', 0, "DCV sur autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17490, 'PCN2020-LUXEMBURG', 'EXPENSE', '6354', 0, "AJV sur créances de l'actif circulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17491, 'PCN2020-LUXEMBURG', 'EXPENSE', '6411', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17492, 'PCN2020-LUXEMBURG', 'EXPENSE', '6412', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17493, 'PCN2020-LUXEMBURG', 'EXPENSE', '6413', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17494, 'PCN2020-LUXEMBURG', 'EXPENSE', '6414', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17495, 'PCN2020-LUXEMBURG', 'EXPENSE', '64151', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17496, 'PCN2020-LUXEMBURG', 'EXPENSE', '64158', 0, "Autres droits et valeurs similaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17497, 'PCN2020-LUXEMBURG', 'EXPENSE', '642', 0, "Indemnités, dommages et intérêts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17498, 'PCN2020-LUXEMBURG', 'EXPENSE', '6431', 0, "Jetons de présence", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17499, 'PCN2020-LUXEMBURG', 'EXPENSE', '6432', 0, "Tantièmes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17500, 'PCN2020-LUXEMBURG', 'EXPENSE', '6438', 0, "Autres rémunérations assimilées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17501, 'PCN2020-LUXEMBURG', 'EXPENSE', '64411', 0, "Valeur comptable d'immo. incorp. cédées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17502, 'PCN2020-LUXEMBURG', 'EXPENSE', '64412', 0, "Produits de cession d'immo. incorp.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17503, 'PCN2020-LUXEMBURG', 'EXPENSE', '64421', 0, "Valeur comptable d'immo. corp. cédées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17504, 'PCN2020-LUXEMBURG', 'EXPENSE', '64422', 0, "Produits de cession d'immo. corp.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17505, 'PCN2020-LUXEMBURG', 'EXPENSE', '6451', 0, "Créan. résult. de ventes et prest. serv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17506, 'PCN2020-LUXEMBURG', 'EXPENSE', '6452', 0, "Créances sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17507, 'PCN2020-LUXEMBURG', 'EXPENSE', '6453', 0, "Créances sur des entrep. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17508, 'PCN2020-LUXEMBURG', 'EXPENSE', '6454', 0, "Autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17509, 'PCN2020-LUXEMBURG', 'EXPENSE', '6461', 0, "Impôt foncier", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17510, 'PCN2020-LUXEMBURG', 'EXPENSE', '6462', 0, "TVA non récupérable", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17511, 'PCN2020-LUXEMBURG', 'EXPENSE', '6463', 0, "Drts / les march. en prov. de l'étranger", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17512, 'PCN2020-LUXEMBURG', 'EXPENSE', '6464', 0, "Drts accises à la prod. & taxe de conso.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17513, 'PCN2020-LUXEMBURG', 'EXPENSE', '64651', 0, "Droits d'enregistrement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17514, 'PCN2020-LUXEMBURG', 'EXPENSE', '64658', 0, "Autr.Drts d'enreg.&timbre,drts d'hypoth.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17515, 'PCN2020-LUXEMBURG', 'EXPENSE', '6466', 0, "Taxes sur les véhicules", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17516, 'PCN2020-LUXEMBURG', 'EXPENSE', '6467', 0, "Taxe de cabaretage", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17517, 'PCN2020-LUXEMBURG', 'EXPENSE', '6468', 0, "Autres droits et taxes", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17518, 'PCN2020-LUXEMBURG', 'EXPENSE', '647', 0, "Dotations aux plus-values immunisées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17519, 'PCN2020-LUXEMBURG', 'EXPENSE', '6481', 0, "Amendes, sanctions et pénalités", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17520, 'PCN2020-LUXEMBURG', 'EXPENSE', '6488', 0, "Charges d'exploitation diverses", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17521, 'PCN2020-LUXEMBURG', 'EXPENSE', '6491', 0, "Dotations aux provisions pour impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17522, 'PCN2020-LUXEMBURG', 'EXPENSE', '6492', 0, "Dotations aux provisions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17523, 'PCN2020-LUXEMBURG', 'EXPENSE', '65111', 0, "DCV sur parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17524, 'PCN2020-LUXEMBURG', 'EXPENSE', '65112', 0, "DCV sur créan. sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17525, 'PCN2020-LUXEMBURG', 'EXPENSE', '65113', 0, "DCV sur participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17526, 'PCN2020-LUXEMBURG', 'EXPENSE', '65114', 0, "DCV / créan. / des entr. lien particip.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17527, 'PCN2020-LUXEMBURG', 'EXPENSE', '65115', 0, "DCV sur titres ayant le caract. d'immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17528, 'PCN2020-LUXEMBURG', 'EXPENSE', '65116', 0, "DCV sur prêts, dépôts et créances immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17529, 'PCN2020-LUXEMBURG', 'EXPENSE', '6512', 0, "AJV sur immobilisations financières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17530, 'PCN2020-LUXEMBURG', 'EXPENSE', '65211', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17531, 'PCN2020-LUXEMBURG', 'EXPENSE', '65212', 0, "Créances sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17532, 'PCN2020-LUXEMBURG', 'EXPENSE', '65213', 0, "Participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17533, 'PCN2020-LUXEMBURG', 'EXPENSE', '65214', 0, "Créances sur des entrep. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17534, 'PCN2020-LUXEMBURG', 'EXPENSE', '65215', 0, "Titres ayant le caractère d'immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17535, 'PCN2020-LUXEMBURG', 'EXPENSE', '65216', 0, "Prêts, dépôts et créances immobilisés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17536, 'PCN2020-LUXEMBURG', 'EXPENSE', '652211', 0, "Val. compt. parts cédées dans entr.liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17537, 'PCN2020-LUXEMBURG', 'EXPENSE', '652212', 0, "Produits cession parts dans entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17538, 'PCN2020-LUXEMBURG', 'EXPENSE', '652221', 0, "Val. compt. créances cédées/entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17539, 'PCN2020-LUXEMBURG', 'EXPENSE', '652222', 0, "Prod. de cession de créan./entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17540, 'PCN2020-LUXEMBURG', 'EXPENSE', '652231', 0, "Valeur comptable de participation cédée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17541, 'PCN2020-LUXEMBURG', 'EXPENSE', '652232', 0, "Produits de cession de participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17542, 'PCN2020-LUXEMBURG', 'EXPENSE', '652241', 0, "Val.compt. créan. cédées/entr.lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17543, 'PCN2020-LUXEMBURG', 'EXPENSE', '652242', 0, "Prod. cess. créan. / entr. lien. part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17544, 'PCN2020-LUXEMBURG', 'EXPENSE', '652251', 0, "Val.compt. titr. cédés ayant carac.immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17545, 'PCN2020-LUXEMBURG', 'EXPENSE', '652252', 0, "Prod. de cess. titr. ayant carac. immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17546, 'PCN2020-LUXEMBURG', 'EXPENSE', '652261', 0, "Val.compt. prêts,dép.,créan. immo. cédés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17547, 'PCN2020-LUXEMBURG', 'EXPENSE', '652262', 0, "Prod. de cess. prêts,dép.,créan. immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17548, 'PCN2020-LUXEMBURG', 'EXPENSE', '65311', 0, "DCV sur parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17549, 'PCN2020-LUXEMBURG', 'EXPENSE', '65312', 0, "DCV sur actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17550, 'PCN2020-LUXEMBURG', 'EXPENSE', '65313', 0, "DCV sur parts dans des entr. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17551, 'PCN2020-LUXEMBURG', 'EXPENSE', '65318', 0, "DCV sur autres valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17552, 'PCN2020-LUXEMBURG', 'EXPENSE', '6532', 0, "AJV sur valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17553, 'PCN2020-LUXEMBURG', 'EXPENSE', '65411', 0, "sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17554, 'PCN2020-LUXEMBURG', 'EXPENSE', '65412', 0, "sur des entrepr. lien participation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17555, 'PCN2020-LUXEMBURG', 'EXPENSE', '65413', 0, "sur autres créances de l'actif circulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17556, 'PCN2020-LUXEMBURG', 'EXPENSE', '65421', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17557, 'PCN2020-LUXEMBURG', 'EXPENSE', '65422', 0, "Actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17558, 'PCN2020-LUXEMBURG', 'EXPENSE', '65423', 0, "Parts dans des entrepr. lien particip.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17559, 'PCN2020-LUXEMBURG', 'EXPENSE', '65428', 0, "Autres valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17560, 'PCN2020-LUXEMBURG', 'EXPENSE', '65511', 0, "Int. sur emprunts obligat. - entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17561, 'PCN2020-LUXEMBURG', 'EXPENSE', '65512', 0, "Intérêts sur emprunts obligat. - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17562, 'PCN2020-LUXEMBURG', 'EXPENSE', '65521', 0, "Intérêts sur comptes bancaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17563, 'PCN2020-LUXEMBURG', 'EXPENSE', '65522', 0, "Intérêts bancaires sur opérat. de finan.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17564, 'PCN2020-LUXEMBURG', 'EXPENSE', '655231', 0, "Int. sur leasings finan. - entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17565, 'PCN2020-LUXEMBURG', 'EXPENSE', '655232', 0, "Intérêts sur leasing financier - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17566, 'PCN2020-LUXEMBURG', 'EXPENSE', '6553', 0, "Intérêts sur dettes commerciales", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17567, 'PCN2020-LUXEMBURG', 'EXPENSE', '65541', 0, "Intérêts sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17568, 'PCN2020-LUXEMBURG', 'EXPENSE', '65542', 0, "Intérêts sur des entrepr. lien particip.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17569, 'PCN2020-LUXEMBURG', 'EXPENSE', '65551', 0, "Escomp. et fr./eff. de comm.-entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17570, 'PCN2020-LUXEMBURG', 'EXPENSE', '65552', 0, "Escomp. et fr./effets de comm. - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17571, 'PCN2020-LUXEMBURG', 'EXPENSE', '65561', 0, "Escomptes accordés - entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17572, 'PCN2020-LUXEMBURG', 'EXPENSE', '65562', 0, "Escomptes accordés - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17573, 'PCN2020-LUXEMBURG', 'EXPENSE', '65581', 0, "Int./autres emprunts&dettes-entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17574, 'PCN2020-LUXEMBURG', 'EXPENSE', '65582', 0, "Int./autres emprunts&dettes - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17575, 'PCN2020-LUXEMBURG', 'EXPENSE', '6561', 0, "Pertes de change - entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17576, 'PCN2020-LUXEMBURG', 'EXPENSE', '6562', 0, "Pertes de change - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17577, 'PCN2020-LUXEMBURG', 'EXPENSE', '657', 0, "Quote-p. dans perte entr. mises équival.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17578, 'PCN2020-LUXEMBURG', 'EXPENSE', '6581', 0, "Aut. charges financières - entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17579, 'PCN2020-LUXEMBURG', 'EXPENSE', '6582', 0, "Autres charges financières - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17580, 'PCN2020-LUXEMBURG', 'EXPENSE', '6591', 0, "Dot. aux provisions fin. - entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17581, 'PCN2020-LUXEMBURG', 'EXPENSE', '6592', 0, "Dot. aux provisions fin. - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17582, 'PCN2020-LUXEMBURG', 'EXPENSE', '6711', 0, "IRC - exercice courant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17583, 'PCN2020-LUXEMBURG', 'EXPENSE', '6712', 0, "IRC - exercices antérieurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17584, 'PCN2020-LUXEMBURG', 'EXPENSE', '6721', 0, "ICC - exercice courant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17585, 'PCN2020-LUXEMBURG', 'EXPENSE', '6722', 0, "ICC - exercices antérieurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17586, 'PCN2020-LUXEMBURG', 'EXPENSE', '6731', 0, "Retenues d'impôt à la source", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17587, 'PCN2020-LUXEMBURG', 'EXPENSE', '67321', 0, "Exercice courant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17588, 'PCN2020-LUXEMBURG', 'EXPENSE', '67322', 0, "Exercices antérieurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17589, 'PCN2020-LUXEMBURG', 'EXPENSE', '6733', 0, "Impôts supportés par entrep. non résid.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17590, 'PCN2020-LUXEMBURG', 'EXPENSE', '6738', 0, "Autres impôts étrangers sur le résultat", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17591, 'PCN2020-LUXEMBURG', 'EXPENSE', '679', 0, "Dot. aux provisions pour impôts différés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17592, 'PCN2020-LUXEMBURG', 'EXPENSE', '6811', 0, "IF - exercice courant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17593, 'PCN2020-LUXEMBURG', 'EXPENSE', '6812', 0, "IF - exercices antérieurs", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17594, 'PCN2020-LUXEMBURG', 'EXPENSE', '682', 0, "Taxe d'abonnement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17595, 'PCN2020-LUXEMBURG', 'EXPENSE', '683', 0, "Impôts étrangers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17596, 'PCN2020-LUXEMBURG', 'EXPENSE', '688', 0, "Autres impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17597, 'PCN2020-LUXEMBURG', 'INCOME', '7021', 0, "Ventes de produits finis", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17598, 'PCN2020-LUXEMBURG', 'INCOME', '7022', 0, "Ventes de produits intermédiaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17599, 'PCN2020-LUXEMBURG', 'INCOME', '7023', 0, "Ventes de produits résiduels", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17600, 'PCN2020-LUXEMBURG', 'INCOME', '7029', 0, "Ventes de produits en cours de fabric.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17601, 'PCN2020-LUXEMBURG', 'INCOME', '70311', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17602, 'PCN2020-LUXEMBURG', 'INCOME', '70312', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17603, 'PCN2020-LUXEMBURG', 'INCOME', '70313', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17604, 'PCN2020-LUXEMBURG', 'INCOME', '70314', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17605, 'PCN2020-LUXEMBURG', 'INCOME', '703151', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17606, 'PCN2020-LUXEMBURG', 'INCOME', '703158', 0, "Autres droits et valeurs similaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17607, 'PCN2020-LUXEMBURG', 'INCOME', '70321', 0, "Revenus de location immobilière", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17608, 'PCN2020-LUXEMBURG', 'INCOME', '70322', 0, "Revenus de location mobilière", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17609, 'PCN2020-LUXEMBURG', 'INCOME', '7033', 0, "Prest. de serv. non visées ci-dessus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17610, 'PCN2020-LUXEMBURG', 'INCOME', '7039', 0, "Prestations de serv. en cours de réalis.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17611, 'PCN2020-LUXEMBURG', 'INCOME', '704', 0, "Ventes d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17612, 'PCN2020-LUXEMBURG', 'INCOME', '705', 0, "Commissions et courtages obtenus", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17613, 'PCN2020-LUXEMBURG', 'INCOME', '7061', 0, "Ventes de marchandises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17614, 'PCN2020-LUXEMBURG', 'INCOME', '7062', 0, "Ventes de terrains destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17615, 'PCN2020-LUXEMBURG', 'INCOME', '7063', 0, "Ventes d'immeubles destinés à la revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17616, 'PCN2020-LUXEMBURG', 'INCOME', '708', 0, "Autres éléments du chiffre d'affaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17617, 'PCN2020-LUXEMBURG', 'INCOME', '7092', 0, "RRR sur ventes de produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17618, 'PCN2020-LUXEMBURG', 'INCOME', '7093', 0, "RRR sur prestations de services", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17619, 'PCN2020-LUXEMBURG', 'INCOME', '7094', 0, "RRR sur ventes d'emballages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17620, 'PCN2020-LUXEMBURG', 'INCOME', '7095', 0, "RRR sur commissions et courtages", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17621, 'PCN2020-LUXEMBURG', 'INCOME', '7096', 0, "RRR sur vent.march.&aut.biens dest. rev.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17622, 'PCN2020-LUXEMBURG', 'INCOME', '7098', 0, "RRR sur autres éléments du ch. d'affaire", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17623, 'PCN2020-LUXEMBURG', 'INCOME', '7099', 0, "RRR non affectés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17624, 'PCN2020-LUXEMBURG', 'INCOME', '7111', 0, "Var. stks prod. en cours de fabric.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17625, 'PCN2020-LUXEMBURG', 'INCOME', '7112', 0, "Var. stks : comm. en cours - produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17626, 'PCN2020-LUXEMBURG', 'INCOME', '7113', 0, "Var. stks : comm. en cours - pres. serv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17627, 'PCN2020-LUXEMBURG', 'INCOME', '7114', 0, "Variation des stks : immeub. en constru.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17628, 'PCN2020-LUXEMBURG', 'INCOME', '7121', 0, "Variation des stocks de produits finis", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17629, 'PCN2020-LUXEMBURG', 'INCOME', '7122', 0, "Variation des stks prod. intermédiaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17630, 'PCN2020-LUXEMBURG', 'INCOME', '7123', 0, "Variation des stocks de produits résidu.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17631, 'PCN2020-LUXEMBURG', 'INCOME', '7211', 0, "Frais de développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17632, 'PCN2020-LUXEMBURG', 'INCOME', '72121', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17633, 'PCN2020-LUXEMBURG', 'INCOME', '72122', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17634, 'PCN2020-LUXEMBURG', 'INCOME', '72123', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17635, 'PCN2020-LUXEMBURG', 'INCOME', '72124', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17636, 'PCN2020-LUXEMBURG', 'INCOME', '721251', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17637, 'PCN2020-LUXEMBURG', 'INCOME', '721258', 0, "Autres droits et valeurs similaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17638, 'PCN2020-LUXEMBURG', 'INCOME', '7221', 0, "Terrains, aménagements et constructions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17639, 'PCN2020-LUXEMBURG', 'INCOME', '7222', 0, "Installations techniques et machines", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17640, 'PCN2020-LUXEMBURG', 'INCOME', '7223', 0, "Aut. install., outill., mob, mat. roul.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17641, 'PCN2020-LUXEMBURG', 'INCOME', '7321', 0, "RCV sur frais de développement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17642, 'PCN2020-LUXEMBURG', 'INCOME', '7322', 0, "RV/conc.,brev.,licen.,marq.,drt&val.sim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17643, 'PCN2020-LUXEMBURG', 'INCOME', '7324', 0, "RV/acomp. versés&immob. incorp. en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17644, 'PCN2020-LUXEMBURG', 'INCOME', '73311', 0, "RV sur terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17645, 'PCN2020-LUXEMBURG', 'INCOME', '73312', 0, "RV sur agencements, aménag. de terrains", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17646, 'PCN2020-LUXEMBURG', 'INCOME', '73313', 0, "RCV sur constructions / bâtiments", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17647, 'PCN2020-LUXEMBURG', 'INCOME', '73314', 0, "RV sur agenc., aménag de constr., bâtim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17648, 'PCN2020-LUXEMBURG', 'INCOME', '73315', 0, "AJV sur immeubles de placement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17649, 'PCN2020-LUXEMBURG', 'INCOME', '7332', 0, "RV sur installations techni. et machin.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17650, 'PCN2020-LUXEMBURG', 'INCOME', '7333', 0, "RV/aut. instal.,outill.,mobil.,mat.roul.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17651, 'PCN2020-LUXEMBURG', 'INCOME', '7334', 0, "RV/acompt. versés et immo.copr. en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17652, 'PCN2020-LUXEMBURG', 'INCOME', '7341', 0, "RV sur stocks de mat. prem. et consomm.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17653, 'PCN2020-LUXEMBURG', 'INCOME', '7342', 0, "RV/stks prod.en cours fab.&comm.en cours", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17654, 'PCN2020-LUXEMBURG', 'INCOME', '7343', 0, "RCV sur stocks de produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17655, 'PCN2020-LUXEMBURG', 'INCOME', '7344', 0, "RV/stks march.&aut. biens dest.à revente", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17656, 'PCN2020-LUXEMBURG', 'INCOME', '7345', 0, "RCV sur acomptes versés sur stocks", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17657, 'PCN2020-LUXEMBURG', 'INCOME', '7351', 0, "RV/créan. résult. de ventes&prest. serv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17658, 'PCN2020-LUXEMBURG', 'INCOME', '7352', 0, "RV/créan./entr. liées & entr. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17659, 'PCN2020-LUXEMBURG', 'INCOME', '7353', 0, "RCV sur autres créances", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17660, 'PCN2020-LUXEMBURG', 'INCOME', '7354', 0, "AV sur créances de l'actif circulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17661, 'PCN2020-LUXEMBURG', 'INCOME', '7411', 0, "Concessions", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17662, 'PCN2020-LUXEMBURG', 'INCOME', '7412', 0, "Brevets", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17663, 'PCN2020-LUXEMBURG', 'INCOME', '7413', 0, "Licences informatiques", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17664, 'PCN2020-LUXEMBURG', 'INCOME', '7414', 0, "Marques et franchises", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17665, 'PCN2020-LUXEMBURG', 'INCOME', '74151', 0, "Droits d'auteur et de reproduction", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17666, 'PCN2020-LUXEMBURG', 'INCOME', '74158', 0, "Autres droits et valeurs similaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17667, 'PCN2020-LUXEMBURG', 'INCOME', '7421', 0, "Revenus de location immobilière", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17668, 'PCN2020-LUXEMBURG', 'INCOME', '7422', 0, "Revenus de location mobilière", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17669, 'PCN2020-LUXEMBURG', 'INCOME', '743', 0, "Jetons de prés., tantièm., rémun. assim.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17670, 'PCN2020-LUXEMBURG', 'INCOME', '74411', 0, "Valeur comptable d'immo. incorp. cédées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17671, 'PCN2020-LUXEMBURG', 'INCOME', '74412', 0, "Produits de cession d'immo. incopr.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17672, 'PCN2020-LUXEMBURG', 'INCOME', '74421', 0, "Valeur comptable d'immo. corp. cédées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17673, 'PCN2020-LUXEMBURG', 'INCOME', '74422', 0, "Produits de cession d'immo. corp.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17674, 'PCN2020-LUXEMBURG', 'INCOME', '7451', 0, "Subventions sur produits", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17675, 'PCN2020-LUXEMBURG', 'INCOME', '7452', 0, "Bonifications d'intérêt", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17676, 'PCN2020-LUXEMBURG', 'INCOME', '7453', 0, "Indemnités compensatoires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17677, 'PCN2020-LUXEMBURG', 'INCOME', '7454', 0, "Subventions destinées à promouv. emploi", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17678, 'PCN2020-LUXEMBURG', 'INCOME', '7458', 0, "Autres subventions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17679, 'PCN2020-LUXEMBURG', 'INCOME', '746', 0, "Avantages en nature", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17680, 'PCN2020-LUXEMBURG', 'INCOME', '7471', 0, "Plus-values immunisées non réinvesties", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17681, 'PCN2020-LUXEMBURG', 'INCOME', '7472', 0, "Plus-values immunisées réinvesties", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17682, 'PCN2020-LUXEMBURG', 'INCOME', '7473', 0, "Subventions d'investissement en capital", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17683, 'PCN2020-LUXEMBURG', 'INCOME', '7481', 0, "Indemnités d'assurance", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17684, 'PCN2020-LUXEMBURG', 'INCOME', '7488', 0, "Produits d'exploitation divers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17685, 'PCN2020-LUXEMBURG', 'INCOME', '748801', 0, "Remboursement mutualité", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17686, 'PCN2020-LUXEMBURG', 'INCOME', '7491', 0, "Reprises de provisions pour impôts", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17687, 'PCN2020-LUXEMBURG', 'INCOME', '7492', 0, "Reprises de provisions d'exploitation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17688, 'PCN2020-LUXEMBURG', 'INCOME', '75111', 0, "RV sur parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17689, 'PCN2020-LUXEMBURG', 'INCOME', '75112', 0, "RV sur créances / des entreprises liés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17690, 'PCN2020-LUXEMBURG', 'INCOME', '75113', 0, "RV sur participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17691, 'PCN2020-LUXEMBURG', 'INCOME', '75114', 0, "RV sur créances sur entr. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17692, 'PCN2020-LUXEMBURG', 'INCOME', '75115', 0, "RV sur titres ayant le caractère d'immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17693, 'PCN2020-LUXEMBURG', 'INCOME', '75116', 0, "RV sur prêts, dépôts et créances immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17694, 'PCN2020-LUXEMBURG', 'INCOME', '7512', 0, "AJV sur immobilisations financières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17695, 'PCN2020-LUXEMBURG', 'INCOME', '75211', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17696, 'PCN2020-LUXEMBURG', 'INCOME', '75212', 0, "Créances sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17697, 'PCN2020-LUXEMBURG', 'INCOME', '75213', 0, "Participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17698, 'PCN2020-LUXEMBURG', 'INCOME', '75214', 0, "Créances sur des entrep. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17699, 'PCN2020-LUXEMBURG', 'INCOME', '75215', 0, "Titres ayant le caractère d'immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17700, 'PCN2020-LUXEMBURG', 'INCOME', '75216', 0, "Prêts, dépôts et créances immobilisés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17701, 'PCN2020-LUXEMBURG', 'INCOME', '752211', 0, "Val. compt. parts cédées dans entr.liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17702, 'PCN2020-LUXEMBURG', 'INCOME', '752212', 0, "Prod. de cession parts dans entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17703, 'PCN2020-LUXEMBURG', 'INCOME', '752221', 0, "Val. compt. de créan. cédées/entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17704, 'PCN2020-LUXEMBURG', 'INCOME', '752222', 0, "Prod. de cession créan./des entr. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17705, 'PCN2020-LUXEMBURG', 'INCOME', '752231', 0, "Valeur comptable de participation cédée", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17706, 'PCN2020-LUXEMBURG', 'INCOME', '752232', 0, "Produits de cession de participations", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17707, 'PCN2020-LUXEMBURG', 'INCOME', '752241', 0, "Val.compt. créan. cédées/entr.lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17708, 'PCN2020-LUXEMBURG', 'INCOME', '752242', 0, "Produits cess. de créan./entr.lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17709, 'PCN2020-LUXEMBURG', 'INCOME', '752251', 0, "Val.compt.titre cédé ayant caract.immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17710, 'PCN2020-LUXEMBURG', 'INCOME', '752252', 0, "Prod. cess. titres ayant caract. d'immo.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17711, 'PCN2020-LUXEMBURG', 'INCOME', '752261', 0, "Val.comp. prêts,dépôt,créan.immo. cédés", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17712, 'PCN2020-LUXEMBURG', 'INCOME', '752262', 0, "Prod. cess. prêts, dépôts, créan. immob.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17713, 'PCN2020-LUXEMBURG', 'INCOME', '75311', 0, "RV sur parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17714, 'PCN2020-LUXEMBURG', 'INCOME', '75312', 0, "RV sur actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17715, 'PCN2020-LUXEMBURG', 'INCOME', '75313', 0, "RV sur parts dans des entr. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17716, 'PCN2020-LUXEMBURG', 'INCOME', '75318', 0, "RV sur autres valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17717, 'PCN2020-LUXEMBURG', 'INCOME', '7532', 0, "AJV sur valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17718, 'PCN2020-LUXEMBURG', 'INCOME', '75411', 0, "sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17719, 'PCN2020-LUXEMBURG', 'INCOME', '75412', 0, "sur des entreprises lien participation", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17720, 'PCN2020-LUXEMBURG', 'INCOME', '75413', 0, "sur autres créances de l'actif circulant", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17721, 'PCN2020-LUXEMBURG', 'INCOME', '75421', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17722, 'PCN2020-LUXEMBURG', 'INCOME', '75422', 0, "Actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17723, 'PCN2020-LUXEMBURG', 'INCOME', '75423', 0, "Parts dans des entreprises lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17724, 'PCN2020-LUXEMBURG', 'INCOME', '75428', 0, "Autres valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17725, 'PCN2020-LUXEMBURG', 'INCOME', '75481', 0, "Parts dans des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17726, 'PCN2020-LUXEMBURG', 'INCOME', '75482', 0, "Actions propres ou parts propres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17727, 'PCN2020-LUXEMBURG', 'INCOME', '75483', 0, "Parts dans des entreprises lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17728, 'PCN2020-LUXEMBURG', 'INCOME', '75488', 0, "Autres valeurs mobilières", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17729, 'PCN2020-LUXEMBURG', 'INCOME', '75521', 0, "Intérêts sur comptes bancaires", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17730, 'PCN2020-LUXEMBURG', 'INCOME', '755231', 0, "Intérêts / leasings fin. - entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17731, 'PCN2020-LUXEMBURG', 'INCOME', '755232', 0, "Intérêts sur leasings financiers - autre", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17732, 'PCN2020-LUXEMBURG', 'INCOME', '7553', 0, "Intérêts sur créances commerciales", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17733, 'PCN2020-LUXEMBURG', 'INCOME', '75541', 0, "Intérêts sur des entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17734, 'PCN2020-LUXEMBURG', 'INCOME', '75542', 0, "Intérêts sur des entrep. lien part.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17735, 'PCN2020-LUXEMBURG', 'INCOME', '75551', 0, "Escomptes d'effets de comm.-entrep.liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17736, 'PCN2020-LUXEMBURG', 'INCOME', '75552', 0, "Escomptes d'effets de commerce - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17737, 'PCN2020-LUXEMBURG', 'INCOME', '75561', 0, "Escomptes obtenus - entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17738, 'PCN2020-LUXEMBURG', 'INCOME', '75562', 0, "Escomptes obtenus - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17739, 'PCN2020-LUXEMBURG', 'INCOME', '75581', 0, "Intérêts sur aut. créances-entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17740, 'PCN2020-LUXEMBURG', 'INCOME', '75582', 0, "Intérêts sur autres créances - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17741, 'PCN2020-LUXEMBURG', 'INCOME', '7561', 0, "Gains de change - entreprises liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17742, 'PCN2020-LUXEMBURG', 'INCOME', '7562', 0, "Gains de change - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17743, 'PCN2020-LUXEMBURG', 'INCOME', '757', 0, "Quote-p. bénéf. dans entr.mise en equiv.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17744, 'PCN2020-LUXEMBURG', 'INCOME', '7581', 0, "Autres produits financiers-entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17745, 'PCN2020-LUXEMBURG', 'INCOME', '7582', 0, "Autres produits financiers - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17746, 'PCN2020-LUXEMBURG', 'INCOME', '7591', 0, "Reprises de prov. finan. - entrep. liées", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17747, 'PCN2020-LUXEMBURG', 'INCOME', '7592', 0, "Reprises de provisions finan. - autres", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17748, 'PCN2020-LUXEMBURG', 'INCOME', '771', 0, "Régularisations d'impôt IRC", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17749, 'PCN2020-LUXEMBURG', 'INCOME', '772', 0, "Régularisations d'impôt ICC", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17750, 'PCN2020-LUXEMBURG', 'INCOME', '773', 0, "Régul. d'impôts étrangers / le résultat", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17751, 'PCN2020-LUXEMBURG', 'INCOME', '779', 0, "Reprises de provisions pour impôts diff.", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17752, 'PCN2020-LUXEMBURG', 'INCOME', '781', 0, "Régularisations d'impôt IF", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17753, 'PCN2020-LUXEMBURG', 'INCOME', '782', 0, "Régularisations de taxe d'abonnement", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17754, 'PCN2020-LUXEMBURG', 'INCOME', '783', 0, "Régularisations d'impôts étrangers", '1');
INSERT INTO llx_accounting_account (entity, rowid, fk_pcg_version, pcg_type, account_number, account_parent, label, active) VALUES (1, 17755, 'PCN2020-LUXEMBURG', 'INCOME', '788', 0, "Régularisations d'autres impôts", '1');