set search_path = public,comptaproc,pg_catalog ;


SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;


SELECT pg_catalog.lo_create('2351550');



SELECT pg_catalog.lo_create('2351551');



SELECT pg_catalog.lo_create('2351552');



SELECT pg_catalog.lo_create('2351553');



SELECT pg_catalog.lo_create('2351554');



SELECT pg_catalog.lo_create('2351555');



SELECT pg_catalog.lo_create('2351556');






INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (800, 'Ajout de fiche', 'fiche', 'FICADD');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (805, 'Création, modification et effacement de fiche', 'fiche', 'FIC');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (910, 'création, modification et effacement de catégorie de fiche', 'fiche', 'FICCAT');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1020, 'Effacer les documents du suivi', 'followup', 'RMDOC');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1010, 'Voir les documents du suivi', 'followup', 'VIEWDOC');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1050, 'Modifier le type de document', 'followup', 'PARCATDOC');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1110, 'Enlever une pièce justificative', 'compta', 'RMRECEIPT');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1120, 'Effacer une opération ', 'compta', 'RMOPER');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1210, 'Partager une note', 'note', 'SHARENOTE');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1220, 'Créer une note publique', 'note', 'SHARENOTEPUBLIC');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1230, 'Effacer une note publique', 'note', 'SHARENOTEREMOVE');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1025, 'Ajout d''étiquette', 'followup', 'TAGADD');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1130, 'Modifier le numéro de pièce', 'compta', 'UPDRECEIPT');
INSERT INTO public.action (ac_id, ac_description, ac_module, ac_code) VALUES (1140, 'Modifier la date d''une operation', 'compta', 'UPDDATE');



INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (21, 'Réception commande Client', 'RCL');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (20, 'Réception commande Fournisseur', 'RFO');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (22, 'Réception magazine', 'RMA');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (7, 'Proposition', 'PRP');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (10, 'Note de frais', 'NF');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (5, 'Lettre de rappel', 'LRAP');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (4, 'Facture', 'FAC');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (8, 'Email', 'EML');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (1, 'Document Interne', 'DIN');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (9, 'Divers', 'DIV');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (6, 'Courrier', 'COUR');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (2, 'Bons de commande client', 'BCL');
INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (3, 'Bon de commande Fournisseur', 'BFO');



INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (13, 'Dépenses non admises', '674');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (14, 'Administration des Finances', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (15, 'Autres fiches', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (5, 'Prêt > a un an', '27');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (8, 'Fournisseurs', '400');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (6, 'Prêt < a un an', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (16, 'Contact', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (1, 'Vente Service', '706');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (2, 'Achat Marchandises', '603');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (9, 'Clients', '410');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (10, 'Salaire Administrateur', '644');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (11, 'Salaire Ouvrier', '641');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (12, 'Salaire Employé', '641');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (7, 'Matériel à amortir, immobilisation corporelle', '21');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (3, 'Achat Service et biens divers', '61');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (17, 'Escomptes accordées', '66');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (18, 'Produits Financiers', '76');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (25, 'Compte Salarié / Administrateur', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (4, 'Trésorerie', '51');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (26, 'Projet', NULL);



INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (500000, NULL, 'Stock', false, 15, NULL);
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (1, '604', 'Marchandises', true, 2, 'Achats de marchandises');
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (2, '410', 'Client', true, 9, 'Catégorie qui contient la liste des clients');
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (3, '51', 'Banque', true, 4, 'Catégorie qui contient la liste des comptes financiers: banque, caisse,...');
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (4, '400', 'Fournisseur', true, 8, 'Catégorie qui contient la liste des fournisseurs');
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (5, '61', 'Services & Biens Divers', true, 3, 'Catégorie qui contient la liste des charges diverses');
INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label, fd_create_account, frd_id, fd_description) VALUES (6, '700', 'Vente', true, 1, 'Catégorie qui contient la liste des prestations, marchandises... que l''on vend ');



INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (80, 3, '1');
INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (82, 4, '1');
INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (81, 2, '1');



INSERT INTO public.profile (p_name, p_id, p_desc, with_calc, with_direct_form, with_search_card) VALUES ('Administrateur', 1, 'Profil par défaut pour les adminstrateurs', true, true, 1);
INSERT INTO public.profile (p_name, p_id, p_desc, with_calc, with_direct_form, with_search_card) VALUES ('Utilisateur', 2, 'Profil par défaut pour les utilisateurs', true, true, 1);
INSERT INTO public.profile (p_name, p_id, p_desc, with_calc, with_direct_form, with_search_card) VALUES ('Public', -1, 'faux groupe', NULL, NULL, 1);





















INSERT INTO public.currency (id, cr_code_iso, cr_name) VALUES (0, 'EUR', 'EUR');



INSERT INTO public.jrn_type (jrn_type_id, jrn_desc) VALUES ('VEN', 'Vente');
INSERT INTO public.jrn_type (jrn_type_id, jrn_desc) VALUES ('ACH', 'Achat');
INSERT INTO public.jrn_type (jrn_type_id, jrn_desc) VALUES ('ODS', 'Opérations Diverses');
INSERT INTO public.jrn_type (jrn_type_id, jrn_desc) VALUES ('FIN', 'Banque');



INSERT INTO public.jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_def_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jrn_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code, jrn_def_pj_pref, jrn_def_bank, jrn_def_num_op, jrn_def_description, jrn_enable, currency_id, jrn_def_negative_amount, jrn_def_negative_warning, jrn_def_quantity, jrn_def_pj_padding) VALUES (1, 'Financier', NULL, NULL, '3,2,4,5', '3,2,4,5', 10, 10, true, 'echeance', 'FIN', 'F01', 'F-', 80, 0, 'Concerne tous les mouvements financiers (comptes en banque, caisses, visa...)', 1, 0, '0', 'Attention, ce journal doit utiliser des montants négatifs', 1, 0);
INSERT INTO public.jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_def_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jrn_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code, jrn_def_pj_pref, jrn_def_bank, jrn_def_num_op, jrn_def_description, jrn_enable, currency_id, jrn_def_negative_amount, jrn_def_negative_warning, jrn_def_quantity, jrn_def_pj_padding) VALUES (2, 'Vente', NULL, NULL, '2', '6', 10, 10, true, 'echeance', 'VEN', 'V01', 'V', NULL, NULL, 'Concerne toutes les ventes, notes de crédit envoyées', 1, 0, '0', 'Attention, ce journal doit utiliser des montants négatifs', 1, 5);
INSERT INTO public.jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_def_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jrn_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code, jrn_def_pj_pref, jrn_def_bank, jrn_def_num_op, jrn_def_description, jrn_enable, currency_id, jrn_def_negative_amount, jrn_def_negative_warning, jrn_def_quantity, jrn_def_pj_padding) VALUES (3, 'Achat', NULL, NULL, '1,5', '4', 10, 10, true, 'echeance', 'ACH', 'A01', 'A-', NULL, NULL, 'Concerne tous les achats, factures reçues, notes de crédit reçues et notes de frais', 1, 0, '0', 'Attention, ce journal doit utiliser des montants négatifs', 1, 5);
INSERT INTO public.jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_def_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jrn_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code, jrn_def_pj_pref, jrn_def_bank, jrn_def_num_op, jrn_def_description, jrn_enable, currency_id, jrn_def_negative_amount, jrn_def_negative_warning, jrn_def_quantity, jrn_def_pj_padding) VALUES (4, 'Opération Diverses', '*', NULL, '3,2,4,1,5,500000,6', NULL, 5, 5, false, 'echeance', 'ODS', 'O01', 'O-', NULL, NULL, 'Concerne toutes les opérations comme les amortissements, les comptes TVA, ...', 1, 0, '0', 'Attention, ce journal doit utiliser des montants négatifs', 1, 5);






























INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (33, 'Date Fin', 'date', '8', NULL, 1, 260);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (19, 'Gestion stock', 'card', '22', '[sql] fd_id = 500000 ', 1, 270);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (1, 'Nom', 'text', '22', NULL, 1, 10);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (32, 'Prénom', 'text', '22', NULL, 1, 20);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (9, 'Description', 'text', '22', NULL, 1, 30);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (34, 'Site Web', 'text', '22', NULL, 1, 40);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (30, 'Numero de client', 'text', '22', NULL, 1, 50);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (12, 'Personne de contact ', 'text', '22', NULL, 1, 60);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (25, 'Société', 'card', '22', '[sql] fd_id in (select fd_id from fiche_def where frd_id in (4,8,9,14))', 1, 70);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (27, 'Tél. Portable', 'text', '22', NULL, 1, 100);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (26, 'Fax', 'text', '22', NULL, 1, 120);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (14, 'Adresse ', 'text', '22', NULL, 1, 130);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (15, 'code postal', 'text', '22', NULL, 1, 140);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (24, 'Ville', 'text', '22', NULL, 1, 160);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (4, 'Nom de la banque', 'text', '22', NULL, 1, 170);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (3, 'Compte bancaire', 'text', '22', NULL, 1, 180);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (5, 'Poste Comptable', 'poste', '17', NULL, 1, 190);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (6, 'Prix vente', 'numeric', '6', '4', 1, 200);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (7, 'Prix achat', 'numeric', '6', '4', 1, 210);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (2, 'Taux TVA', 'text', '22', NULL, 1, 220);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (8, 'Durée Amortissement', 'numeric', '6', '2', 1, 230);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (11, 'Montant initial', 'numeric', '6', '2', 1, 240);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (10, 'Date début', 'date', '8', NULL, 1, 250);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (20, 'Partie fiscalement non déductible', 'numeric', '6', '2', 1, 280);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (53, 'Contrepartie pour dépense fiscal. non déd.', 'poste', '17', NULL, 1, 290);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (21, 'TVA non déductible', 'numeric', '6', '2', 1, 300);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (51, 'Contrepartie pour TVA non Ded.', 'poste', '17', NULL, 1, 310);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (22, 'TVA non déductible récupérable par l''impôt', 'numeric', '6', '2', 1, 320);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (50, 'Contrepartie pour TVA récup par impot', 'poste', '17', NULL, 1, 330);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (52, 'Contrepartie pour dépense à charge du gérant', 'poste', '17', NULL, 1, 340);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (31, 'Dépense  charge du grant (partie privé) ', 'numeric', '6', '4', 1, 350);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (23, 'Quick Code', 'text', '22', NULL, 1, 9999);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (18, 'Email ', 'text', '22', NULL, 1, 90);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (17, 'Téléphone ', 'text', '22', NULL, 1, 110);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (16, 'Pays ', 'text', '22', NULL, 1, 150);
INSERT INTO public.attr_def (ad_id, ad_text, ad_type, ad_size, ad_extra, ad_search_followup, ad_default_order) VALUES (13, 'Numéro TVA', 'text', '22', NULL, 1, 80);



INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 2, 220);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 2, 220);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (3, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (3, 2, 220);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 3, 180);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 13, 80);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 14, 130);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 15, 140);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 16, 150);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 17, 110);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 18, 90);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 13, 80);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 14, 130);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 15, 140);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 16, 150);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 17, 110);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 18, 90);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 13, 80);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 14, 130);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 16, 150);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 17, 110);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 18, 90);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 6, 200);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 7, 210);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 6, 200);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 7, 210);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (3, 7, 210);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 19, 270);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 19, 270);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 4, 170);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 10, 250);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 4, 170);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 10, 250);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (10, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (11, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (11, 12, 60);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (12, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (13, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (13, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 8, 230);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 10, 250);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 11, 240);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 11, 240);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 15, 140);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (15, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (15, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (3, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (5, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (6, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (10, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (11, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (12, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (13, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (15, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 24, 160);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 24, 160);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 24, 160);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 17, 110);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 18, 90);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 25, 70);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 26, 120);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 27, 100);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (17, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (17, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (18, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (18, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 4, 170);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 3, 180);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 15, 140);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 16, 150);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 24, 160);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 23, 9999);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (26, 1, 10);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (26, 9, 30);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 32, 20);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (2, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (3, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (13, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 26, 120);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 5, 190);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (8, 34, 40);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (9, 34, 40);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 34, 40);
INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (4, 34, 40);



INSERT INTO public.bilan (b_id, b_name, b_file_template, b_file_form, b_type) VALUES (5, 'Comptes de résultat', 'document/fr_fr/fr_plan_abrege_perso_cr1000.rtf', 'document/fr_fr/fr_plan_abrege_perso_cr1000.form', 'rtf');
INSERT INTO public.bilan (b_id, b_name, b_file_template, b_file_form, b_type) VALUES (1, 'Bilan français', 'document/fr_fr/fr_plan_abrege_perso_bil10000.ods', 'document/fr_fr/fr_plan_abrege_perso_bil10000.form', 'ods');
INSERT INTO public.bilan (b_id, b_name, b_file_template, b_file_form, b_type) VALUES (9, 'ASBL', 'document/fr_be/bnb-asbl.rtf', 'document/fr_be/bnb-asbl.form', 'RTF');






INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('101', 'Capital', '1', 'PAS', 159, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('105', 'Ecarts de réévaluation', '1', 'PAS', 160, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('1061', 'Réserve légale', '1', 'PAS', 161, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('1063', 'Réserves statutaires ou contractuelles', '1', 'PAS', 162, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('1064', 'Réserves réglementées', '1', 'PAS', 163, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('1068', 'Autres réserves', '1', 'PAS', 164, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('108', 'Compte de l''exploitant', '1', 'PAS', 165, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('145', 'Amortissements dérogatoires', '1', 'PAS', 167, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('146', 'Provision spéciale de réévaluation', '1', 'PAS', 168, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('147', 'Plus-values réinvesties', '1', 'PAS', 169, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('148', 'Autres provisions réglementées', '1', 'PAS', 170, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('201', 'Frais d''établissement', '20', 'ACT', 175, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('206', 'Droit au bail', '20', 'ACT', 176, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('207', 'Fonds commercial', '20', 'ACT', 177, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('208', 'Autres immobilisations incorporelles', '20', 'ACT', 178, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('280', 'Amortissements des immobilisations incorporelles', '2', 'ACT', 182, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('281', 'Amortissements des immobilisations corporelles', '2', 'ACT', 183, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('290', 'Provisions pour dépréciation des immobilisations incorporelles', '2', 'ACT', 184, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('291', 'Provisions pour dépréciation des immobilisations corporelles (même ventilation que celle du compte 21)', '2', 'ACT', 185, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('297', 'Provisions pour dépréciation des autres immobilisations financières', '2', 'ACT', 186, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('391', 'Provisions pour dépréciation des matières premières (et fournitures)', '3', 'ACT', 194, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('392', 'Provisions pour dépréciation des autres approvisionnements', '3', 'ACT', 195, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('393', 'Provisions pour dépréciation des en-cours de production de biens', '3', 'ACT', 196, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('394', 'Provisions pour dépréciation des en-cours de production de services', '3', 'ACT', 197, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('395', 'Provisions pour dépréciation des stocks de produits', '3', 'ACT', 198, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('397', 'Provisions pour dépréciation des stocks de marchandises', '3', 'ACT', 199, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('400', 'Fournisseurs et Comptes rattachés', '4', 'ACT', 201, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('409', 'Fournisseurs débiteurs', '4', 'ACT', 202, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('410', 'Clients et Comptes rattachés', '4', 'ACT', 203, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('419', 'Clients créditeurs', '4', 'ACT', 204, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('421', 'Personnel - Rémunérations dues', '4', 'PAS', 205, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('428', 'Personnel - Charges à payer et produits à recevoir', '4', 'PAS', 206, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('444', 'Etat - Impôts sur les bénéfices', '4', 'PAS', 208, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445', 'Etat - Taxes sur le chiffre d''affaires', '4', 'PAS', 209, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('447', 'Autres impôts, taxes et versements assimilés', '4', 'PAS', 210, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('455', 'Associés - Comptes courants', '45', 'PAS', 212, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('481', 'Charges à répartir sur plusieurs exercices', '4', 'PAS', 215, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('486', 'Charges constatées d''avance', '4', 'PAS', 216, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('487', 'Produits constatés d''avance', '4', 'ACT', 217, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('491', 'Provisions pour dépréciation des comptes de clients', '4', 'PAS', 218, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('496', 'Provisions pour dépréciation des comptes de débiteurs divers', '4', 'PAS', 219, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('590', 'Provisions pour dépréciation des valeurs mobilières de placement', '5', 'ACT', 226, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('603', 'variations des stocks (approvisionnements et marchandises)', '6', 'CHA', 229, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('641', 'Rémunérations du personnel', '6', 'CHA', 233, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('644', 'Rémunération du travail de l''exploitant', '6', 'CHA', 234, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('645', 'Charges de sécurité sociale et de prévoyance', '6', 'CHA', 235, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('646', 'Cotisations sociales personnelles de l''exploitant', '6', 'CHA', 236, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('681', 'Dotations aux amortissements et aux provisions - Charges d''exploitation', '6', 'CHA', 240, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('686', 'Dotations aux amortissements et aux provisions - Charges financières', '6', 'CHA', 241, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('687', 'Dotations aux amortissements et aux provisions - Charges exceptionnelles', '6', 'CHA', 242, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('691', 'Participation des salariés aux résultats', '6', 'CHA', 243, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('695', 'Impôts sur les bénéfices', '6', 'CHA', 244, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('697', 'Imposition forfaitaire annuelle des sociétés', '6', 'CHA', 245, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('699', 'Produits - Reports en arrière des déficits', '6', 'CHA', 246, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('701', 'Ventes de produits finis', '7', 'PAS', 248, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('706', 'Prestations de services', '7', 'PAS', 249, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('707', 'Ventes de marchandises', '7', 'PAS', 250, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('708', 'Produits des activités annexes', '7', 'PAS', 251, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('709', 'Rabais, remises et ristournes accordés par l''entreprise', '7', 'PAS', 252, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('713', 'Variation des stocks (en-cours de production, produits)', '7', 'PAS', 253, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('753', 'Jetons de présence et rémunérations d''administrateurs, gérants,...', '75', 'PAS', 258, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('754', 'Ristournes perçues des coopératives (provenant des excédents)', '75', 'PAS', 259, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('755', 'Quotes-parts de résultat sur opérations faites en commun', '75', 'PAS', 260, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('781', 'Reprises sur amortissements et provisions (à inscrire dans les produits d''exploitation)', '7', 'PAS', 263, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('786', 'Reprises sur provisions pour risques (à inscrire dans les produits financiers)', '7', 'PAS', 264, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('787', 'Reprises sur provisions (à inscrire dans les produits exceptionnels)', '7', 'PAS', 265, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456602', 'TVA x% - France métropolitaine - Taux anciens Déductible', '4456', 'ACT', 271, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445702', 'TVA x% - France métropolitaine - Taux anciens Collectée ', '4457', 'PAS', 272, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456603', 'TVA 8,5%  - DOM - Taux normal Déductible', '4456', 'ACT', 273, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445703', 'TVA 8,5%  - DOM - Taux normal Collectée ', '4457', 'PAS', 274, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456604', 'TVA 8,5% - DOM - Taux normal NPR Déductible', '4456', 'ACT', 275, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445704', 'TVA 8,5% - DOM - Taux normal NPR Collectée ', '4457', 'PAS', 276, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456605', 'TVA 2,1% - DOM - Taux réduit Déductible', '4456', 'ACT', 277, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445705', 'TVA 2,1% - DOM - Taux réduit Collectée ', '4457', 'PAS', 278, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456606', 'TVA 1,75% - DOM - Taux I Déductible', '4456', 'ACT', 279, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445706', 'TVA 1,75% - DOM - Taux I Collectée ', '4457', 'PAS', 280, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445701', 'TVA  France métropolitaine - Taux immobilisations Collectée ', '4457', 'PAS', 270, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456607', 'TVA 1,05% - DOM - Taux publications de presse Déductible', '4456', 'ACT', 281, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445707', 'TVA 1,05% - DOM - Taux publications de presse Collectée ', '4457', 'PAS', 282, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456608', 'TVA x% - DOM - Taux octroi de mer Déductible', '4456', 'ACT', 283, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445708', 'TVA x% - DOM - Taux octroi de mer Collectée ', '4457', 'PAS', 284, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456609', 'TVA x% - DOM - Taux immobilisations Déductible', '4456', 'ACT', 285, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445709', 'TVA x% - DOM - Taux immobilisations Collectée ', '4457', 'PAS', 286, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566010', 'TVA 13% - Corse - Taux I Déductible', '4456', 'ACT', 287, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457010', 'TVA 13% - Corse - Taux I Collectée ', '4457', 'PAS', 288, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566011', 'TVA 8% - Corse - Taux II Déductible', '4456', 'ACT', 289, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457011', 'TVA 8% - Corse - Taux II Collectée ', '4457', 'PAS', 290, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566012', 'TVA 2,1% - Corse - Taux III Déductible', '4456', 'ACT', 291, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457012', 'TVA 2,1% - Corse - Taux III Collectée ', '4457', 'PAS', 292, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566013', 'TVA 0,9% - Corse - Taux IV Déductible', '4456', 'ACT', 293, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457013', 'TVA 0,9% - Corse - Taux IV Collectée ', '4457', 'PAS', 294, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566014', 'TVA x% - Corse - Taux immobilisations Déductible', '4456', 'ACT', 295, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457014', 'TVA x% - Corse - Taux immobilisations Collectée ', '4457', 'PAS', 296, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566015', 'TVA x% - Acquisitions intracommunautaires/Pays Déductible', '4456', 'ACT', 297, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457015', 'TVA x% - Acquisitions intracommunautaires/Pays Collectée ', '4457', 'PAS', 298, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566016', 'TVA x% - Acquisitions intracommunautaires immobilisations/Pays Déductible', '4456', 'ACT', 299, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457016', 'TVA x% - Acquisitions intracommunautaires immobilisations/Pays Collectée ', '4457', 'PAS', 300, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566017', 'TVA x% - Non imposable : Achats en franchise Déductible', '4456', 'ACT', 301, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457017', 'TVA x% - Non imposable : Achats en franchise Collectée ', '4457', 'PAS', 302, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566018', 'TVA x% - Non imposable : Exports hors CE/Pays Déductible', '4456', 'ACT', 303, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457018', 'TVA x% - Non imposable : Exports hors CE/Pays Collectée ', '4457', 'PAS', 304, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566019', 'TVA x% - Non imposable : Autres opérations Déductible', '4456', 'ACT', 305, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457019', 'TVA x% - Non imposable : Autres opérations Collectée ', '4457', 'PAS', 306, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44566020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pays Déductible', '4456', 'ACT', 307, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pays Collectée ', '4457', 'PAS', 308, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445662', 'TVA 5,5% - France métropolitaine - Taux réduit', '445', 'PAS', 310, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445663', 'TVA 2,1% - France métropolitaine - Taux super réduit', '445', 'PAS', 311, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44572', 'TVA 5,5% - France métropolitaine - Taux réduit', '445', 'ACT', 313, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44573', 'TVA 2,1% - France métropolitaine - Taux super réduit', '445', 'ACT', 314, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('53', 'Caisse', '5', 'ACT', 223, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('1', 'comptes de capitaux', '0', 'PAS', 158, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('12', 'résultat de l''exercice (bénéfice ou perte)', '1', 'CON', 166, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('15', 'Provisions pour risques et charges', '1', 'PAS', 171, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('16', 'emprunts et dettes assimilees', '1', 'PAS', 172, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('2', 'comptes d''immobilisations', '0', 'ACT', 173, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('20', 'immobilisations incorporelles', '2', 'ACT', 174, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('21', 'immobilisations corporelles', '2', 'ACT', 179, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('23', 'immobilisations en cours', '2', 'ACT', 180, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('27', 'autres immobilisations financieres', '2', 'ACT', 181, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('3', 'comptes de stocks et en cours', '0', 'ACT', 187, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('31', 'matieres premières (et fournitures)', '3', 'ACT', 188, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('32', 'autres approvisionnements', '3', 'ACT', 189, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('33', 'en-cours de production de biens', '3', 'ACT', 190, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('34', 'en-cours de production de services', '3', 'ACT', 191, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('35', 'stocks de produits', '3', 'ACT', 192, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('37', 'stocks de marchandises', '3', 'ACT', 193, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4', 'comptes de tiers', '0', 'CON', 200, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('43', 'Sécurité sociale et autres organismes sociaux', '4', 'PAS', 207, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('45', 'Groupe et associes', '4', 'PAS', 211, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('46', 'Débiteurs divers et créditeurs divers', '4', 'CON', 213, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('47', 'comptes transitoires ou d''attente', '4', 'CON', 214, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('5', 'comptes financiers', '0', 'ACT', 220, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('50', 'valeurs mobilières de placement', '5', 'ACT', 221, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('51', 'banques, établissements financiers et assimilés', '5', 'ACT', 222, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('54', 'régies d''avance et accréditifs', '5', 'ACT', 224, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('58', 'virements internes', '5', 'ACT', 225, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('6', 'comptes de charges', '0', 'CHA', 227, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('60', 'Achats (sauf 603)', '6', 'CHA', 228, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('61', 'autres charges externes - Services extérieurs', '6', 'CHA', 230, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('62', 'autres charges externes - Autres services extérieurs', '6', 'CHA', 231, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('63', 'Impôts, taxes et versements assimiles', '6', 'CHA', 232, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('65', 'Autres charges de gestion courante', '6', 'CHA', 237, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('66', 'Charges financières', '6', 'CHA', 238, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('67', 'Charges exceptionnelles', '6', 'CHA', 239, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('7', 'comptes de produits', '0', 'PAS', 247, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('72', 'Production immobilisée', '7', 'PAS', 254, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('73', 'Produits nets partiels sur opérations à long terme', '7', 'PAS', 255, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('74', 'Subventions d''exploitation', '7', 'PAS', 256, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('75', 'Autres produits de gestion courante', '7', 'PAS', 257, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('76', 'Produits financiers', '7', 'PAS', 261, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('77', 'Produits exceptionnels', '7', 'PAS', 262, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('79', 'Transferts de charges', '7', 'PAS', 266, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('8', 'Comptes spéciaux', '0', 'CON', 267, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('9', 'Comptes analytiques', '0', 'CON', 268, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('758', 'Ecart de conversion', '75', 'PRO', 315, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('658', 'Ecart de conversion ', '65', 'CHA', 316, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('510001', 'Banque', '51', 'ACT', 317, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('44571', 'TVA  France métropolitaine - Taux normal', '445', 'ACT', 312, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('445661', 'TVA  France métropolitaine - Taux normal', '4456', 'PAS', 309, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456', 'TVA Déductible', '445', 'ACT', 318, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4456601', 'TVA  France métropolitaine - Taux immobilisations Déductible', '4456', 'ACT', 269, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4457', 'TVA à reverser', '445', 'PAS', 319, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4100001', 'Clients divers', '410', 'ACT', 320, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id, pcm_direct_use) VALUES ('4000001', 'Four', '400', 'PAS', 321, 'Y');






INSERT INTO public.currency_history (id, ch_value, ch_from, currency_id) VALUES (1, 1.00000000, '2000-01-01', 0);












INSERT INTO public.document_component (dc_id, dc_code, dc_comment) VALUES (1, 'ACH', 'Journaux achat');
INSERT INTO public.document_component (dc_id, dc_code, dc_comment) VALUES (2, 'VEN', 'Journaux vente');
INSERT INTO public.document_component (dc_id, dc_code, dc_comment) VALUES (3, 'GES', 'Gestion');



INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (1, 'Devis', 2351550, 7, 'devis.odt', 'application/vnd.oasis.opendocument.text', 'GES');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (2, 'Facture', 2351551, 4, 'modele-facture.ods', 'application/vnd.oasis.opendocument.spreadsheet', 'VEN');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (3, 'Facture Gestion', 2351552, 4, 'modele-facture.ods', 'application/vnd.oasis.opendocument.spreadsheet', 'GES');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (4, 'Note de crédit', 2351553, 3, 'note-credit.ods', 'application/vnd.oasis.opendocument.spreadsheet', 'VEN');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (5, 'Note de frais gestion', 2351554, 10, 'note-de-frais.odt', 'application/vnd.oasis.opendocument.text', 'GES');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (6, 'Note de frais', 2351555, 3, 'note-de-frais.odt', 'application/vnd.oasis.opendocument.text', 'ACH');
INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type, md_filename, md_mimetype, md_affect) VALUES (7, 'Rappel', 2351556, 5, 'rappel.odt', 'application/vnd.oasis.opendocument.text', 'ACH');



INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (7, 'detail_operation', 21, 1, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (44, 'contact_multiple', 21, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (45, 'editable_description', 21, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (46, 'make_invoice', 21, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (47, 'make_feenote', 21, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (27, 'followup_comment', 21, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (40, 'videoconf_server', 21, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (6, 'detail_operation', 20, 1, 'ACH');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (13, 'contact_multiple', 20, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (52, 'editable_description', 20, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (53, 'make_invoice', 20, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (54, 'make_feenote', 20, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (26, 'followup_comment', 20, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (39, 'videoconf_server', 20, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (57, 'detail_operation', 22, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (58, 'contact_multiple', 22, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (59, 'editable_description', 22, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (60, 'make_invoice', 22, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (61, 'make_feenote', 22, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (28, 'followup_comment', 22, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (41, 'videoconf_server', 22, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (64, 'detail_operation', 7, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (65, 'contact_multiple', 7, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (66, 'editable_description', 7, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (67, 'make_invoice', 7, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (68, 'make_feenote', 7, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (22, 'followup_comment', 7, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (35, 'videoconf_server', 7, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (5, 'detail_operation', 10, 1, 'ACH');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (12, 'contact_multiple', 10, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (73, 'editable_description', 10, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (74, 'make_invoice', 10, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (42, 'make_feenote', 10, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (25, 'followup_comment', 10, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (38, 'videoconf_server', 10, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (4, 'detail_operation', 5, 1, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (11, 'contact_multiple', 5, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (80, 'editable_description', 5, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (81, 'make_invoice', 5, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (82, 'make_feenote', 5, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (20, 'followup_comment', 5, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (33, 'videoconf_server', 5, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (3, 'detail_operation', 4, 1, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (10, 'contact_multiple', 4, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (87, 'editable_description', 4, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (15, 'make_invoice', 4, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (89, 'make_feenote', 4, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (19, 'followup_comment', 4, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (32, 'videoconf_server', 4, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (92, 'detail_operation', 8, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (93, 'contact_multiple', 8, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (94, 'editable_description', 8, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (95, 'make_invoice', 8, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (96, 'make_feenote', 8, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (23, 'followup_comment', 8, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (36, 'videoconf_server', 8, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (99, 'detail_operation', 1, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (100, 'contact_multiple', 1, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (101, 'editable_description', 1, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (102, 'make_invoice', 1, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (103, 'make_feenote', 1, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (16, 'followup_comment', 1, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (29, 'videoconf_server', 1, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (106, 'detail_operation', 9, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (107, 'contact_multiple', 9, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (108, 'editable_description', 9, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (109, 'make_invoice', 9, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (110, 'make_feenote', 9, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (24, 'followup_comment', 9, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (37, 'videoconf_server', 9, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (113, 'detail_operation', 6, 0, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (114, 'contact_multiple', 6, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (115, 'editable_description', 6, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (116, 'make_invoice', 6, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (117, 'make_feenote', 6, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (21, 'followup_comment', 6, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (34, 'videoconf_server', 6, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (1, 'detail_operation', 2, 1, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (8, 'contact_multiple', 2, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (122, 'editable_description', 2, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (14, 'make_invoice', 2, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (124, 'make_feenote', 2, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (17, 'followup_comment', 2, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (30, 'videoconf_server', 2, 1, 'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (2, 'detail_operation', 3, 1, 'VEN');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (9, 'contact_multiple', 3, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (129, 'editable_description', 3, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (130, 'make_invoice', 3, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (131, 'make_feenote', 3, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (18, 'followup_comment', 3, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id, do_enable, do_option) VALUES (31, 'videoconf_server', 3, 1, 'https://www.free-solutions.org/');



INSERT INTO public.document_state (s_id, s_value, s_status) VALUES (2, 'A suivre', NULL);
INSERT INTO public.document_state (s_id, s_value, s_status) VALUES (3, 'A faire', NULL);
INSERT INTO public.document_state (s_id, s_value, s_status) VALUES (1, 'Clôturé', 'C');
INSERT INTO public.document_state (s_id, s_value, s_status) VALUES (4, 'Abandonné', 'C');






INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (877, 80, 23, 'BANQUE');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (876, 80, 1, 'Banque');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (878, 80, 3, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (879, 80, 4, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (880, 80, 12, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (881, 80, 5, '510001');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (882, 80, 13, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (883, 80, 34, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (884, 80, 14, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (885, 80, 15, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (886, 80, 16, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (887, 80, 17, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (888, 80, 18, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (901, 82, 1, 'Fournisseurs divers');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (903, 82, 12, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (904, 82, 5, '4000001');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (905, 82, 13, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (907, 82, 34, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (906, 82, 14, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (908, 82, 15, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (909, 82, 24, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (910, 82, 16, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (911, 82, 17, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (912, 82, 18, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (902, 82, 23, '40FDIV');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (889, 81, 1, 'Clients divers');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (891, 81, 12, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (892, 81, 5, '4100001');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (893, 81, 13, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (895, 81, 34, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (894, 81, 14, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (896, 81, 15, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (897, 81, 24, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (898, 81, 16, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (899, 81, 17, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (900, 81, 18, '');
INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (890, 81, 23, '41CDIV');



INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (118, '2024-01-01', '2024-01-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (119, '2024-02-01', '2024-02-29', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (120, '2024-03-01', '2024-03-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (121, '2024-04-01', '2024-04-30', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (122, '2024-05-01', '2024-05-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (123, '2024-06-01', '2024-06-30', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (124, '2024-07-01', '2024-07-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (125, '2024-08-01', '2024-08-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (126, '2024-09-01', '2024-09-30', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (127, '2024-10-01', '2024-10-31', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (128, '2024-11-01', '2024-11-30', '2024', false, false, '2024');
INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_central, p_exercice_label) VALUES (129, '2024-12-01', '2024-12-31', '2024', false, false, '2024');












INSERT INTO public.form_definition (fr_id, fr_label) VALUES (3000000, 'TVA déclaration Belge');



INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000398, 3000000, 1, 'Prestation [ case 03 ]', '[700%]-[7000005]');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000399, 3000000, 2, 'Prestation intra [ case 47 ]', '[7000005]');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000400, 3000000, 3, 'Tva due   [case 54]', '[4513]+[4512]+[4511] FROM=01.2005');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000401, 3000000, 4, 'Marchandises, matière première et auxiliaire [case 81 ]', '[60%]');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000402, 3000000, 7, 'Service et bien divers [case 82]', '[61%]');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000403, 3000000, 8, 'bien d''invest [ case 83 ]', '[2400%]');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000404, 3000000, 9, 'TVA déductible [ case 59 ]', 'abs([4117]-[411%])');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000405, 3000000, 8, 'TVA non ded -> voiture', '[610022]*0.21/2');
INSERT INTO public.form_detail (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES (3000406, 3000000, 9, 'Acompte TVA', '[4117]');









INSERT INTO public.info_def (id_type, id_description) VALUES ('BON_COMMANDE', 'Numero de bon de commande');
INSERT INTO public.info_def (id_type, id_description) VALUES ('OTHER', 'Info diverses');






INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 2, 3, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 12, 8, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 3, 17, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 12, 28, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 2, 37, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 2, 41, 1);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 6, 4, 120);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 6, 42, 120);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 7, 5, 130);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 7, 38, 130);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 7, 43, 130);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 14, 10, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 14, 21, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 14, 30, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 16, 12, 70);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 16, 23, 70);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 16, 32, 70);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 17, 13, 80);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 17, 24, 80);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 17, 33, 80);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 18, 14, 90);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 18, 25, 90);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 18, 34, 90);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 23, 45, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 23, 46, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 23, 47, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 23, 48, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 23, 49, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 23, 50, 400);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 24, 51, 60);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 24, 52, 60);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 15, 11, 50);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 15, 22, 50);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 15, 31, 50);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 5, 1, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 5, 6, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 5, 15, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 5, 26, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 5, 35, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 5, 39, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 1, 2, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 1, 7, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 1, 16, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 1, 27, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 1, 36, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 1, 40, 0);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 4, 18, 2);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 12, 19, 3);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 19, 44, 2);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 13, 9, 31);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 13, 20, 31);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 13, 29, 31);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (500000, 1, 54, 10);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (500000, 9, 55, 20);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (500000, 23, 56, 30);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 34, 64, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 34, 65, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 34, 66, 40);


















INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 118, 'OP', 101);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 118, 'OP', 102);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 118, 'OP', 103);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 118, 'OP', 104);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 119, 'OP', 105);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 119, 'OP', 106);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 119, 'OP', 107);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 119, 'OP', 108);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 120, 'OP', 109);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 120, 'OP', 110);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 120, 'OP', 111);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 120, 'OP', 112);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 121, 'OP', 113);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 121, 'OP', 114);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 121, 'OP', 115);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 121, 'OP', 116);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 122, 'OP', 117);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 122, 'OP', 118);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 122, 'OP', 119);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 122, 'OP', 120);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 123, 'OP', 121);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 123, 'OP', 122);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 123, 'OP', 123);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 123, 'OP', 124);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 124, 'OP', 125);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 124, 'OP', 126);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 124, 'OP', 127);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 124, 'OP', 128);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 125, 'OP', 129);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 125, 'OP', 130);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 125, 'OP', 131);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 125, 'OP', 132);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 126, 'OP', 133);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 126, 'OP', 134);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 126, 'OP', 135);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 126, 'OP', 136);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 127, 'OP', 137);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 127, 'OP', 138);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 127, 'OP', 139);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 127, 'OP', 140);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 128, 'OP', 141);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 128, 'OP', 142);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 128, 'OP', 143);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 128, 'OP', 144);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 129, 'OP', 145);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 129, 'OP', 146);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 129, 'OP', 147);
INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 129, 'OP', 148);

































INSERT INTO public.menu_default (md_id, md_code, me_code) VALUES (1, 'code_invoice', 'COMPTA/VENMENU/VEN');
INSERT INTO public.menu_default (md_id, md_code, me_code) VALUES (2, 'code_follow', 'GESTION/FOLLOW');
INSERT INTO public.menu_default (md_id, md_code, me_code) VALUES (3, 'code_feenote', 'COMPTA/MENUACH/ACH');



INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCHOP', 'Historique', 'anc_history.inc.php', NULL, 'Historique des imputations analytiques', NULL, NULL, 'ME', 'Historique des imputations analytiques');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCBS', 'Balance simple', 'anc_balance_simple.inc.php', NULL, 'Balance simple des imputations analytiques', NULL, NULL, 'ME', 'Balance simple des imputations analytiques');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCTAB', 'Tableau', 'anc_acc_table.inc.php', NULL, 'Tableau lié à la comptabilité', NULL, NULL, 'ME', 'Tableau lié à la comptabilité');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCBCC', 'Balance Analytique/comptabilité', 'anc_acc_balance.inc.php', NULL, 'Lien entre comptabilité et Comptabilité analytique', NULL, NULL, 'ME', 'Lien entre comptabilité et Comptabilité analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCGR', 'Groupe', 'anc_group_balance.inc.php', NULL, 'Balance par groupe', NULL, NULL, 'ME', 'Balance par groupe');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('SUPPL', 'Fournisseur', 'supplier.inc.php', NULL, 'Suivi fournisseur', NULL, NULL, 'ME', 'Suivi des fournisseurs : devis, lettres, email....');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCODS', 'Opérations diverses', 'anc_od.inc.php', NULL, 'OD analytique', NULL, NULL, 'ME', 'Opérations diverses en Analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('REPORT', 'Création de rapport', 'report.inc.php', NULL, 'Création de rapport', NULL, NULL, 'ME', 'Création de rapport sur mesure, comme les ratios, vous permet de créer des graphiques de vos données (vente, achat...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('new_line', 'saut de ligne', NULL, NULL, 'Saut de ligne', NULL, NULL, 'SP', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CUST', 'Client', 'customer.inc.php', NULL, 'Suivi client', NULL, NULL, 'ME', 'Suivi client : devis, réunion, courrier, commande...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('STOCK_HISTO', 'Historique stock', 'stock_histo.inc.php', NULL, 'Historique des mouvement de stock', NULL, NULL, 'ME', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:histo', 'Export Historique', 'export_histo_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:ledger', 'Export Journaux', 'export_ledger_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:ledger', 'Export Journaux', 'export_ledger_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:postedetail', 'Export Poste détail', 'export_poste_detail_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:postedetail', 'Export Poste détail', 'export_poste_detail_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:fichedetail', 'Export Fiche détail', 'export_fiche_detail_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:fichedetail', 'Export Fiche détail', 'export_fiche_detail_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:fiche_balance', 'Export Fiche balance', 'export_fiche_balance_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:fiche_balance', 'Export Fiche balance', 'export_fiche_balance_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:report', 'Export report', 'export_form_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:report', 'Export report', 'export_form_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:fiche', 'Export Fiche', 'export_fiche_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:glcompte', 'Export Grand Livre', 'export_gl_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:glcompte', 'Export Grand Livre', 'export_gl_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:sec', 'Export Sécurité', 'export_security_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncList', 'Export Comptabilité analytique', 'export_anc_list_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncBalSimple', 'Export Comptabilité analytique balance simple', 'export_anc_balance_simple_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:AncBalSimple', 'Export Comptabilité analytique', 'export_anc_balance_simple_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncBalDouble', 'Export Comptabilité analytique balance double', 'export_anc_balance_double_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:AncBalDouble', 'Export Comptabilité analytique balance double', 'export_anc_balance_double_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:balance', 'Export Balance comptable', 'export_balance_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:balance', 'Export Balance comptable', 'export_balance_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncTable', 'Export Tableau Analytique', 'export_anc_table_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncAccList', 'Export Historique Compt. Analytique', 'export_anc_acc_list_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncBalGroup', 'Export Balance groupe analytique', 'export_anc_balance_group_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('OTH:Bilan', 'Export Bilan', 'export_bilan_oth.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:AncGrandLivre', 'Impression Grand-Livre', 'export_anc_grandlivre_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:reportinit', 'Export définition d''un raport', 'export_reportinit_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:ActionGestion', 'Export Action Gestion', 'export_follow_up_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:StockHisto', 'Export Historique mouvement stock', 'export_stock_histo_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:StockResmList', 'Export Résumé list stock', 'export_stock_resume_list.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('EXT', 'Extension', NULL, NULL, 'Extensions (plugins)', NULL, NULL, 'ME', 'Menu regroupant les plugins');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PLANANC', 'Plan Compt. analytique', 'anc_pa.inc.php', NULL, 'Plan analytique', NULL, NULL, 'ME', 'Axe analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCGROUP', 'Groupe', 'anc_group.inc.php', NULL, 'Groupe analytique', NULL, NULL, 'ME', 'Regroupement de compte analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CONTACT', 'Contact', 'contact.inc.php', NULL, 'Liste des contacts', NULL, NULL, 'ME', 'Liste de tous vos contacts');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PREDOP', 'Ecriture prédefinie', 'preod.inc.php', NULL, 'Gestion des opérations prédéfinifies', NULL, NULL, 'ME', 'Les opérations prédéfinies sont des opérations que vous faites régulièrement (loyer, abonnement,...) ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FIN', 'Nouvel extrait', 'compta_fin.inc.php', NULL, 'Nouvel extrait bancaire', NULL, NULL, 'ME', 'Encodage d''un extrait bancaire (=relevé bancaire)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('JSSEARCH', 'Recherche', NULL, NULL, 'Recherche', NULL, 'search_reconcile()', 'ME', 'Historique de toutes vos opérations un menu de recherche dans une nouvelle fenêtre, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('LETCARD', 'Lettrage par Fiche', 'lettering.card.inc.php', NULL, 'Lettrage par fiche', NULL, NULL, 'ME', 'Lettrage par fiche');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ACHISTO', 'Historique achat', 'history_operation.inc.php', NULL, 'Historique achat', 'ledger_type=ACH', NULL, 'ME', 'Historique de toutes vos opérations dans les journaux d''achats un menu de recherche, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('VEN', 'Nouvelle vente', 'compta_ven.inc.php', NULL, 'Nouvelle vente ou recette', NULL, NULL, 'ME', 'Encodage de tous vos revenus ou vente');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ODHISTO', 'Historique opérations diverses', 'history_operation.inc.php', NULL, 'Historique opérations diverses', 'ledger_type=ODS', NULL, 'ME', 'Historique de toutes vos opérations dans les journaux d''opérations diverses un menu de recherche, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CMCARD', 'Modèle de fiches', 'fiche_def.inc.php', NULL, 'Gestion de modèle de fiches', NULL, NULL, 'ME', 'Permet de changer le poste comptable de base des modèles de fiches');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0PST', 'Poste', 'impress_poste.inc.php', NULL, 'Impression du détail d''un poste comptable', NULL, NULL, 'ME', 'Impression du détail d''un poste comptable');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C1MENU', 'Config. Menu', 'menu.inc.php', NULL, 'Configuration des menus et plugins', NULL, NULL, 'ME', 'Ajout de menu ou de plugins');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MENUACH', 'Achat', NULL, NULL, 'Menu achat', NULL, NULL, 'ME', 'Regroupement pour les menus d''achats(nouvelle opération, historique...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MOD', 'Menu et profil', NULL, NULL, 'Menu ', NULL, NULL, 'ME', 'Regroupement pour les menus et les profils');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('BK', 'Banque', 'bank.inc.php', NULL, 'Information Banque', NULL, NULL, 'ME', 'Regroupement des menus des journaux de trésorerie');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCGL', 'Grand''Livre', 'anc_great_ledger.inc.php', NULL, 'Grand livre analytique', NULL, NULL, 'ME', 'Grand livre pour la comptabilité analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('GESTION', 'Gestion', NULL, NULL, 'Module gestion', NULL, NULL, 'ME', 'Module gestion');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('LET', 'Lettrage', NULL, NULL, 'Lettrage', NULL, NULL, 'ME', 'Menu Lettrage');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ACCESS', 'Accueil', NULL, 'user_login.php', 'Accueil', NULL, NULL, 'ME', 'Choix de votre dossier');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('COMPTA', 'Comptabilité', NULL, NULL, 'Module comptabilité', NULL, NULL, 'ME', 'Module comptabilité');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('DIVPARM', 'Divers', NULL, NULL, 'Paramètres divers', NULL, NULL, 'ME', 'Menu de différents paramètres');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCBC2', 'Balance croisée double', 'anc_balance_double.inc.php', NULL, 'Balance double croisées des imputations analytiques', NULL, NULL, 'ME', 'Balance double croisées des imputations analytiques');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PERIODE', 'Période', 'periode.inc.php', NULL, 'Gestion des périodes', NULL, NULL, 'ME', 'Gestion des périodes : clôture, ajout de période, afin de créer des périodes vous pouvez aussi utiliser le plugin outil comptable');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('VERIFBIL', 'Vérification ', 'verif_bilan.inc.php', NULL, 'Vérification de la comptabilité', NULL, NULL, 'ME', 'Vérifie que votre comptabilité ne contient pas d''erreur de base, tels que l''équilibre entre le passif et l''actif, l''utilisation des postes comptables...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('STOCK_STATE', 'Etat des stock', 'stock_state.inc.php', NULL, 'Etat des stock', NULL, NULL, 'ME', 'Etat des stock de l''exercice indiqué');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('STOCK_INV', 'Modification Stocks', 'stock_inv.inc.php', NULL, 'Modification des stocks (inventaire)', NULL, NULL, 'ME', 'Modification des stocks, menu utilisé pour l''inventaire');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('STOCK_INVHISTO', 'Histo. Changement', 'stock_inv_histo.inc.php', NULL, 'Liste des changements manuels des stocks', NULL, NULL, 'ME', 'Liste des changements manuels des stocks, inventaire, transfert de marchandises entre dépôts...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('HIST', 'Historique', 'history_operation.inc.php', NULL, 'Historique', 'ledger_type=ALL', NULL, 'ME', 'Historique de toutes vos opérations un menu de recherche, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FREC', 'Rapprochement', 'compta_fin_rec.inc.php', NULL, 'Rapprochement bancaire', NULL, NULL, 'ME', 'Permet de faire correspondre vos extraits bancaires avec les opérations de vente ou d''achat, le lettrage se fait automatiquement');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FSALDO', 'Soldes', 'compta_fin_saldo.inc.php', NULL, 'Solde des comptes en banques, caisse...', NULL, NULL, 'ME', 'Solde des journaux de trésorerie cela concerne les comptes en banques, caisse , les chèques... ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('LOGOUT', 'Sortie &#9094', NULL, 'logout.php', 'Sortie', NULL, NULL, 'ME', 'Déconnexion ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('LETACC', 'Lettrage par Poste', 'lettering.account.inc.php', NULL, 'lettrage par poste comptable', NULL, NULL, 'ME', 'lettrage par poste comptable');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CARDBAL', 'Balance', 'balance_card.inc.php', NULL, 'Balance par catégorie de fiche', NULL, NULL, 'ME', 'Balance par catégorie de fiche ou pour toutes les fiches ayant un poste comptable');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('VEHISTO', 'Historique vente', 'history_operation.inc.php', NULL, 'Historique des ventes', 'ledger_type=VEN', NULL, 'ME', 'Historique de toutes vos opérations dans les journaux de vente un menu de recherche, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FIHISTO', 'Historique financier', 'history_operation.inc.php', NULL, 'Historique financier', 'ledger_type=FIN', NULL, 'ME', 'Historique de toutes vos opérations dans les journaux de trésorerie un menu de recherche, vous permettra de retrouver rapidement l''opération qui vous intéresse');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('OTAX', 'Autre Taxe', 'acc_other_tax.inc.php', NULL, 'Autre Taxe pour les ventes et achats', NULL, NULL, 'ME', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('COMPANY', 'Principal', 'company.inc.php', NULL, 'Parametre societe', NULL, NULL, 'ME', 'Information sur votre société : nom, adresse... utilisé lors de la génération de documents');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('NAVI', 'Navigateur &#x1F9ED', NULL, NULL, 'Menu simplifié pour retrouver rapidement un menu', NULL, 'ask_navigator(<DOSSIER>)', 'ME', 'Le navigateur vous présente une liste de menu auquel vous avez accès et vous permet d''accèder plus rapidement au menu que vous souhaitez');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0GRL', 'Grand Livre', 'impress_gl_comptes.inc.php', NULL, 'Impression du grand livre', NULL, NULL, 'ME', 'Impression du grand livre');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0BAL', 'Balance', 'balance.inc.php', NULL, 'Impression des balances comptables', NULL, NULL, 'ME', 'Impression des balances comptables');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0RAP', 'Rapprochement', 'impress_rec.inc.php', NULL, 'Impression des rapprochements', NULL, NULL, 'ME', 'Impression des rapprochements : opérations non rapprochées ou avec des montants différents');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0RPO', 'Rapport', 'impress_rapport.inc.php', NULL, 'Impression de rapport', NULL, NULL, 'ME', 'Impression de rapport personnalisé, il est aussi possible d''exporter en CSV afin de faire des graphiques');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0PST', 'Poste', 'poste.inc.php', NULL, 'Config. poste comptable de base', NULL, NULL, 'ME', 'Config. poste comptable de base');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0DOC', 'Document', 'document_modele.inc.php', NULL, 'Config. modèle de document', NULL, NULL, 'ME', 'Chargement de modèles de documents qui seront générés par NOALYSS, les formats utilisables sont libreoffice, html, text et rtf');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0SEC', 'Sécurité', 'param_sec.inc.php', NULL, 'configuration de la sécurité', NULL, NULL, 'ME', 'Configuration de la sécurité, vous permet de donner un profil à vos utilisateurs, cela leur permettra d''utiliser ce que vous souhaitez qu''ils puissent utiliser');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0PCMN', 'Plan Comptable', 'param_pcmn.inc.php', NULL, 'Config. du plan comptable', NULL, NULL, 'ME', 'Modification de votre plan comptable, parfois il est plus rapide d''utiliser le plugin "Poste Comptable"');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('STOCK', 'Stock', NULL, NULL, 'Stock', NULL, NULL, 'ME', 'Permet d''ajouter de nouvelles catégorie de fiche, d''ajouter des attributs à ces catégories (numéro de téléphone, gsm, email...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MENUODS', 'Opérations diverses', NULL, NULL, 'Menu opérations diverses', NULL, NULL, 'ME', 'Regroupement pour les menus d''opérations diverses (nouvelle opération, historique...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('VENMENU', 'Vente / Recette', NULL, NULL, 'Menu ventes et recettes', NULL, NULL, 'ME', 'Regroupement des menus ventes et recettes');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCIMP', 'Impression', NULL, NULL, 'Impression compta. analytique', NULL, NULL, 'ME', 'Impression compta. analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANC', 'Compta Analytique', NULL, NULL, 'Module comptabilité analytique', NULL, NULL, 'ME', 'Module comptabilité analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('DASHBOARD', 'Tableau de bord', 'dashboard.inc.php', NULL, 'Tableau de bord', NULL, NULL, 'ME', 'Tableau de suivi, vous permet de voir en un coup d''oeil vos dernières opérations, un petit calendrier, une liste de chose à faire...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ADV', 'Avancé', NULL, NULL, 'Menu avancé', NULL, NULL, 'ME', 'Menu regroupant la création de rapport, la vérification de la comptabilité...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FOLLOW', 'Liste Suivi', 'action.inc.php', NULL, 'Document de suivi sous forme de liste', NULL, NULL, 'ME', 'Liste de vos suivis, en fait de tous les documents, réunions ... dont vous avez besoin afin de suivre vos clients, fournisseurs ou administrations. Il permet la génération de documents comme les devis, les bordereau de livraison...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ADM', 'Administration', 'adm.inc.php', NULL, 'Suivi administration, banque', NULL, NULL, 'ME', 'Suivi des administrations : courrrier, déclarations.');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('FORECAST', 'Prévision', 'forecast.inc.php', NULL, 'Prévision', NULL, NULL, 'ME', 'Prévision de vos achats, revenus, permet de suivre l''évolution de votre société. Vos prévisions sont des formules sur les postes comptables et vous permettent aussi vos marges brutes.');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:Reconciliation', 'Export opérations rapprochées', 'export_rec_csv.php', NULL, 'Export opérations rapprochées en CSV', NULL, NULL, 'PR', '');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MANAGER', 'Administrateur', 'manager.inc.php', NULL, 'Suivi des gérants, administrateurs et salariés', NULL, NULL, 'ME', 'Suivi de vos salariés, managers ainsi que des administrateurs, pour les documents et les opérations comptables');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:AncReceipt', 'Export pièce PDF', 'export_anc_receipt_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:balance_age', 'Export Balance agée', 'export_balance_age_csv.php', NULL, 'Balance agée', NULL, NULL, 'PR', 'Balance agée pour les clients et fournisseurs');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('RAW:receipt', 'Exporte la pièce', 'export_receipt.php', NULL, 'export la pièce justificative d''une opération', NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('RAW:document', 'Export le document', 'export_document.php', NULL, 'exporte le document d''un événement', NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('RAW:document_template', 'Exporte le modèle de document', 'export_document_template.php', NULL, 'export le modèle de document utilisé dans le suivi', NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:Analytic_Axis', 'Export ANC', 'export_anc_axis_csv.php', NULL, 'Export ANC Liste comptes', NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:printtva', 'Export Résumé TVA', 'export_printtva_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:printtva', 'Export Résumé TVA', 'export_printtva_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:operation_detail', NULL, 'export_operation_pdf.php', NULL, 'Export Operation', NULL, NULL, NULL, NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:FollowUpContactOption', 'Export action suivi', 'export_follow_up_contact_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ACH', 'Nouvel achat', 'compta_ach.inc.php', NULL, 'Nouvel achat ou dépense', NULL, NULL, 'ME', 'Vous permet d''encoder des achats, dépenses, des notes de frais ou des notes de crédits, vous pouvez spécifier un bénéficiaire ou un autre moyen de paiement');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ODS', 'Nouvelle opération', 'compta_ods.inc.php', NULL, 'Nouvelle opérations diverses', NULL, NULL, 'ME', 'Opération diverses tels que les amortissements, les augmentations de capital, les salaires, ...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PCUR01', 'Devise', 'print_currency01.inc.php', NULL, 'Résumé par devise', NULL, NULL, 'ME', 'Résumé par devise afin de 
faire de calculer les écarts de conversion (différence de change) pour les actifs et passifs');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:pcur01', 'Export Devise CSV', 'export_pcur01_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:pcur01', 'Export Devise PDF', 'export_pcur01_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MCARD', 'Fiche', NULL, NULL, 'Paramètrage des fiches', NULL, NULL, 'E', 'Menu regroupant ce qui concerne les fiches');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MDOC', 'Document', NULL, NULL, 'Paramètrage des documents', NULL, NULL, 'E', 'Meu regroupant ce qui concene les documents ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MACC', 'Comptabilité', NULL, NULL, 'Paramètrage comptabilité', NULL, NULL, 'E', 'Menu regroupant ce qui concerne la comptabilité');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:AncAccList', 'Export Historique Compt. Analytique', 'export_anc_acc_list_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('AGENDA', 'Agenda  &#x1f4c5', 'calendar.inc.php', NULL, 'Agenda', NULL, NULL, 'ME', 'Agenda, présentation du suivi sous forme d''agenda ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0BIL', 'Bilan', 'impress_bilan.inc.php', NULL, 'Impression de bilan', NULL, NULL, 'ME', 'Impression de bilan, ce module est basique, il est plus intéressant d''utiliser le plugin "rapport avancés"');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0JRN', 'Impression Journaux', 'impress_jrn.inc.php', NULL, 'Impression des journaux', NULL, NULL, 'ME', 'Impression des journaux avec les détails pour les parties privés, la TVA et ce qui est non déductibles en ce qui concerne les journaux de vente et d''achat');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0ETS', 'Etat des actions', 'doc_state.inc.php', NULL, 'Etat des actions dans le suivi', NULL, NULL, 'ME', 'Permet d''ajouter des état pour les documents utilisés dans le suivi (à faire, à suivre...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0MENU', 'Menu par défaut', 'default_menu.inc.php', NULL, 'Configuration des menus par défaut', NULL, NULL, 'ME', 'Configuration des menus par défaut, ces menus sont appelés par des actions dans d''autres menus');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0DEV', 'Devises', 'acc_currency_cfg.inc.php', NULL, 'Configuration des devises', NULL, NULL, 'ME', 'Permet de configurer les devises');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('NCOL', 'Apparence', 'noalyss-color.inc.php', NULL, 'Couleur de NOALYSS', NULL, NULL, 'ME', 'Personnalisation des couleurs de NOYALYSS');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CCARD', 'Catégorie fiche', 'cfgfiche.inc.php', NULL, 'Configuration de catégorie de fiches', NULL, NULL, 'ME', 'Permet d''ajouter de nouvelles catégorie de fiche, d''ajouter des attributs à ces catégories (numéro de téléphone, gsm, email...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('MENUFIN', 'Financier', NULL, NULL, 'Menu Financier', NULL, NULL, 'ME', 'Regroupement pour les menus de trésorerie (nouvelle opération, historique...)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('OPCL', 'Ouvert./Fermeture', 'operation_exercice.inc.php', NULL, 'Opération de cloture ou d''ouverture d''exercice', NULL, NULL, 'ME', 'Ecriture d''ouverture ou de fermeture , , reporte les soldes des comptes de l''année passé du poste comptable 0xxx à 5xxxx sur l''année courante ou ferme les comptes de 6 à 7 de l''année ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PDF:card', 'export Fiche détail PDF', 'export_card_pdf.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CFG', 'Configuration &#x1F527', NULL, NULL, 'Configuration de votre dossier', NULL, NULL, 'ME', 'Module paramètres');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('SEARCH', 'Recherche  &#x1F50E', NULL, NULL, 'Recherche', NULL, 'popup_recherche(<DOSSIER>)', 'ME', 'Historique de toutes vos opérations dans tous  les journaux auquels vous avez accès, vous permettra de retrouver rapidement l''opération qui vous intéresse sur base de la date, du poste comptable, des montants...');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0TVA', 'Résumé TVA', 'tax_summary.inc.php', NULL, 'totaux  par TVA et par journal', NULL, NULL, 'ME', 'Calcul des totaux  par TVA et par journal');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P0BLG', 'Balance agée', 'balance_age.inc.php', NULL, 'Balance agée', NULL, NULL, 'ME', 'Balance agée pour les clients et fournisseurs');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('P1TVA', 'Détail TVA', 'tax_detail.inc.php', NULL, 'Détail TVA  par journal', NULL, NULL, 'ME', 'Détail des TVA ');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CSV:p1tva', 'Export Détail TVA', 'export_p1tva_csv.php', NULL, NULL, NULL, NULL, 'PR', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0PROFL', 'Profil', 'profile.inc.php', NULL, 'Configuration profil', NULL, NULL, 'ME', 'Configuration des profils des utilisateurs, permet de fixer les journaux, profils dans les documents et stock que  ce profil peut utiliser. Cela limite les utilisateurs puisque ceux-ci ont un profil');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0JRN', 'Journal', 'cfgledger.inc.php', NULL, 'Configuration des journaux', NULL, NULL, 'ME', 'Création et modification des journaux, préfixe des pièces justificatives, numérotation, catégories de fiches accessibles à ce journal');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0PAY', 'Moyen de paiement', 'payment_method.inc.php', NULL, 'Config. des méthodes de paiement', NULL, NULL, 'ME', 'Configuration des moyens de paiements que vous voulez utiliser dans les journaux de type VEN ou ACH, les moyens de paiement permettent de générer l''opération de trésorerie en même temps que l''achat, la note de frais ou la vente');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0ACT', 'Document Suivi', 'cfg_action.inc.php', NULL, 'Configuration des documents dans le suivi', NULL, NULL, 'ME', 'Vous permet d''ajouter de nouveaux type de documents pour le suivi (bordereau de livraison, devis..)');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0OPT1', 'Option Fiches', 'contact_option_ref.inc.php', NULL, 'configure les options pour les fiches dans le suivi', NULL, NULL, 'ME', NULL);
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0STOCK', 'Dépôt', 'stock_cfg.inc.php', NULL, 'Configuration dépôts', NULL, NULL, 'ME', 'Configuration des entrepots de dépôts');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0TVA', 'TVA', 'tva.inc.php', NULL, 'Config. de la tva', NULL, NULL, 'ME', 'Permet d''ajouter des taux de TVA ou de les modifier ainsi que les postes comptables de ces TVA, ces TVA sont utilisables dans les menus de vente et d''achat');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0CARD', 'Attribut de fiche', 'card_attr.inc.php', NULL, 'Gestion des attributs de fiches ', NULL, NULL, 'ME', 'Permet d''ajouter de nouveaux attributs que vous pourrez par la suite ajouter à des catégories de fiches');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0PLG', 'Extension', 'cfgplugin.inc.php', NULL, 'Configuration des extensions', NULL, NULL, 'ME', 'Permet d''installer et d''activer facilement des extensions');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('ANCKEY', 'Clef de répartition', 'anc_key.inc.php', NULL, 'Clef de répartition pour la comptabilité analytique', NULL, NULL, 'ME', 'Permet de gèrer les clefs de répartition en comptabilité analytique');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('C0TAG', 'Etiquette', 'cfgtags.inc.php', NULL, 'Configuration des étiquettes', NULL, NULL, 'ME', 'Configuration des étiquettes(tags) ou dossiers, on l''appele tag ou dossier suivant la façon dont vous utilisez
cette fonctionnalité. Vous pouvez en ajouter, en supprimer ou les modifier');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PREFERENCE', 'Preference &#128100', NULL, NULL, 'Préférence', NULL, 'set_preference(<DOSSIER>)', 'ME', 'Préférence de l''utilisateur, apparence de l''application pour l''utilisateur, période par défaut et mot de passe');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('PRINT', 'Impression &#x1F4CA', NULL, NULL, 'Menu impression', NULL, NULL, 'ME', 'Menu impression');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('CARD', 'Fiche &#x1F4C7', 'fiche.inc.php', NULL, 'Liste,Balance,Historique par fiche', NULL, NULL, 'ME', 'Permet d''avoir la balance de toutes vos fiches, les résumés exportables en CSV, les historiques avec ou sans lettrages');
INSERT INTO public.menu_ref (me_code, me_menu, me_file, me_url, me_description, me_parameter, me_javascript, me_type, me_description_etendue) VALUES ('BOOKMARK', 'Favori &#x2728', NULL, NULL, 'Raccourci vers vos menus préférés', NULL, 'show_bookmark(<DOSSIER>)', 'ME', 'Ce menu vous présente  un menu rapide de vos menus préférés');
























INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_COUNTRY', 'FR');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_NAME', 'LaMule');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TVA', 'FR33 123 456 789');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_STREET', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_NUMBER', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_CP', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TEL', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_PAYS', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_COMMUNE', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_FAX', '');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_ANALYTIC', 'nu');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_STRICT', 'Y');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TVA_USE', 'Y');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_PJ_SUGGEST', 'N');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_CHECK_PERIODE', 'N');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_DATE_SUGGEST', 'Y');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_ALPHANUM', 'N');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_UPDLAB', 'N');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_STOCK', 'N');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_DEFAULT_ROUND_ERROR_DEB', '658');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_DEFAULT_ROUND_ERROR_CRED', '758');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_ANC_FILTER', '6,7');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_REPORT', 'N');



INSERT INTO public.parameter_extra (id, pe_code, pe_label, pe_value) VALUES (1, 'SIRET', 'SIRET', NULL);
INSERT INTO public.parameter_extra (id, pe_code, pe_label, pe_value) VALUES (2, 'SIREN', 'SIREN', NULL);
INSERT INTO public.parameter_extra (id, pe_code, pe_label, pe_value) VALUES (3, 'EMAIL_COMPANY', 'Email Société', NULL);
INSERT INTO public.parameter_extra (id, pe_code, pe_label, pe_value) VALUES (4, 'WEB_COMPANY', 'Site Web', NULL);



INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('H2', '#9fbcd6');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('MENU1', '#000074');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('BODY', '#ffffff');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('MENU2', '#3d3d87');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('MENU1-SELECTED', '#506cb8');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-MENU1', '#ffffff');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-MENU2', '#ffffff');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-TABLE', '#222bd0');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-DEFAULT', '#000074');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-TABLE-HEADER', '#0C106D');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FOLDER', '#ffffff');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('FONT-FOLDER', '#000074');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('TR-ODD', '#DCE7F5');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('TR-EVEN', '#ffffff');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('INNER-BOX', '#DCE1EF');
INSERT INTO public.parm_appearance (a_code, a_value) VALUES ('INNER-BOX-TITLE', '#023575');



INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('BANQUE', '51', 'Poste comptable par défaut pour les banques');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('CAISSE', '53', 'Poste comptable par défaut pour les caisses');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('CUSTOMER', '410', 'Poste comptable par défaut pour les clients');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('VENTE', '707', 'Poste comptable par défaut pour les ventes');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('VIREMENT_INTERNE', '58', 'Poste comptable par défaut pour les virements internes');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('DEP_PRIV', '4890', 'Depense a charge du gerant');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('SUPPLIER', '400', 'Poste par défaut pour les fournisseurs');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('DNA', '67', 'Dépense non déductible');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('TVA_DNA', '', 'TVA non déductible');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('TVA_DED_IMPOT', '', 'TVA déductible à l''impôt');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('COMPTE_TVA', '', 'TVA à payer ou à recevoir');
INSERT INTO public.parm_code (p_code, p_value, p_comment) VALUES ('COMPTE_COURANT', '455', 'Poste comptable pour le compte courant');



INSERT INTO public.parm_money (pm_id, pm_code, pm_rate) VALUES (1, 'EUR', 1.0000);



INSERT INTO public.parm_poste (p_value, p_type) VALUES ('1', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('12', 'CON');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('2', 'ACT');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('3', 'ACT');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('41', 'ACT');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('42', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('43', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('44', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('45', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('46', 'CON');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('47', 'CON');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('481', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('482', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('483', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('484', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('485', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('486', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('487', 'ACT');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('49', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('5', 'ACT');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('6', 'CHA');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('7', 'PAS');
INSERT INTO public.parm_poste (p_value, p_type) VALUES ('40', 'PAS');



INSERT INTO public.payment_method (mp_id, mp_lib, mp_jrn_def_id, mp_fd_id, mp_qcode, jrn_def_id) VALUES (2, 'Caisse', 1, NULL, NULL, 2);
INSERT INTO public.payment_method (mp_id, mp_lib, mp_jrn_def_id, mp_fd_id, mp_qcode, jrn_def_id) VALUES (1, 'Paiement électronique', 1, NULL, NULL, 2);
INSERT INTO public.payment_method (mp_id, mp_lib, mp_jrn_def_id, mp_fd_id, mp_qcode, jrn_def_id) VALUES (4, 'Caisse', 1, NULL, NULL, 3);
INSERT INTO public.payment_method (mp_id, mp_lib, mp_jrn_def_id, mp_fd_id, mp_qcode, jrn_def_id) VALUES (3, 'Par gérant ou administrateur', 2, NULL, NULL, 3);



INSERT INTO public.profile_menu_type (pm_type, pm_desc) VALUES ('P', 'Impression');
INSERT INTO public.profile_menu_type (pm_type, pm_desc) VALUES ('S', 'Extension');
INSERT INTO public.profile_menu_type (pm_type, pm_desc) VALUES ('E', 'Menu');
INSERT INTO public.profile_menu_type (pm_type, pm_desc) VALUES ('M', 'Module');



INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (2, 'ANC', NULL, 1, 500, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (651, 'ANCHOP', 'ANCIMP', 1, 100, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (173, 'COMPTA', NULL, 1, 400, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (652, 'ANCGL', 'ANCIMP', 1, 200, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (653, 'ANCBS', 'ANCIMP', 1, 300, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (654, 'ANCBC2', 'ANCIMP', 1, 400, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (655, 'ANCTAB', 'ANCIMP', 1, 500, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (656, 'ANCBCC', 'ANCIMP', 1, 600, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (657, 'ANCGR', 'ANCIMP', 1, 700, 'E', 0, 78);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (658, 'CSV:AncGrandLivre', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (662, 'new_line', NULL, 1, 350, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (23, 'LET', 'COMPTA', 1, 80, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (75, 'PLANANC', 'ANC', 1, 10, 'E', 0, 2);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (76, 'ANCODS', 'ANC', 1, 20, 'E', 0, 2);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (77, 'ANCGROUP', 'ANC', 1, 30, 'E', 0, 2);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (78, 'ANCIMP', 'ANC', 1, 40, 'E', 0, 2);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (79, 'PREFERENCE', NULL, 1, 150, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (37, 'CUST', 'GESTION', 1, 10, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (38, 'SUPPL', 'GESTION', 1, 20, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (39, 'ADM', 'GESTION', 1, 30, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (40, 'STOCK', 'GESTION', 1, 50, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (41, 'FORECAST', 'GESTION', 1, 70, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (42, 'FOLLOW', 'GESTION', 1, 80, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (29, 'VERIFBIL', 'ADV', 1, 210, 'E', 0, 28);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (31, 'PREDOP', 'ADV', 1, 230, 'E', 0, 28);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (33, 'REPORT', 'ADV', 1, 250, 'E', 0, 28);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (43, 'HIST', 'COMPTA', 1, 10, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (28, 'ADV', 'COMPTA', 1, 200, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (688, 'PLANANC', 'ANC', 2, 10, 'E', 0, 727);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (690, 'ANCODS', 'ANC', 2, 20, 'E', 0, 727);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (53, 'ACCESS', NULL, 1, 250, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (785, 'STOCK_HISTO', 'STOCK', 1, 10, 'E', NULL, 30);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (820, 'STOCK_HISTO', 'STOCK', 1, 10, 'E', NULL, 40);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (786, 'STOCK_STATE', 'STOCK', 1, 20, 'E', NULL, 30);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (821, 'STOCK_STATE', 'STOCK', 1, 20, 'E', NULL, 40);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (789, 'STOCK_INVHISTO', 'STOCK', 1, 30, 'E', NULL, 30);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (822, 'STOCK_INVHISTO', 'STOCK', 1, 30, 'E', NULL, 40);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (795, 'STOCK_INV', 'STOCK', 1, 30, 'E', NULL, 30);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (823, 'STOCK_INV', 'STOCK', 1, 30, 'E', NULL, 40);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (787, 'STOCK_HISTO', 'STOCK', 2, 10, 'E', NULL, 702);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (832, 'STOCK_HISTO', 'STOCK', 2, 10, 'E', NULL, 706);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (788, 'STOCK_STATE', 'STOCK', 2, 20, 'E', NULL, 702);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (833, 'STOCK_STATE', 'STOCK', 2, 20, 'E', NULL, 706);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (790, 'STOCK_INVHISTO', 'STOCK', 2, 30, 'E', NULL, 702);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (834, 'STOCK_INVHISTO', 'STOCK', 2, 30, 'E', NULL, 706);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (796, 'STOCK_INV', 'STOCK', 2, 30, 'E', NULL, 702);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (835, 'STOCK_INV', 'STOCK', 2, 30, 'E', NULL, 706);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (123, 'CSV:histo', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (20, 'LOGOUT', NULL, 1, 300, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (35, 'PRINT', 'GESTION', 1, 40, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (124, 'CSV:ledger', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (125, 'PDF:ledger', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (6, 'PRINT', 'COMPTA', 1, 60, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (126, 'CSV:postedetail', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (3, 'MENUACH', 'COMPTA', 1, 30, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (34, 'GESTION', NULL, 1, 450, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (18, 'MENUODS', 'COMPTA', 1, 50, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (88, 'ODS', 'MENUODS', 1, 10, 'E', 0, 18);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (4, 'VENMENU', 'COMPTA', 1, 20, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (90, 'VEN', 'VENMENU', 1, 10, 'E', 0, 4);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (19, 'FIN', 'MENUFIN', 1, 10, 'E', 0, 92);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (82, 'EXT', NULL, 1, 550, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (95, 'FREC', 'MENUFIN', 1, 40, 'E', 0, 92);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (94, 'FSALDO', 'MENUFIN', 1, 30, 'E', 0, 92);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (45, 'CFG', NULL, 1, 200, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (54, 'COMPANY', 'CFG', 1, 1, 'E', 1, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (27, 'LETACC', 'LET', 1, 20, 'E', 0, 23);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (24, 'LETCARD', 'LET', 1, 10, 'E', 0, 23);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (92, 'MENUFIN', 'COMPTA', 1, 40, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (151, 'SEARCH', NULL, 1, 600, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (85, 'ACH', 'MENUACH', 1, 10, 'E', 0, 3);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (127, 'PDF:postedetail', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (128, 'CSV:fichedetail', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (129, 'PDF:fichedetail', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (130, 'CSV:fiche_balance', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (131, 'PDF:fiche_balance', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (132, 'CSV:report', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (133, 'PDF:report', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (134, 'CSV:fiche', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (526, 'P0GRL', 'PRINT', 1, 200, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (71, 'C0SEC', 'CFG', 1, 60, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (68, 'C0CARD', 'MCARD', 1, 90, 'E', 0, 874);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (136, 'CSV:glcompte', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (137, 'PDF:glcompte', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (138, 'PDF:sec', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (139, 'CSV:AncList', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (140, 'CSV:AncBalSimple', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (141, 'PDF:AncBalSimple', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (142, 'CSV:AncBalDouble', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (143, 'PDF:AncBalDouble', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (144, 'CSV:balance', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (145, 'PDF:balance', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (146, 'CSV:AncTable', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (147, 'CSV:AncAccList', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (148, 'CSV:AncBalGroup', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (149, 'OTH:Bilan', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (1, 'DASHBOARD', NULL, 1, 100, 'M', 1, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (86, 'ACHISTO', 'MENUACH', 1, 20, 'E', 0, 3);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (91, 'VEHISTO', 'VENMENU', 1, 20, 'E', 0, 4);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (781, 'BK', 'GESTION', 1, 35, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (783, 'CSV:ActionGestion', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (30, 'STOCK', 'COMPTA', 1, 90, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (791, 'CSV:StockHisto', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (792, 'CSV:StockResmList', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (779, 'CSV:reportinit', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (36, 'CARD', 'GESTION', 1, 60, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (5, 'CARD', 'COMPTA', 1, 70, 'E', 0, 173);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (93, 'FIHISTO', 'MENUFIN', 1, 20, 'E', 0, 92);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (89, 'ODHISTO', 'MENUODS', 1, 20, 'E', 0, 18);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (799, 'NAVI', NULL, 1, 90, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (801, 'BOOKMARK', NULL, 1, 85, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (804, 'CSV:Reconciliation', NULL, 1, 0, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (806, 'MANAGER', 'GESTION', 1, 25, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (809, 'AGENDA', 'NULL', 1, 410, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (811, 'PDF:AncReceipt', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (812, 'ANCKEY', 'ANC', 1, 15, 'E', 0, 2);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (818, 'CSV:balance_age', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (668, 'ANCHOP', 'ANCIMP', 2, 100, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (669, 'COMPTA', NULL, 2, 400, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (672, 'ANCGL', 'ANCIMP', 2, 200, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (674, 'ANCBS', 'ANCIMP', 2, 300, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (675, 'ANCBC2', 'ANCIMP', 2, 400, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (676, 'ANCTAB', 'ANCIMP', 2, 500, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (677, 'ANCBCC', 'ANCIMP', 2, 600, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (678, 'ANCGR', 'ANCIMP', 2, 700, 'E', 0, 692);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (679, 'CSV:AncGrandLivre', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (680, 'new_line', NULL, 2, 350, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (684, 'LET', 'COMPTA', 2, 80, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (717, 'CSV:ledger', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (718, 'PDF:ledger', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (719, 'PRINT', 'COMPTA', 2, 60, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (720, 'CSV:postedetail', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (721, 'MENUACH', 'COMPTA', 2, 30, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (723, 'GESTION', NULL, 2, 450, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (724, 'MENUODS', 'COMPTA', 2, 50, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (725, 'ODS', 'MENUODS', 2, 10, 'E', 0, 724);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (727, 'ANC', NULL, 2, 500, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (728, 'VENMENU', 'COMPTA', 2, 20, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (729, 'VEN', 'VENMENU', 2, 10, 'E', 0, 728);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (731, 'FIN', 'MENUFIN', 2, 10, 'E', 0, 742);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (735, 'EXT', NULL, 2, 550, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (736, 'FREC', 'MENUFIN', 2, 40, 'E', 0, 742);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (737, 'FSALDO', 'MENUFIN', 2, 30, 'E', 0, 742);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (738, 'LETACC', 'LET', 2, 20, 'E', 0, 684);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (691, 'ANCGROUP', 'ANC', 2, 30, 'E', 0, 727);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (692, 'ANCIMP', 'ANC', 2, 40, 'E', 0, 727);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (697, 'PREFERENCE', NULL, 2, 150, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (698, 'CUST', 'GESTION', 2, 10, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (699, 'SUPPL', 'GESTION', 2, 20, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (700, 'ADM', 'GESTION', 2, 30, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (702, 'STOCK', 'GESTION', 2, 50, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (703, 'FORECAST', 'GESTION', 2, 70, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (704, 'FOLLOW', 'GESTION', 2, 80, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (705, 'VERIFBIL', 'ADV', 2, 210, 'E', 0, 712);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (707, 'PREDOP', 'ADV', 2, 230, 'E', 0, 712);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (709, 'REPORT', 'ADV', 2, 250, 'E', 0, 712);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (711, 'HIST', 'COMPTA', 2, 10, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (712, 'ADV', 'COMPTA', 2, 200, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (713, 'ACCESS', NULL, 2, 250, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (714, 'CSV:histo', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (715, 'LOGOUT', NULL, 2, 300, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (716, 'PRINT', 'GESTION', 2, 40, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (739, 'LETCARD', 'LET', 2, 10, 'E', 0, 684);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (742, 'MENUFIN', 'COMPTA', 2, 40, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (744, 'SEARCH', NULL, 2, 600, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (745, 'ACH', 'MENUACH', 2, 10, 'E', 0, 721);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (746, 'PDF:postedetail', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (747, 'CSV:fichedetail', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (748, 'PDF:fichedetail', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (749, 'CSV:fiche_balance', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (750, 'PDF:fiche_balance', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (751, 'CSV:report', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (752, 'PDF:report', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (722, 'ACHISTO', 'MENUACH', 2, 20, 'E', 0, 721);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (730, 'VEHISTO', 'VENMENU', 2, 20, 'E', 0, 728);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (753, 'CSV:fiche', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (755, 'CSV:glcompte', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (756, 'PDF:glcompte', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (757, 'PDF:sec', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (167, 'MOD', 'CFG', 1, 10, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (758, 'CSV:AncList', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (759, 'CSV:AncBalSimple', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (760, 'PDF:AncBalSimple', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (761, 'CSV:AncBalDouble', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (762, 'PDF:AncBalDouble', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (763, 'CSV:balance', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (764, 'PDF:balance', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (765, 'CSV:AncTable', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (766, 'CSV:AncAccList', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (767, 'CSV:AncBalGroup', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (768, 'OTH:Bilan', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (772, 'DASHBOARD', NULL, 2, 100, 'M', 1, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (782, 'BK', 'GESTION', 2, 35, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (706, 'STOCK', 'COMPTA', 2, 90, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (793, 'CSV:StockHisto', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (794, 'CSV:StockResmList', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (780, 'CSV:reportinit', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (708, 'OPCL', 'ADV', 2, 240, 'E', 0, 712);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (172, 'C0PROFL', 'MOD', 1, NULL, 'E', 0, 167);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (701, 'CARD', 'GESTION', 2, 60, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (710, 'CARD', 'COMPTA', 2, 70, 'E', 0, 669);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (743, 'FIHISTO', 'MENUFIN', 2, 20, 'E', 0, 742);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (726, 'ODHISTO', 'MENUODS', 2, 20, 'E', 0, 724);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (800, 'NAVI', NULL, 2, 90, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (802, 'BOOKMARK', NULL, 2, 85, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (805, 'CSV:Reconciliation', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (807, 'MANAGER', 'GESTION', 2, 25, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (810, 'AGENDA', 'NULL', 2, 410, 'M', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (813, 'ANCKEY', 'ANC', 2, 15, 'E', 0, 727);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (819, 'CSV:balance_age', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (844, 'CONTACT', 'GESTION', 1, 22, 'E', 0, 34);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (845, 'CONTACT', 'GESTION', 2, 22, 'E', 0, 723);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (846, 'RAW:receipt', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (847, 'RAW:receipt', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (848, 'RAW:document', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (849, 'RAW:document', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (850, 'RAW:document_template', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (851, 'RAW:document_template', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (853, 'CSV:Analytic_Axis', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (854, 'CSV:Analytic_Axis', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (859, 'CSV:printtva', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (860, 'CSV:printtva', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (861, 'PDF:printtva', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (862, 'PDF:printtva', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (863, 'PDF:operation_detail', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (864, 'PDF:operation_detail', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (865, 'PDF:operation_detail', NULL, -1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (867, 'CSV:FollowUpContactOption', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (868, 'CSV:FollowUpContactOption', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (869, 'CSV:FollowUpContactOption', NULL, -1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (870, 'PCUR01', 'PRINT', 2, 260, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (871, 'PCUR01', 'PRINT', 1, 260, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (872, 'PCUR01', 'PRINT', 1, 260, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (873, 'PCUR01', 'PRINT', 2, 260, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (55, 'PERIODE', 'MACC', 1, 20, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (72, 'PREDOP', 'MACC', 1, 70, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (877, 'PDF:AncAccList', NULL, 1, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (878, 'PDF:AncAccList', NULL, 2, NULL, 'P', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (65, 'CMCARD', 'MCARD', 1, 70, 'E', 0, 874);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (525, 'CCARD', 'MCARD', 1, 400, 'E', 0, 874);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (879, 'OTAX', 'MACC', 1, 55, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (874, 'MCARD', 'CFG', 1, 20, 'E', NULL, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (875, 'MDOC', 'CFG', 1, 30, 'E', NULL, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (876, 'MACC', 'CFG', 1, 50, 'E', NULL, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (770, 'CCARD', 'CFG', 2, 400, 'E', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (880, 'NCOL', 'CFG', 1, 5, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (32, 'OPCL', 'ADV', 1, 240, 'E', 0, 28);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (881, 'PDF:card', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (882, 'PDF:card', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (883, 'PDF:card', NULL, -1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (683, 'P0GRL', 'PRINT', 2, 200, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (824, 'P0GRL', 'PRINT', 1, 200, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (837, 'P0GRL', 'PRINT', 2, 200, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (523, 'P0BAL', 'PRINT', 1, 500, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (685, 'P0BAL', 'PRINT', 2, 500, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (825, 'P0BAL', 'PRINT', 1, 500, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (838, 'P0BAL', 'PRINT', 2, 500, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (530, 'P0RAP', 'PRINT', 1, 1000, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (695, 'P0RAP', 'PRINT', 2, 1000, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (828, 'P0RAP', 'PRINT', 1, 1000, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (840, 'P0RAP', 'PRINT', 2, 1000, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (524, 'P0BIL', 'PRINT', 1, 900, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (696, 'P0BIL', 'PRINT', 2, 900, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (829, 'P0BIL', 'PRINT', 1, 900, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (841, 'P0BIL', 'PRINT', 2, 900, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (527, 'P0JRN', 'PRINT', 1, 100, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (694, 'P0JRN', 'PRINT', 2, 100, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (827, 'P0JRN', 'PRINT', 1, 100, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (839, 'P0JRN', 'PRINT', 2, 100, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (855, 'P0TVA', 'PRINT', 1, 250, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (856, 'P0TVA', 'PRINT', 2, 250, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (857, 'P0TVA', 'PRINT', 1, 250, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (858, 'P0TVA', 'PRINT', 2, 250, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (528, 'P0PST', 'PRINT', 1, 300, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (830, 'P0PST', 'PRINT', 1, 300, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (769, 'P0PST', 'PRINT', 2, 300, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (842, 'P0PST', 'PRINT', 2, 300, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (529, 'P0RPO', 'PRINT', 1, 850, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (686, 'P0RPO', 'PRINT', 2, 850, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (826, 'P0RPO', 'PRINT', 1, 850, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (836, 'P0RPO', 'PRINT', 2, 850, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (816, 'P0BLG', 'PRINT', 1, 550, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (831, 'P0BLG', 'PRINT', 1, 550, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (817, 'P0BLG', 'PRINT', 2, 550, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (843, 'P0BLG', 'PRINT', 2, 550, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (884, 'P1TVA', 'PRINT', 2, 250, 'E', 0, 719);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (885, 'P1TVA', 'PRINT', 1, 250, 'E', 0, 35);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (886, 'P1TVA', 'PRINT', 1, 250, 'E', 0, 6);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (887, 'P1TVA', 'PRINT', 2, 250, 'E', 0, 716);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (888, 'CSV:p1tva', NULL, 1, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (889, 'CSV:p1tva', NULL, 2, NULL, 'P', NULL, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (61, 'C0PST', 'MACC', 1, 60, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (73, 'C0DOC', 'MDOC', 1, 80, 'E', 0, 875);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (69, 'C0PCMN', 'MACC', 1, 40, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (74, 'C0JRN', 'MACC', 1, 90, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (798, 'C0ETS', 'DIVPARM', 2, 9, 'E', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (797, 'C0ETS', 'MDOC', 1, 9, 'E', 0, 875);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (808, 'C0MENU', 'MOD', 1, 30, 'E', 0, 167);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (171, 'C1MENU', 'MOD', 1, NULL, 'E', 0, 167);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (59, 'C0PAY', 'MACC', 1, 40, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (852, 'C0DEV', 'MACC', 1, 50, 'E', 0, 876);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (67, 'C0ACT', 'MDOC', 1, 80, 'E', 0, 875);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (866, 'C0OPT1', 'MCARD', 1, 85, 'E', 0, 874);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (784, 'C0STOCK', 'CFG', 1, 40, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (814, 'C0PLG', 'CFG', 1, 15, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (815, 'C0PLG', 'CFG', 2, 15, 'E', 0, NULL);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (803, 'C0TAG', 'CFG', 1, 390, 'E', 0, 45);
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order, p_type_display, pm_default, pm_id_dep) VALUES (60, 'C0TVA', 'MACC', 1, 50, 'E', 0, 876);



INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (1, 'AGENDA', 10, 1, '1');
INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (2, 'AGENDA', 10, 2, '1');
INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (3, 'AGENDA', 10, -1, '1');
INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (4, 'LOGOUT', 20, 1, '1');
INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (5, 'LOGOUT', 20, 2, '1');
INSERT INTO public.profile_mobile (pmo_id, me_code, pmo_order, p_id, pmo_default) VALUES (6, 'LOGOUT', 20, -1, '1');



INSERT INTO public.stock_repository (r_id, r_name, r_adress, r_country, r_city, r_phone) VALUES (1, 'Dépôt par défaut', NULL, NULL, NULL, NULL);



INSERT INTO public.profile_sec_repository (ur_id, p_id, r_id, ur_right) VALUES (1, 1, 1, 'W');
INSERT INTO public.profile_sec_repository (ur_id, p_id, r_id, ur_right) VALUES (2, 2, 1, 'W');









INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (105, 'FR_ANC', 0.0000, 'TVA x% - France métropolitaine - Taux anciens', '4456602,445702', 0, 'O', 'O', '0A');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (501, 'FRANCH', 0.0000, 'TVA x% - Non imposable : Achats en franchise', '44566017,4457017', 0, 'O', 'O', '0G');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (101, 'FR_NOR', 0.2000, 'TVA 20% - France métropolitaine - Taux normal', '445661,44571', 0, 'O', 'O', 'NOR');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (102, 'FR_RED', 0.0550, 'TVA 5,5% - France métropolitaine - Taux réduit', '445662,44572', 0, 'O', 'O', 'TR55');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (103, 'FR_SRED', 0.0210, 'TVA 2,1% - France métropolitaine - Taux super réduit', '445663,44573', 0, 'O', 'O', 'TP021');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (104, 'IM20', 0.2000, 'TVA 20% - France métropolitaine - Taux immobilisations', '4456601,445701', 0, 'O', 'O', '196B');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (201, 'DOM', 0.0850, 'TVA 8,5%  - DOM - Taux normal', '4456603,445703', 0, 'O', 'O', 'DNOR');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (202, 'DOM Réduit', 0.0850, 'TVA 8,5% - DOM - Taux normal NPR', '4456604,445704', 0, 'O', 'O', 'DNPR');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (203, 'DOM_REDUIT', 0.0210, 'TVA 2,1% - DOM - Taux réduit', '4456605,445705', 0, 'O', 'O', 'DR');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (204, 'DOM_I', 0.0175, 'TVA 1,75% - DOM - Taux I', '4456606,445706', 0, 'O', 'O', 'DOM1');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (205, 'DOM_PRESSE', 0.0105, 'TVA 1,05% - DOM - Taux publications de presse', '4456607,445707', 0, 'O', 'O', 'DPRS');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (301, 'COR_I', 0.1300, 'TVA 13% - Corse - Taux I', '44566010,4457010', 0, 'O', 'O', 'COR1');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (302, 'COR_II', 0.0800, 'TVA 8% - Corse - Taux II', '44566011,4457011', 0, 'O', 'O', 'COR2');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (303, 'Corse TAUX III', 0.0210, 'TVA 2,1% - Corse - Taux III', '44566012,4457012', 0, 'O', 'O', 'COR3');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (304, 'Corse Taux IV', 0.0090, 'TVA 0,9% - Corse - Taux IV', '44566013,4457013', 0, 'O', 'O', 'COR4');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (305, 'COR_IMMO', 0.0000, 'TVA x% - Corse - Taux immobilisations', '44566014,4457014', 0, 'O', 'O', 'CIM');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (402, 'INTRA_IMMMO', 0.0000, 'TVA x% - Acquisitions intracommunautaires immobilisations/Pays', '44566016,4457016', 0, 'O', 'O', 'INTM');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (206, 'DOM_OCTROI', 0.0000, 'TVA x% - DOM - Taux octroi de mer', '4456608,445708', 0, 'O', 'O', 'DMER');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (207, 'DOM_IMMO', 0.0000, 'TVA x% - DOM - Taux immobilisations', '4456609,445709', 0, 'O', 'O', 'DIM');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (502, 'EXPORT', 0.0000, 'TVA x% - Non imposable : Exports hors CE/Pays', '44566018,4457018', 0, 'O', 'O', 'EXP');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (401, 'INTRA Service', 0.2000, 'TVA x% - Acquisitions intracommunautaires/Pays', '44566015,4457015', 1, 'O', 'O', 'INTS');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (503, 'AUTRE', 0.0000, 'TVA x% - Non imposable : Autres opérations', '44566019,4457019', 0, 'O', 'O', 'AUT');
INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_poste, tva_both_side, tva_payment_sale, tva_payment_purchase, tva_code) VALUES (403, 'INTRA_LIV', 0.2000, 'TVA x% - Non imposable : Livraisons intracommunautaires/Pays', '44566020,4457020', 1, 'O', 'O', 'INTL');






















































INSERT INTO public.version (val, v_description, v_date) VALUES (126, NULL, NULL);
INSERT INTO public.version (val, v_description, v_date) VALUES (127, 'Add filter for search, inactive tag or ledger, type of operation, security', '2018-02-10 22:46:49.270348');
INSERT INTO public.version (val, v_description, v_date) VALUES (128, 'Add a view to manage VAT', '2018-02-10 22:46:49.93138');
INSERT INTO public.version (val, v_description, v_date) VALUES (129, 'Currency : create view , create tables ', '2018-05-16 11:33:21.469167');
INSERT INTO public.version (val, v_description, v_date) VALUES (130, 'fix bug : private fee not saved into quant_purchase', '2018-05-16 11:33:25.259722');
INSERT INTO public.version (val, v_description, v_date) VALUES (131, 'Currency : adapt quant_fin', '2018-12-17 23:52:00.460162');
INSERT INTO public.version (val, v_description, v_date) VALUES (132, 'Currency : Create view for managing currency ', '2018-12-17 23:52:00.483668');
INSERT INTO public.version (val, v_description, v_date) VALUES (133, 'Currency : default accounting for currency difference  ', '2019-01-12 15:09:02.479424');
INSERT INTO public.version (val, v_description, v_date) VALUES (134, 'Export CSV:Analytic_Axis', '2019-02-04 22:14:04.406727');
INSERT INTO public.version (val, v_description, v_date) VALUES (135, 'rename table mod_payment', '2019-08-25 19:45:54.376173');
INSERT INTO public.version (val, v_description, v_date) VALUES (136, 'new feature PRINTTVA', '2019-08-25 19:45:54.418129');
INSERT INTO public.version (val, v_description, v_date) VALUES (137, 'Ledger warning', '2019-08-26 15:09:22.88749');
INSERT INTO public.version (val, v_description, v_date) VALUES (138, 'Analytic improve', '2019-08-29 09:52:54.278989');
INSERT INTO public.version (val, v_description, v_date) VALUES (139, 'Add VAT exigibility', '2019-11-12 21:22:33.533302');
INSERT INTO public.version (val, v_description, v_date) VALUES (140, 'Filter operation PRINTJRN', '2019-11-12 21:22:33.804236');
INSERT INTO public.version (val, v_description, v_date) VALUES (141, 'Search filter with operation status', '2019-11-24 21:58:09.971317');
INSERT INTO public.version (val, v_description, v_date) VALUES (142, 'Bug dans PARM_POSTE', '2020-04-04 13:21:42.426386');
INSERT INTO public.version (val, v_description, v_date) VALUES (143, 'Corrige function find_pcm_type', '2020-04-04 14:27:50.026138');
INSERT INTO public.version (val, v_description, v_date) VALUES (144, 'Export Operation PDF', '2020-06-07 19:21:25.812273');
INSERT INTO public.version (val, v_description, v_date) VALUES (145, 'Improve tags , add multiple contacts with options', '2020-11-02 23:54:58.108636');
INSERT INTO public.version (val, v_description, v_date) VALUES (146, 'Export CSV for Multiple card, contact option by document type', '2020-11-02 23:54:58.234365');
INSERT INTO public.version (val, v_description, v_date) VALUES (147, 'Cascade delete on action_gestion', '2020-11-02 23:54:58.269295');
INSERT INTO public.version (val, v_description, v_date) VALUES (148, 'Default values for document_option', '2020-11-02 23:54:58.275375');
INSERT INTO public.version (val, v_description, v_date) VALUES (149, 'Default values for document_option,comment on followup', '2020-11-02 23:54:58.281166');
INSERT INTO public.version (val, v_description, v_date) VALUES (150, 'Change name default action', '2020-11-06 17:22:45.299311');
INSERT INTO public.version (val, v_description, v_date) VALUES (151, 'Tag with color and operation', '2020-11-11 00:00:14.757231');
INSERT INTO public.version (val, v_description, v_date) VALUES (152, 'Comment on tables,card structure change', '2021-01-26 10:58:32.211348');
INSERT INTO public.version (val, v_description, v_date) VALUES (153, 'Add videoconf server', '2021-02-03 14:33:20.743998');
INSERT INTO public.version (val, v_description, v_date) VALUES (154, 'Rewriting of FORECAST', '2021-04-11 11:48:44.642374');
INSERT INTO public.version (val, v_description, v_date) VALUES (155, 'Rewriting of COMPANY add extra parameter', '2021-04-11 11:48:44.663678');
INSERT INTO public.version (val, v_description, v_date) VALUES (156, 'insert default accounting', '2021-04-11 11:48:44.727275');
INSERT INTO public.version (val, v_description, v_date) VALUES (157, 'new feature Currency search', '2021-05-01 13:27:51.136573');
INSERT INTO public.version (val, v_description, v_date) VALUES (158, 'Filter Currency search', '2021-05-01 13:27:51.156843');
INSERT INTO public.version (val, v_description, v_date) VALUES (159, 'correct bug when inserting accounting', '2021-05-01 13:44:53.554244');
INSERT INTO public.version (val, v_description, v_date) VALUES (160, 'correct menu item', '2021-05-09 10:00:00.788636');
INSERT INTO public.version (val, v_description, v_date) VALUES (161, 'rewriting of Impress (Formula), reorganize menu', '2021-05-29 19:01:15.438711');
INSERT INTO public.version (val, v_description, v_date) VALUES (162, 'Analytic accountancy : enable or disable #1983', '2021-06-15 11:01:34.282597');
INSERT INTO public.version (val, v_description, v_date) VALUES (163, 'typo in menu', '2021-06-21 13:40:56.239516');
INSERT INTO public.version (val, v_description, v_date) VALUES (164, 'Menu for small device : mobile', '2021-07-31 11:23:59.971562');
INSERT INTO public.version (val, v_description, v_date) VALUES (165, 'Fix bug for company without VAT', '2021-07-31 11:24:00.031051');
INSERT INTO public.version (val, v_description, v_date) VALUES (166, 'Fix bug for card with empty name or quickcode', '2021-08-18 17:09:54.784927');
INSERT INTO public.version (val, v_description, v_date) VALUES (167, 'Card accounting created automatically', '2021-08-22 18:01:19.814911');
INSERT INTO public.version (val, v_description, v_date) VALUES (168, 'Button search card', '2021-08-24 18:08:17.536177');
INSERT INTO public.version (val, v_description, v_date) VALUES (169, 'Fix bug currency_id is null, from IMPORTBANK', '2021-10-14 11:27:17.299425');
INSERT INTO public.version (val, v_description, v_date) VALUES (170, 'new : export in PDF balance Analytic / Accountancy', '2021-11-10 00:16:08.081458');
INSERT INTO public.version (val, v_description, v_date) VALUES (171, 'change name for menu ', '2021-12-02 17:46:48.401259');
INSERT INTO public.version (val, v_description, v_date) VALUES (172, 'Add free label for exercice', '2021-12-02 17:56:37.103811');
INSERT INTO public.version (val, v_description, v_date) VALUES (173, 'Supplemental tax', '2022-11-27 21:52:49.318844');
INSERT INTO public.version (val, v_description, v_date) VALUES (174, 'Supplemental tax : delete', '2022-11-27 21:52:49.442589');
INSERT INTO public.version (val, v_description, v_date) VALUES (175, 'Folder Appearance', '2022-11-27 21:52:49.4476');
INSERT INTO public.version (val, v_description, v_date) VALUES (176, 'Folder Appearance : dialog box', '2022-11-27 21:52:49.460678');
INSERT INTO public.version (val, v_description, v_date) VALUES (177, 'Use of quantity column optional and rename PARAM', '2022-11-27 21:52:49.465687');
INSERT INTO public.version (val, v_description, v_date) VALUES (178, 'Correct contact', '2022-11-27 21:52:49.493577');
INSERT INTO public.version (val, v_description, v_date) VALUES (179, 'Improve Card Attribut - default order', '2022-11-27 21:52:49.509361');
INSERT INTO public.version (val, v_description, v_date) VALUES (180, 'Shorten Aphanumeric account', '2022-11-27 21:52:49.542062');
INSERT INTO public.version (val, v_description, v_date) VALUES (181, 'Make feenote from Management', '2022-11-27 21:52:49.560624');
INSERT INTO public.version (val, v_description, v_date) VALUES (182, 'Prevent to add several time same tag on an operation, action_comment formatting', '2022-11-27 21:52:49.570293');
INSERT INTO public.version (val, v_description, v_date) VALUES (183, 'Mantis #1327 code for vat', '2023-01-05 11:07:42.43799');
INSERT INTO public.version (val, v_description, v_date) VALUES (184, 'document table action_gestion', '2023-01-25 15:51:18.044871');
INSERT INTO public.version (val, v_description, v_date) VALUES (185, 'Document Component : Type of Document Model in a table', '2023-05-01 08:50:08.159973');
INSERT INTO public.version (val, v_description, v_date) VALUES (186, 'Correct contact and web site', '2023-06-03 13:26:26.065241');
INSERT INTO public.version (val, v_description, v_date) VALUES (187, 'Currency : more decimals', '2023-07-05 17:46:27.665395');
INSERT INTO public.version (val, v_description, v_date) VALUES (188, 'Filter for VAT id', '2023-08-30 09:39:51.064903');
INSERT INTO public.version (val, v_description, v_date) VALUES (189, 'Compute properly accounting', '2023-08-30 09:39:51.128306');
INSERT INTO public.version (val, v_description, v_date) VALUES (190, 'remove dead code', '2023-09-17 10:33:59.157707');
INSERT INTO public.version (val, v_description, v_date) VALUES (191, 'cloture-ouverture exercice-version 9112', '2024-01-13 13:02:09.525307');
INSERT INTO public.version (val, v_description, v_date) VALUES (192, '2323 : tree for depending event', '2024-01-17 19:05:06.843139');
INSERT INTO public.version (val, v_description, v_date) VALUES (193, ' 2332: Suivi : ajout fichier lié aux commentaires', '2024-01-28 14:37:01.464433');
INSERT INTO public.version (val, v_description, v_date) VALUES (194, 'Renforcement sécurité', '2024-02-03 16:08:05.876849');
INSERT INTO public.version (val, v_description, v_date) VALUES (195, 'Protect injection JS , sauve recherche suivi', '2024-02-18 13:20:33.071394');
INSERT INTO public.version (val, v_description, v_date) VALUES (196, 'remove trigger update on JRNX ', '2024-02-27 17:58:20.604052');
INSERT INTO public.version (val, v_description, v_date) VALUES (197, 'Adapt for VAT CODE', '2024-07-27 22:11:14.978379');
INSERT INTO public.version (val, v_description, v_date) VALUES (198, 'Cosmetic and VAT', '2024-07-27 22:11:15.067253');
INSERT INTO public.version (val, v_description, v_date) VALUES (199, 'Detail VAT', '2024-07-29 16:02:22.743803');
INSERT INTO public.version (val, v_description, v_date) VALUES (200, 'Widget and improve menu', '2024-09-08 18:35:41.095728');
INSERT INTO public.version (val, v_description, v_date) VALUES (201, 'receipt with padding ', '2024-09-08 18:35:41.235892');
INSERT INTO public.version (val, v_description, v_date) VALUES (202, 'Bug with reconcile, improve view', '2024-09-08 18:35:41.247962');



SELECT pg_catalog.setval('public.acc_other_tax_ac_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_comment_document_acd_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_detail_ad_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_gestion_ag_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_gestion_comment_agc_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_gestion_filter_af_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_gestion_operation_ago_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_gestion_related_aga_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_person_ap_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_person_option_ap_id_seq', 1, false);



SELECT pg_catalog.setval('public.action_tags_at_id_seq', 1, false);



SELECT pg_catalog.setval('public.bilan_b_id_seq', 9, true);



SELECT pg_catalog.setval('public.bookmark_b_id_seq', 1, false);



SELECT pg_catalog.setval('public.bud_card_bc_id_seq', 1, false);



SELECT pg_catalog.setval('public.bud_detail_bd_id_seq', 1, false);



SELECT pg_catalog.setval('public.bud_detail_periode_bdp_id_seq', 1, false);



SELECT pg_catalog.setval('public.contact_option_ref_cor_id_seq', 1, false);



SELECT pg_catalog.setval('public.currency_history_id_seq', 1, true);



SELECT pg_catalog.setval('public.currency_id_seq', 1, false);



SELECT pg_catalog.setval('public.del_action_del_id_seq', 1, true);



SELECT pg_catalog.setval('public.del_jrn_dj_id_seq', 1, false);



SELECT pg_catalog.setval('public.del_jrnx_djx_id_seq', 1, false);



SELECT pg_catalog.setval('public.document_component_dc_id_seq', 3, true);



SELECT pg_catalog.setval('public.document_d_id_seq', 1, false);



SELECT pg_catalog.setval('public.document_modele_md_id_seq', 7, true);



SELECT pg_catalog.setval('public.document_option_do_id_seq', 133, true);



SELECT pg_catalog.setval('public.document_seq', 7, true);



SELECT pg_catalog.setval('public.document_state_s_id_seq', 100, false);



SELECT pg_catalog.setval('public.document_type_dt_id_seq', 25, false);



SELECT pg_catalog.setval('public.extension_ex_id_seq', 1, false);



SELECT pg_catalog.setval('public.forecast_cat_fc_id_seq', 1, false);



SELECT pg_catalog.setval('public.forecast_f_id_seq', 1, false);



SELECT pg_catalog.setval('public.forecast_item_fi_id_seq', 1, false);



SELECT pg_catalog.setval('public.historique_analytique_ha_id_seq', 1, false);



SELECT pg_catalog.setval('public.jnt_document_option_contact_jdoc_id_seq', 1, false);



SELECT pg_catalog.setval('public.jnt_letter_jl_id_seq', 1, false);



SELECT pg_catalog.setval('public.jnt_tag_group_tag_jt_id_seq', 1, false);



SELECT pg_catalog.setval('public.jrn_info_ji_id_seq', 1, false);



SELECT pg_catalog.setval('public.jrn_note_n_id_seq', 1, false);



SELECT pg_catalog.setval('public.jrn_periode_id_seq', 148, true);



SELECT pg_catalog.setval('public.jrn_tax_jt_id_seq', 1, false);



SELECT pg_catalog.setval('public.key_distribution_activity_ka_id_seq', 1, false);



SELECT pg_catalog.setval('public.key_distribution_detail_ke_id_seq', 1, false);



SELECT pg_catalog.setval('public.key_distribution_kd_id_seq', 1, false);



SELECT pg_catalog.setval('public.key_distribution_ledger_kl_id_seq', 1, false);



SELECT pg_catalog.setval('public.letter_cred_lc_id_seq', 1, false);



SELECT pg_catalog.setval('public.letter_deb_ld_id_seq', 1, false);



SELECT pg_catalog.setval('public.link_action_type_l_id_seq', 1, false);



SELECT pg_catalog.setval('public.menu_default_md_id_seq', 3, true);



SELECT pg_catalog.setval('public.mod_payment_mp_id_seq', 10, true);



SELECT pg_catalog.setval('public.op_def_op_seq', 1, false);



SELECT pg_catalog.setval('public.op_predef_detail_opd_id_seq', 1, false);



SELECT pg_catalog.setval('public.operation_currency_id_seq', 1, false);



SELECT pg_catalog.setval('public.operation_exercice_detail_oed_id_seq', 1, false);



SELECT pg_catalog.setval('public.operation_exercice_oe_id_seq', 1, false);



SELECT pg_catalog.setval('public.operation_tag_opt_id_seq', 1, false);



SELECT pg_catalog.setval('public.parameter_extra_id_seq', 4, true);



SELECT pg_catalog.setval('public.plan_analytique_pa_id_seq', 1, false);



SELECT pg_catalog.setval('public.poste_analytique_po_id_seq', 1, false);



SELECT pg_catalog.setval('public.profile_menu_pm_id_seq', 889, true);



SELECT pg_catalog.setval('public.profile_mobile_pmo_id_seq', 6, true);



SELECT pg_catalog.setval('public.profile_p_id_seq', 11, true);



SELECT pg_catalog.setval('public.profile_sec_repository_ur_id_seq', 2, true);



SELECT pg_catalog.setval('public.profile_user_pu_id_seq', 7, true);



SELECT pg_catalog.setval('public.quant_fin_qf_id_seq', 1, false);



SELECT pg_catalog.setval('public.s_attr_def', 9001, false);



SELECT pg_catalog.setval('public.s_cbc', 1, false);



SELECT pg_catalog.setval('public.s_central', 1, false);



SELECT pg_catalog.setval('public.s_central_order', 1, false);



SELECT pg_catalog.setval('public.s_centralized', 1, false);



SELECT pg_catalog.setval('public.s_currency', 1, true);



SELECT pg_catalog.setval('public.s_fdef', 6, true);



SELECT pg_catalog.setval('public.s_fiche', 82, true);



SELECT pg_catalog.setval('public.s_fiche_def_ref', 18, true);



SELECT pg_catalog.setval('public.s_form', 1, false);



SELECT pg_catalog.setval('public.s_formdef', 1, false);



SELECT pg_catalog.setval('public.s_grpt', 102, true);



SELECT pg_catalog.setval('public.s_idef', 1, false);



SELECT pg_catalog.setval('public.s_internal', 1, false);



SELECT pg_catalog.setval('public.s_invoice', 1, false);



SELECT pg_catalog.setval('public.s_isup', 1, false);



SELECT pg_catalog.setval('public.s_jnt_fic_att_value', 912, true);



SELECT pg_catalog.setval('public.s_jnt_id', 66, true);



SELECT pg_catalog.setval('public.s_jrn', 1, false);



SELECT pg_catalog.setval('public.s_jrn_1', 1, false);



SELECT pg_catalog.setval('public.s_jrn_2', 1, false);



SELECT pg_catalog.setval('public.s_jrn_3', 1, false);



SELECT pg_catalog.setval('public.s_jrn_4', 1, false);



SELECT pg_catalog.setval('public.s_jrn_5', 1, false);



SELECT pg_catalog.setval('public.s_jrn_def', 5, false);



SELECT pg_catalog.setval('public.s_jrn_op', 1, false);



SELECT pg_catalog.setval('public.s_jrn_pj1', 1, false);



SELECT pg_catalog.setval('public.s_jrn_pj2', 1, false);



SELECT pg_catalog.setval('public.s_jrn_pj3', 1, false);



SELECT pg_catalog.setval('public.s_jrn_pj4', 1, false);



SELECT pg_catalog.setval('public.s_jrn_pj5', 1, false);



SELECT pg_catalog.setval('public.s_jrn_rapt', 20, true);



SELECT pg_catalog.setval('public.s_jrnaction', 5, true);



SELECT pg_catalog.setval('public.s_jrnx', 1, false);



SELECT pg_catalog.setval('public.s_oa_group', 7, true);



SELECT pg_catalog.setval('public.s_periode', 129, true);



SELECT pg_catalog.setval('public.s_quantity', 13, true);



SELECT pg_catalog.setval('public.s_stock_goods', 1, false);



SELECT pg_catalog.setval('public.s_tva', 1000, false);



SELECT pg_catalog.setval('public.s_user_act', 14, true);



SELECT pg_catalog.setval('public.s_user_jrn', 12, true);



SELECT pg_catalog.setval('public.seq_bud_hypothese_bh_id', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_1', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_10', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_2', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_20', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_21', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_22', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_3', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_4', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_5', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_6', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_7', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_8', 1, false);



SELECT pg_catalog.setval('public.seq_doc_type_9', 1, false);



SELECT pg_catalog.setval('public.stock_change_c_id_seq', 1, false);



SELECT pg_catalog.setval('public.stock_repository_r_id_seq', 1, true);



SELECT pg_catalog.setval('public.tag_group_tg_id_seq', 1, false);



SELECT pg_catalog.setval('public.tags_t_id_seq', 1, false);



SELECT pg_catalog.setval('public.tmp_pcmn_id_seq', 321, true);



SELECT pg_catalog.setval('public.tmp_stockgood_detail_d_id_seq', 1, false);



SELECT pg_catalog.setval('public.tmp_stockgood_s_id_seq', 1, false);



SELECT pg_catalog.setval('public.todo_list_shared_id_seq', 1, false);



SELECT pg_catalog.setval('public.todo_list_tl_id_seq', 1, false);



SELECT pg_catalog.setval('public.uos_pk_seq', 1, false);



SELECT pg_catalog.setval('public.user_active_security_id_seq', 1, true);



SELECT pg_catalog.setval('public.user_filter_id_seq', 1, false);



SELECT pg_catalog.setval('public.user_sec_action_profile_ua_id_seq', 6, true);



SELECT pg_catalog.setval('public.user_widget_uw_id_seq', 1, false);



SELECT pg_catalog.setval('public.widget_dashboard_wd_id_seq', 1, false);



BEGIN;

SELECT pg_catalog.lo_open('2351550', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\x00140000080000533c35590000000000000000000000001c00000000000000000000000000dc000000436f6e66696775726174696f6e73322f70726f67726573736261722f504b01021400140000080000533c3559000000000000000000000000180000000000000000000000000016010000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000533c35590000000000000000000000001a000000000000000000000000004c010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b01021400140000080000533c3559000000000000000000000000180000000000000000000000000084010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000533c35590000000000000000000000001a00000000000000000000000000ba010000436f6e66696775726174696f6e73322f746f6f6c70616e656c2f504b01021400140000080000533c35590000000000000000000000001f00000000000000000000000000f2010000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b01021400140000080000533c355900000000000000000000000018000000000000000000000000002f020000436f6e66696775726174696f6e73322f746f6f6c6261722f504b01021400140008080800533c3559b4f768d205010000830300000c00000000000000000000000000650200006d616e69666573742e726466504b01021400140008080800533c3559ddf144e9f90100008a0400000800000000000000000000000000a40300006d6574612e786d6c504b01021400140008080800533c355996f41f425d0700009c3300000c00000000000000000000000000d305000073657474696e67732e786d6c504b01021400140000080000533c3559b4d06e46f45a0000f45a000018000000000000000000000000006a0d00005468756d626e61696c732f7468756d626e61696c2e706e67504b01021400140008080800533c355978456fe8d1090000393400000a00000000000000000000000000946800007374796c65732e786d6c504b01021400140008080800533c3559b6e5e2383e0b0000424e00000b000000000000000000000000009d720000636f6e74656e742e786d6c504b01021400140000080000533c355924bf925f17bf000017bf00003500000000000000000000000000147e000050696374757265732f313030303030303130303030303133443030303030314231423030344642433235363646364530412e706e67504b01021400140008080800533c3559d45857ed670100001405000015000000000000000000000000007e3d01004d4554412d494e462f6d616e69666573742e786d6c504b05060000000012001200d3040000283f01000000');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351551', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\x0000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000019010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000051010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000087010000436f6e66696775726174696f6e73322f746f6f6c70616e656c2f504b01021400140000080000194835590000000000000000000000001c00000000000000000000000000bf010000436f6e66696775726174696f6e73322f70726f67726573736261722f504b01021400140000080000194835590000000000000000000000001f00000000000000000000000000f9010000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000036020000436f6e66696775726174696f6e73322f746f6f6c6261722f504b0102140014000808080019483559b4f768d205010000830300000c000000000000000000000000006c0200006d616e69666573742e726466504b0102140014000808080019483559363dfc6842020000100500000800000000000000000000000000ab0300006d6574612e786d6c504b010214001400080808001948355954700542a50a0000d05b00000a00000000000000000000000000230600007374796c65732e786d6c504b010214001400080808001948355924344c6a4812000010c900000b0000000000000000000000000000110000636f6e74656e742e786d6c504b0102140014000008000019483559c508ea8adfb30000dfb3000035000000000000000000000000008123000050696374757265732f313030303030303130303030303133443030303030314231423030344642433235363646364530412e706e67504b010214001400080808001948355989bc0fcb2c060000d62500000c00000000000000000000000000b3d7000073657474696e67732e786d6c504b0102140014000008000019483559d08a05f2065f0000065f0000180000000000000000000000000019de00005468756d626e61696c732f7468756d626e61696c2e706e67504b01021400140008080800194835591c43e951690100001b0500001500000000000000000000000000553d01004d4554412d494e462f6d616e69666573742e786d6c504b05060000000012001200d3040000013f01000000');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351552', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\x0000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000019010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000051010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000087010000436f6e66696775726174696f6e73322f746f6f6c70616e656c2f504b01021400140000080000194835590000000000000000000000001c00000000000000000000000000bf010000436f6e66696775726174696f6e73322f70726f67726573736261722f504b01021400140000080000194835590000000000000000000000001f00000000000000000000000000f9010000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000036020000436f6e66696775726174696f6e73322f746f6f6c6261722f504b0102140014000808080019483559b4f768d205010000830300000c000000000000000000000000006c0200006d616e69666573742e726466504b0102140014000808080019483559363dfc6842020000100500000800000000000000000000000000ab0300006d6574612e786d6c504b010214001400080808001948355954700542a50a0000d05b00000a00000000000000000000000000230600007374796c65732e786d6c504b010214001400080808001948355924344c6a4812000010c900000b0000000000000000000000000000110000636f6e74656e742e786d6c504b0102140014000008000019483559c508ea8adfb30000dfb3000035000000000000000000000000008123000050696374757265732f313030303030303130303030303133443030303030314231423030344642433235363646364530412e706e67504b010214001400080808001948355989bc0fcb2c060000d62500000c00000000000000000000000000b3d7000073657474696e67732e786d6c504b0102140014000008000019483559d08a05f2065f0000065f0000180000000000000000000000000019de00005468756d626e61696c732f7468756d626e61696c2e706e67504b01021400140008080800194835591c43e951690100001b0500001500000000000000000000000000553d01004d4554412d494e462f6d616e69666573742e786d6c504b05060000000012001200d3040000013f01000000');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351553', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\x000000e7db00005468756d626e61696c732f7468756d626e61696c2e706e67504b010214001400080808004f3b35591c43e951690100001b0500001500000000000000000000000000e33901004d4554412d494e462f6d616e69666573742e786d6c504b05060000000012001200d30400008f3b01000000');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351554', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 17955 characters]');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351555', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 17955 characters]');
SELECT pg_catalog.lo_close(0);

SELECT pg_catalog.lo_open('2351556', 131072);
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 32769 characters]');
SELECT pg_catalog.lowrite(0, '\[encoded data, 7187 characters]');
SELECT pg_catalog.lo_close(0);

COMMIT;


