[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 06/19: Update MOD1, Belgian template add VAT,
|
From: |
dwm |
|
Subject: |
[Noalyss-commit] [noalyss] 06/19: Update MOD1, Belgian template add VAT, document, ... |
|
Date: |
Wed, 25 Sep 2024 06:45:03 -0400 (EDT) |
sparkyx pushed a commit to branch unstable
in repository noalyss.
commit 088bf1a0872663ebd1bf039caaaacfaa10f6c1a0
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Sat Sep 21 18:32:41 2024 +0200
Update MOD1, Belgian template add VAT, document,...
---
include/sql/mod1/data.sql | 957 +++++++++++++++++++++++++++++++-------------
include/sql/mod1/schema.sql | 50 ++-
2 files changed, 709 insertions(+), 298 deletions(-)
diff --git a/include/sql/mod1/data.sql b/include/sql/mod1/data.sql
index c9b73396e..a9f2e5bdd 100644
--- a/include/sql/mod1/data.sql
+++ b/include/sql/mod1/data.sql
@@ -13,6 +13,34 @@ SET client_min_messages = warning;
SET row_security = off;
+SELECT pg_catalog.lo_create('2346174');
+
+
+
+SELECT pg_catalog.lo_create('2346176');
+
+
+
+SELECT pg_catalog.lo_create('2346177');
+
+
+
+SELECT pg_catalog.lo_create('2346178');
+
+
+
+SELECT pg_catalog.lo_create('2346179');
+
+
+
+SELECT pg_catalog.lo_create('2346181');
+
+
+
+SELECT pg_catalog.lo_create('2346476');
+
+
+
@@ -33,53 +61,66 @@ INSERT INTO public.action (ac_id, ac_description,
ac_module, ac_code) VALUES (11
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (1,
'Document Interne', 'DOCUME1');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (2, 'Bons
de commande client', 'BONSDE2');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (3, 'Bon
de commande Fournisseur', 'BONDEC3');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (4,
'Facture', 'FACTUR4');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (5,
'Lettre de rappel', 'LETTRE5');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (6,
'Courrier', 'COURRI6');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (7,
'Proposition', 'PROPOS7');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (8,
'Email', 'EMAIL8');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (9,
'Divers', 'DIVERS9');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (10,
'Note de frais', 'NOTEDE10');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (20,
'Réception commande Fournisseur', 'RÉCEPT20');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (21,
'Réception commande Client', 'RÉCEPT21');
-INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (22,
'Réception magazine', 'RÉCEPT22');
+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', 'RMG');
+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 (7,
'Proposition', 'PRP');
+INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (10,
'Note de frais', 'NFR');
+INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (5,
'Lettre de rappel', 'RAP');
+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 (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.document_type (dt_id, dt_value, dt_prefix) VALUES (1,
'Document Interne', 'DI');
+INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (9,
'Divers', 'DS');
+INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (6,
'Courrier', 'CO');
+INSERT INTO public.document_type (dt_id, dt_value, dt_prefix) VALUES (8,
'Email', 'EL');
-INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (1,
'Vente Service', '700');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (2,
'Achat Marchandises', '604');
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 (5,
'Prêt > a un an', '17');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (6,
'Prêt < a un an', '430');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (8,
'Fournisseurs', '440');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (9,
'Clients', '400');
-INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(10, 'Salaire Administrateur', '6200');
-INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(11, 'Salaire Ouvrier', '6203');
-INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(12, 'Salaire Employé', '6202');
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 (7,
'Matériel à amortir', '2400');
-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
(25, 'Compte Salarié / Administrateur', NULL);
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (4,
'Trésorerie', '5500');
INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(26, 'Projet', NULL);
+INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (1,
'Vente Service', '700');
+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
(16, 'Contact', NULL);
+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 (7,
'Matériel à amortir', '240');
+INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(10, 'Salaire Administrateur', '6200');
+INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(11, 'Salaire Ouvrier', '6203');
+INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(12, 'Salaire Employé', '6202');
+INSERT INTO public.fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES
(27, 'Vente Marchandise', '701');
-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, '400', '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, '5500', '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, '440', '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_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (7, '240', 'Matériel à
amortir', true, 7, 'Matériel à amortir ');
+INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (8, NULL, 'Contact', false,
16, 'Personnes de contact');
+INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (9, NULL, 'Administrateurs et
salariés', false, 25, 'Suivi des administrateurs et des salariés');
+INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (12, '6200', 'Charges et
salaires administrateurs', true, 10, 'Rémunérations , primes, ... et charges
sociales pour les administrateurs');
+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, 'Code pour identifier élément du stock');
+INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (11, '6202', 'Charges et
salaires employés', true, 12, 'Rémunérations , primes, ... et charges sociales
pour les employés');
+INSERT INTO public.fiche_def (fd_id, fd_class_base, fd_label,
fd_create_account, frd_id, fd_description) VALUES (13, '701', 'Vente de
marchandises', true, 27, 'Vente de marchandises');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (21, 3, '1');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (22, 4, '1');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (23, 5, '1');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (24, 2, '1');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (25, 9, '1');
+INSERT INTO public.fiche (f_id, fd_id, f_enable) VALUES (26, 6, '1');
@@ -118,10 +159,11 @@ INSERT INTO public.jrn_type (jrn_type_id, jrn_desc)
VALUES ('ODS', 'Opérations
-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', '6*', '4*', '5', '4',
1, 3, true, 'échéance', 'ACH', 'A01', 'AC [...]
-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', '5* ', '5*',
'3,2,4', '3,2,4', 5, 5, false, NULL, 'FIN', 'F [...]
-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,
NULL, NULL, NULL, 5, 5, false, NULL, 'ODS', [...]
-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', '4*', '7*', '2', '6',
2, 1, true, 'échéance', 'VEN', 'V01', 'VE [...]
+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', '5* ', '5*',
'9,3,2,4', '3,2,4', 5, 5, false, 'echeance', ' [...]
+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', '6*', '4*', '1,7,5',
'4', 1, 3, true, 'echeance', 'ACH', 'A01', [...]
+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,
NULL, NULL, NULL, 5, 5, false, 'echeance', ' [...]
+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 (5, 'Salaire', NULL, NULL, NULL,
NULL, 5, NULL, NULL, 'echeance', 'ODS', 'O0 [...]
+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', '4*', '7*', '2',
'6,13', 2, 1, true, 'echeance', 'VEN', 'V01', [...]
@@ -184,15 +226,20 @@ INSERT INTO public.attr_def (ad_id, ad_text, ad_type,
ad_size, ad_extra, ad_sear
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 (9001, 'Numéro national', 'text',
'22', NULL, 0, 120);
+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_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 (1, 2,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 6,
40);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 7,
50);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 19,
60);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 23,
70);
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);
@@ -221,14 +268,12 @@ 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 (27, 6,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (27, 19,
50);
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);
@@ -237,10 +282,6 @@ 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);
@@ -252,7 +293,6 @@ 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);
@@ -260,45 +300,77 @@ INSERT INTO public.attr_min (frd_id, ad_id,
ad_default_order) VALUES (5, 23, 999
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 (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 (14, 1,
10);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 9,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 5,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 26,
60);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 14,
90);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 24,
110);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 16,
120);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 23,
130);
+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, 32,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 25,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 18,
50);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 27,
60);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 17,
70);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 26,
80);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 23,
90);
+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,
9001, 30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 27,
50);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 14,
60);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 15,
70);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 16,
80);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 24,
90);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 4,
100);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 3,
110);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 5,
120);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 23,
130);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 33,
NULL);
+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 (10, 9,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (10, 23,
40);
+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, 5,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (11, 23,
40);
+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 (12, 9,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (12, 23,
40);
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.attr_min (frd_id, ad_id, ad_default_order) VALUES (1, 5,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 18,
40);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 34,
50);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 27,
70);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 17,
80);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (14, 15,
100);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (16, 9,
40);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 32,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (25, 18,
40);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 7,
NULL);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (7, 5,
NULL);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (10, 5,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (11, 9,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (12, 5,
30);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (27, 1,
10);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (27, 9,
20);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (27, 2,
40);
+INSERT INTO public.attr_min (frd_id, ad_id, ad_default_order) VALUES (27, 23,
60);
@@ -328,7 +400,6 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('610002', 'Loyer', '61', 'CHA', 538, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('610003', 'Assurance', '61', 'CHA', 539, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('610004', 'Matériel bureau', '61', 'CHA', 540, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7000002', 'Marchandise A', '700', 'PRO', 541, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7000001', 'Prestation', '700', 'PRO', 542, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7000003', 'Déplacement', '700', 'PRO', 543, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('101', 'Capital non appelé', '10', 'PASINV', 544, 'Y');
@@ -349,12 +420,6 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('695', 'Administrateurs ou gérants', '69', 'CHA', 562,
'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('696', 'Autres allocataires', '69', 'CHA', 563, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('700', 'Ventes et prestations de services', '70',
'PRO', 565, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('701', 'Ventes et prestations de services', '70',
'PRO', 566, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('702', 'Ventes et prestations de services', '70',
'PRO', 567, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('703', 'Ventes et prestations de services', '70',
'PRO', 568, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('704', 'Ventes et prestations de services', '70',
'PRO', 569, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('706', 'Ventes et prestations de services', '70',
'PRO', 570, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('707', 'Ventes et prestations de services', '70',
'PRO', 571, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('709', 'Remises, ristournes et rabais accordés(-)',
'70', 'PROINV', 572, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('712', 'des en-cours de fabrication', '71', 'PRO', 574,
'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('713', 'des produits finis', '71', 'PRO', 575, 'Y');
@@ -400,6 +465,7 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7712', 'Reprises de provisions fiscales', '771',
'PRO', 620, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('773', 'Impôts étrangers sur le résultats', '77',
'PRO', 621, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('790', 'Bénéfice reporté de l''exercice précédent',
'79', 'PRO', 623, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('701', 'Ventes de biens, livraison', '70', 'PRO', 566,
'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('791', 'Prélévement sur le capital et les primes
d''émission', '79', 'PRO', 624, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('792', 'Prélévement sur les réserves', '79', 'PRO',
625, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('793', 'Perte à reporter', '79', 'PRO', 626, 'Y');
@@ -539,7 +605,6 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('6241', 'Personnel', '624', 'CHA', 776, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('630', 'Dotations aux amortissements et réduction de
valeurs sur immobilisations', '63', 'CHA', 778, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('6300', ' Dotations aux amortissements sur frais
d''établissement', '630', 'CHA', 779, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('705', 'Ventes et prestations de services', '70',
'PRO', 780, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('414', 'Produits à recevoir', '41', 'ACT', 781, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('416', 'Créances diverses', '41', 'ACT', 782, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4160', 'Comptes de l''exploitant', '416', 'ACT', 783,
'Y');
@@ -744,13 +809,8 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('2819', 'Réduction de valeurs actées', '281', 'ACT',
1020, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('282', 'Participations dans des entreprises avec
lesquelles il existe un lien de participation', '28', 'ACT', 1021, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('2820', 'Valeur d''acquisition', '282', 'ACT', 1022,
'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4516', 'Tva Export 0%', '451', 'PAS', 1023, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4115', 'Tva Intracomm 0%', '411', 'ACT', 1024, 'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4116', 'Tva Export 0%', '411', 'ACT', 1025, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('41141', 'TVA pour l\''export', '4114', 'ACT', 1026,
'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('41142', 'TVA sur les opérations intracommunautaires',
'4114', 'ACT', 1027, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('45141', 'TVA pour l\''export', '451', 'PAS', 1028,
'Y');
-INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('45142', 'TVA sur les opérations intracommunautaires',
'4514', 'PAS', 1029, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('41143', 'TVA sur les opérations avec des assujettis
art 44 Code TVA', '4114', 'ACT', 1030, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('45143', 'TVA sur les opérations avec des assujettis
art 44 Code TVA', '4514', 'PAS', 1031, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('41144', 'TVA sur les opérations avec des
cocontractants', '4114', 'ACT', 1032, 'Y');
@@ -768,6 +828,9 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('9', 'Comptes hors Compta', '0', 'CON', 547, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('68', 'Transferts aux réserves immunisées', '6', 'CHA',
555, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('69', 'Affectations et prélévements', '6', 'CHA', 556,
'N');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('45142', 'Tva due importation hors EU', '451', 'PAS',
1023, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('411502', 'TVA sur les opérations intracommunautaires',
'4115', 'ACT', 1027, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('451502', 'TVA sur les opérations intracommunautaires',
'4515', 'PAS', 1029, 'Y');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('70', 'Chiffre d''affaire', '7', 'PRO', 564, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('71', 'Variations des stocks et commandes en cours
d''éxécution', '7', 'PRO', 573, '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', 'PRO', 580, 'N');
@@ -827,6 +890,27 @@ INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib,
pcm_val_parent, pcm_type, id, pcm
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('26', 'Autres immobilisations corporelles', '2', 'ACT',
1007, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('27', 'Immobilisations corporelles en cours et acomptes
versés', '2', 'ACT', 1008, 'N');
INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('28', 'Immobilisations financières', '2', 'ACT', 1009,
'N');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('240', 'Matériel à amortir', '24', 'ACT', 1037, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('55000004', 'Banque', '5500', 'ACT', 1038, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4400004', 'fournisseur1', '440', 'PAS', 1039, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('610005', 'Services et biens divers', '61', 'CHA',
1040, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7010001', 'Marchandises', '701', 'PRO', 1041, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4119', 'Compte TVA créance', '411', 'ACT', 1042, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4519', 'Compte TVA Dette', '451', 'PAS', 1043, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4890001', 'Administrateur principal', '4890', 'PAS',
1044, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4115', 'Tva Intracomm', '411', 'ACT', 1024, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('411501', 'TVA Intra grille 45 ou 85', '4115', 'ACT',
1047, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4116', 'Note de crédit', '411', 'ACT', 1049, 'N');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('411602', 'TVA Note de crédit délivrée', '4116',
'PAS', 1050, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4516', 'TVA Note de crédit à reverser', '451', 'PAS',
1051, 'N');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('451602', 'Note de crédit reçue', '4516', 'PAS', 1052,
'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('411603', 'TVA NC sur intra', '4116', 'ACT', 1053, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('451603', 'TVA Note de crédit sur intra', '4516',
'PAS', 1054, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('4515', 'TVA Intracomm', '451', 'PAS', 1046, 'N');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('451501', 'TVA Intra lieu Belgique', '451', 'PAS',
1045, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('7000004', 'Nom vide', '700', 'PRO', 1055, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('451504', 'TVA Intra 39bis', '4515', 'PAS', 1048, 'Y');
+INSERT INTO public.tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type, id,
pcm_direct_use) VALUES ('411504', 'Livraison art 39bis (transport neuf) g.46',
'4115', 'ACT', 1056, 'Y');
@@ -852,58 +936,107 @@ INSERT INTO public.document_component (dc_id, dc_code,
dc_comment) VALUES (3, 'G
+INSERT INTO public.document_modele (md_id, md_name, md_lob, md_type,
md_filename, md_mimetype, md_affect) VALUES (2, 'Devis', 2346174, 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 (4, 'Rappel', 2346176, 5,
'rappel.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 (5, 'Note de frais', 2346177, 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', 2346178, 10,
'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, 'Note de crédit', 2346179, 4,
'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 (3, 'Facture', 2346181, 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 (8, 'Facture', 2346476, 3,
'modele-facture.ods', 'application/vnd.oasis.opendocument.spreadsheet', 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (73, 'editable_description', 3, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (74, 'make_invoice', 3, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (22, 'contact_multiple', 1, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (23, 'contact_multiple', 2, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (24, 'contact_multiple', 3, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (25, 'contact_multiple', 4, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (26, 'contact_multiple', 5, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (27, 'contact_multiple', 6, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (28, 'contact_multiple', 7, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (29, 'contact_multiple', 8, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (30, 'contact_multiple', 9, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (31, 'contact_multiple', 10, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (32, 'contact_multiple', 20, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (33, 'contact_multiple', 21, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (34, 'contact_multiple', 22, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (199, 'editable_description', 1, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (35, 'make_invoice', 2, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (36, 'make_invoice', 4, 1, NULL);
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (37, 'detail_operation', 2, 1, 'VEN');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (38, 'detail_operation', 3, 1, 'VEN');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (39, 'detail_operation', 4, 1, 'VEN');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (40, 'detail_operation', 5, 1, 'VEN');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (41, 'detail_operation', 10, 1, 'ACH');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (42, 'detail_operation', 20, 1, 'ACH');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (43, 'detail_operation', 21, 1, 'VEN');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (44, 'followup_comment', 1, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (45, 'followup_comment', 2, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (82, 'make_feenote', 2, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (75, 'make_feenote', 3, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (46, 'followup_comment', 3, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (47, 'followup_comment', 4, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (48, 'followup_comment', 5, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (59, 'videoconf_server', 3, 1,
'https://www.free-solutions.org/');
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (49, 'followup_comment', 6, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (50, 'followup_comment', 7, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (51, 'followup_comment', 8, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (52, 'followup_comment', 9, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (45, 'followup_comment', 2, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (58, '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 (25, 'contact_multiple', 4, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (64, '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 (27, 'contact_multiple', 6, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (87, 'editable_description', 6, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (101, 'editable_description', 10, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (102, 'make_invoice', 10, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (94, 'editable_description', 4, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (36, 'make_invoice', 4, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (96, 'make_feenote', 4, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (70, 'make_feenote', 10, 1, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (53, 'followup_comment', 10, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (66, '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 (43, 'detail_operation', 21, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (33, 'contact_multiple', 21, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (136, 'editable_description', 21, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (42, 'detail_operation', 20, 1, 'ACH');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (32, 'contact_multiple', 20, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (122, 'editable_description', 20, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (123, 'make_invoice', 20, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (124, 'make_feenote', 20, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (54, 'followup_comment', 20, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (55, 'followup_comment', 21, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (67, '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 (113, 'detail_operation', 22, 0, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (34, 'contact_multiple', 22, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (115, 'editable_description', 22, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (116, 'make_invoice', 22, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (117, 'make_feenote', 22, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (56, 'followup_comment', 22, 1, 'SOME_FIXED');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (57, '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 (58, '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 (59, 'videoconf_server', 3, 1,
'https://www.free-solutions.org/');
-INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (60, '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 (69, '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 (137, 'make_invoice', 21, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (138, 'make_feenote', 21, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (55, 'followup_comment', 21, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (68, '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 (106, 'detail_operation', 7, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (28, 'contact_multiple', 7, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (108, 'editable_description', 7, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (109, 'make_invoice', 7, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (110, 'make_feenote', 7, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (50, 'followup_comment', 7, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (63, '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 (41, 'detail_operation', 10, 1, 'ACH');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (31, 'contact_multiple', 10, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (40, 'detail_operation', 5, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (26, 'contact_multiple', 5, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (157, 'editable_description', 5, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (158, 'make_invoice', 5, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (159, 'make_feenote', 5, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (48, 'followup_comment', 5, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (61, '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 (39, 'detail_operation', 4, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (47, 'followup_comment', 4, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (60, '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 (171, 'editable_description', 8, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (88, 'make_invoice', 6, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (89, 'make_feenote', 6, 0, NULL);
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (62, '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 (63, '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 (64, '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 (169, 'detail_operation', 8, 0, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (37, 'detail_operation', 2, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (23, 'contact_multiple', 2, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (80, 'editable_description', 2, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (38, 'detail_operation', 3, 1, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (24, 'contact_multiple', 3, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (197, 'detail_operation', 1, 0, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (200, 'make_invoice', 1, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (201, 'make_feenote', 1, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (44, 'followup_comment', 1, 1, 'SOME_FIXED');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (57, '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 (204, 'detail_operation', 9, 0, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (30, 'contact_multiple', 9, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (206, 'editable_description', 9, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (207, 'make_invoice', 9, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (208, 'make_feenote', 9, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (52, 'followup_comment', 9, 1, 'SOME_FIXED');
INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (65, '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 (66, '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 (67, '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 (68, '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 (69, '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 (70, 'make_feenote', 10, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (85, 'detail_operation', 6, 0, 'VEN');
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (29, 'contact_multiple', 8, 1, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (172, 'make_invoice', 8, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (173, 'make_feenote', 8, 0, NULL);
+INSERT INTO public.document_option (do_id, do_code, document_type_id,
do_enable, do_option) VALUES (51, 'followup_comment', 8, 1, 'SOME_FIXED');
@@ -917,22 +1050,92 @@ INSERT INTO public.document_state (s_id, s_value,
s_status) VALUES (4, 'Abandonn
-
-
-
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (79, '2010-01-01', '2010-01-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (80, '2010-02-01', '2010-02-28', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (81, '2010-03-01', '2010-03-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (82, '2010-04-01', '2010-04-30', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (83, '2010-05-01', '2010-05-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (84, '2010-06-01', '2010-06-30', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (85, '2010-07-01', '2010-07-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (86, '2010-08-01', '2010-08-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (87, '2010-09-01', '2010-09-30', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (88, '2010-10-01', '2010-10-31', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (89, '2010-11-01', '2010-11-30', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (90, '2010-12-01', '2010-12-30', '2010',
false, false, '2010');
-INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (91, '2010-12-31', '2010-12-31', '2010',
false, false, '2010');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (373,
21, 23, '55B');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (372,
21, 1, 'Banque');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (374,
21, 3, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (424,
25, 23, '48ADM1');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (375,
21, 4, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (423,
25, 1, 'Administrateur principal');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (376,
21, 12, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (377,
21, 5, '55000004');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (425,
25, 32, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (378,
21, 13, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (379,
21, 14, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (426,
25, 9001, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (380,
21, 34, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (381,
21, 15, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (427,
25, 18, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (382,
21, 16, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (383,
21, 17, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (428,
25, 27, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (384,
21, 18, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (429,
25, 14, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (430,
25, 15, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (431,
25, 16, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (432,
25, 24, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (433,
25, 4, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (434,
25, 3, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (435,
25, 5, '4890001');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (385,
22, 1, 'Fournisseurs divers');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (387,
22, 12, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (388,
22, 5, '4400001');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (389,
22, 13, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (391,
22, 34, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (390,
22, 14, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (392,
22, 15, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (393,
22, 24, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (394,
22, 16, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (395,
22, 17, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (396,
22, 18, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (386,
22, 23, '44DIV');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (398,
23, 23, '61DIV');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (397,
23, 1, 'Services et biens divers');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (399,
23, 9, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (437,
26, 23, 'NOMVID');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (400,
23, 2, '1');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (436,
26, 1, 'Nom vide');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (401,
23, 7, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (402,
23, 5, '610005');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (438,
26, 9, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (403,
23, 31, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (404,
23, 52, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (439,
26, 2, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (405,
23, 20, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (406,
23, 53, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (440,
26, 5, '7000004');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (407,
23, 21, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (408,
23, 51, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (441,
26, 6, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (409,
23, 22, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (410,
23, 50, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (412,
24, 23, '40DIV');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (411,
24, 1, 'Client divers');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (442,
26, 19, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (413,
24, 12, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (414,
24, 5, '4000001');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (415,
24, 13, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (416,
24, 34, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (417,
24, 14, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (418,
24, 15, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (419,
24, 24, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (420,
24, 16, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (421,
24, 17, '');
+INSERT INTO public.fiche_detail (jft_id, f_id, ad_id, ad_value) VALUES (422,
24, 18, '');
+
+
+
+INSERT INTO public.parm_periode (p_id, p_start, p_end, p_exercice, p_closed,
p_central, p_exercice_label) VALUES (92, '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 (93, '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 (94, '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 (95, '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 (96, '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 (97, '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 (98, '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 (99, '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 (100, '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 (101, '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 (102, '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 (103, '2024-12-01', '2024-12-31', '2024',
false, false, '2024');
@@ -977,11 +1180,8 @@ INSERT INTO public.info_def (id_type, id_description)
VALUES ('OTHER', 'Info div
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);
@@ -989,13 +1189,8 @@ INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id,
jnt_order) VALUES (1, 2,
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);
@@ -1012,8 +1207,6 @@ INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id,
jnt_order) VALUES (2, 23,
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);
@@ -1023,16 +1216,80 @@ INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id,
jnt_order) VALUES (1, 5,
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
(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, 65, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2,
34, 66, 40);
INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3,
34, 67, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
1, 140, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
32, 141, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
9001, 142, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
1, 36, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
9, 80, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
2, 37, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
7, 38, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
5, 35, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
31, 72, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
52, 73, 70);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
20, 74, 80);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
53, 75, 90);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
21, 76, 100);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
51, 77, 110);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
22, 78, 120);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
50, 79, 130);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5,
23, 49, 140);
+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 (6,
1, 40, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
9, 100, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
2, 41, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
5, 39, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
6, 42, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
19, 44, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6,
23, 50, 70);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
1, 106, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
9, 107, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
5, 112, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
7, 111, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
8, 108, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
33, 113, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
10, 109, 70);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (7,
23, 110, 80);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
1, 122, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
32, 123, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
25, 124, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
9, 125, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
18, 126, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
27, 127, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
17, 128, 70);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
26, 129, 80);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (8,
23, 130, 90);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
18, 143, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
27, 144, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
14, 145, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
15, 146, 70);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
16, 147, 80);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
24, 148, 90);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
4, 149, 100);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
3, 150, 110);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
5, 151, 120);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (9,
23, 152, 130);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (11,
1, 173, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (11,
9, 174, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (11,
5, 175, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (11,
23, 176, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (12,
1, 177, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (12,
9, 178, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (12,
5, 179, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (12,
23, 180, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
1, 181, 10);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
9, 182, 20);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
6, 183, 30);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
2, 184, 40);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
19, 185, 50);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
23, 186, 60);
+INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (13,
5, 187, 10);
@@ -1051,58 +1308,66 @@ INSERT INTO public.jnt_fic_attr (fd_id, ad_id, jnt_id,
jnt_order) VALUES (3, 34,
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 79,
'OP', 1);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 79,
'OP', 2);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 79,
'OP', 3);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 79,
'OP', 4);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 80,
'OP', 5);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 80,
'OP', 6);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 80,
'OP', 7);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 80,
'OP', 8);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 81,
'OP', 9);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 81,
'OP', 10);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 81,
'OP', 11);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 81,
'OP', 12);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 82,
'OP', 13);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 82,
'OP', 14);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 82,
'OP', 15);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 82,
'OP', 16);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 83,
'OP', 17);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 83,
'OP', 18);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 83,
'OP', 19);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 83,
'OP', 20);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 84,
'OP', 21);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 84,
'OP', 22);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 84,
'OP', 23);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 84,
'OP', 24);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 85,
'OP', 25);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 85,
'OP', 26);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 85,
'OP', 27);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 85,
'OP', 28);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 86,
'OP', 29);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 86,
'OP', 30);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 86,
'OP', 31);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 86,
'OP', 32);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 87,
'OP', 33);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 87,
'OP', 34);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 87,
'OP', 35);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 87,
'OP', 36);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 88,
'OP', 37);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 88,
'OP', 38);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 88,
'OP', 39);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 88,
'OP', 40);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 89,
'OP', 41);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 89,
'OP', 42);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 89,
'OP', 43);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 89,
'OP', 44);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 90,
'OP', 45);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 90,
'OP', 46);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 90,
'OP', 47);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 90,
'OP', 48);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 91,
'OP', 49);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 91,
'OP', 50);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 91,
'OP', 51);
-INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 91,
'OP', 52);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 92,
'OP', 113);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 92,
'OP', 114);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 92,
'OP', 115);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 92,
'OP', 116);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 92,
'OP', 117);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 93,
'OP', 118);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 93,
'OP', 119);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 93,
'OP', 120);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 93,
'OP', 121);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 93,
'OP', 122);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 94,
'OP', 123);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 94,
'OP', 124);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 94,
'OP', 125);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 94,
'OP', 126);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 94,
'OP', 127);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 95,
'OP', 128);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 95,
'OP', 129);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 95,
'OP', 130);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 95,
'OP', 131);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 95,
'OP', 132);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 96,
'OP', 133);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 96,
'OP', 134);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 96,
'OP', 135);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 96,
'OP', 136);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 96,
'OP', 137);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 97,
'OP', 138);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 97,
'OP', 139);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 97,
'OP', 140);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 97,
'OP', 141);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 97,
'OP', 142);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 98,
'OP', 143);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 98,
'OP', 144);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 98,
'OP', 145);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 98,
'OP', 146);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 98,
'OP', 147);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 99,
'OP', 148);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 99,
'OP', 149);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 99,
'OP', 150);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 99,
'OP', 151);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 99,
'OP', 152);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 100,
'OP', 153);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 100,
'OP', 154);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 100,
'OP', 155);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 100,
'OP', 156);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 100,
'OP', 157);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 101,
'OP', 158);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 101,
'OP', 159);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 101,
'OP', 160);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 101,
'OP', 161);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 101,
'OP', 162);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 102,
'OP', 163);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 102,
'OP', 164);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 102,
'OP', 165);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 102,
'OP', 166);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 102,
'OP', 167);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (1, 103,
'OP', 168);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (3, 103,
'OP', 169);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (4, 103,
'OP', 170);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (5, 103,
'OP', 171);
+INSERT INTO public.jrn_periode (jrn_def_id, p_id, status, id) VALUES (2, 103,
'OP', 172);
@@ -1197,6 +1462,8 @@ INSERT INTO public.menu_ref (me_code, me_menu, me_file,
me_url, me_description,
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 ('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 ('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');
@@ -1227,6 +1494,11 @@ INSERT INTO public.menu_ref (me_code, me_menu, me_file,
me_url, me_description,
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 ('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 ('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');
@@ -1238,7 +1510,6 @@ INSERT INTO public.menu_ref (me_code, me_menu, me_file,
me_url, me_description,
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);
@@ -1262,41 +1533,85 @@ INSERT INTO public.menu_ref (me_code, me_menu, me_file,
me_url, me_description,
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 📅', '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 ('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 ('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 ('C0ETS', 'Etat des documents', 'doc_state.inc.php', NULL, 'Etat des
documents', 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 ('MANAGER', 'Personnel', 'manager.inc.php', NULL, 'Suivi des
administrateurs et salariés', 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 ('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 🔧', 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 ('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 ('SEARCH', 'Recherche 🔎', 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 ('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 ('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 ('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 ('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 ('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 👤', 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 ('PREFERENCE', 'Préférence 👤', 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 📊', 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 📇', '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 ✨', 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.menu_ref (me_code, me_menu, me_file, me_url,
me_description, me_parameter, me_javascript, me_type, me_description_etendue)
VALUES ('IMPOP', 'Importation operations', 'import_account/index.php', NULL,
'OBSOLETE Importation et exportation d''operations
+ remplacé par noalyss-export et import-advanced',
'plugin_code=IMPOP', NULL, 'PL', 'Dany De Bontridder');
+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 ('PORTAL1', 'Portal Client', 'noalyss-portal-client/index.php', NULL,
'Plugin to manage the client', 'plugin_code=PORTAL1', NULL, 'PL', 'Dany De
Bontridder');
+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 ('TS1', 'Saisie présence', 'noalyss-timesheet/input-ts.php', NULL,
'Saisie des heures dans les feuilles de présence (timesheet)',
'plugin_code=TS1', NULL, 'PL', 'Dany De Bontridder');
+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 ('TS2', 'Administration TS', 'noalyss-timesheet/admin-ts.php', NULL,
'Paramètre, utilisateurs et sécurité pour l''extension feuilles de présence
(timesheet)', 'plugin_code=TS2', NULL, 'PL', 'Dany De Bontridder');
+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 ('TS3', 'Impression TS', 'noalyss-timesheet/export-ts.php', NULL,
'Impressions avancées pour l''extension feuilles de présence (timesheet)',
'plugin_code=TS3', NULL, 'PL', 'Dany De Bontridder');
+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 ('BACKNOADM', 'Backup', 'backup_noadmin/index.php', NULL, 'Backup
dossier', 'plugin_code=BACKNOADM', NULL, 'PL', 'Dany De Bontridder');
+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 ('IMPOP2', 'Importation Avancée', 'import-advanced/index.php', NULL,
'Importation et exportation d''operations comptables et analytiques.
+ Version modifiée de import_account.
+ Supporte les devises', 'plugin_code=IMPOP2', NULL, 'PL', 'Dany De
Bontridder');
+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 ('IMPCARD', 'Import de fiches', 'import_card/index.php', NULL,
'Importation de fiches', 'plugin_code=IMPCARD', NULL, 'PL', 'Dany De
Bontridder');
+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 ('INVOICING', 'Facturation', 'invoicing/index.php', NULL, 'Facturation,
envoi de facture, téléchargement', 'plugin_code=INVOICING', NULL, 'PL', 'Dany
De Bontridder');
+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 ('LISTING', 'Listing', 'listing/index.php', NULL, 'Création de listes ,
envoi de courriers', 'plugin_code=LISTING', NULL, 'PL', 'Dany De Bontridder');
+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 ('MODOP', 'Modification', 'modop/index.php', NULL, 'Modification
d''opération', 'plugin_code=MODOP', NULL, 'PL', 'Dany De Bontridder');
+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 ('EXPORT', 'Exportation données', 'noalyss-export/index.php', NULL,
'Permet l''export des données de Noalyss , en différent format : FEC, CSV',
'plugin_code=EXPORT', NULL, 'PL', 'Dany De Bontridder');
+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 ('FVAL', 'Validation Formulaire', 'noalyss-form/validate.php', NULL,
'Validation d''un formulaire reçu depuis Internet', 'plugin_code=FVAL', NULL,
'PL', 'Dany De Bontridder');
+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 ('FDEF', 'Création Formulaire', 'noalyss-form/manage.php', NULL,
'Définition de formulaire qu''on pourrait recevoir', 'plugin_code=FDEF', NULL,
'PL', 'Dany De Bontridder');
+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 ('IMPORTBANK', 'Import Banque', 'importbank/index.php', NULL,
'Importation de fichiers CSV dans les journaux financiers',
'plugin_code=IMPORTBANK', NULL, 'PL', 'Dany De Bontridder');
+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 ('WSC', 'WebService Setting', 'noalyss-webservice/nw_setup.php', NULL,
'Configuration du webservice pour Noalyss', 'plugin_code=WSC', NULL, 'PL',
'Dany De Bontridder');
+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 ('NWS', 'WebService', 'noalyss-webservice/nw_service.php', NULL,
'Webservice pour Noalyss', 'plugin_code=NWS', NULL, 'PL', 'Dany De Bontridder');
+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 ('OHAT7', 'Stock', 'ohada/Stock.php', NULL, 'Etats annexes stocks SMT
OHADA', 'plugin_code=OHAT7', NULL, 'PL', 'Dany De Bontridder');
+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 ('OHAPAR', 'Paramètre OHADA', 'ohada/parameter.php', NULL, 'Paramètre
Etats Annexes OHADA', 'plugin_code=OHAPAR', NULL, 'PL', 'Dany De Bontridder');
+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 ('OHBIL1', 'Bilan SMT', 'ohada/bilan1.php', NULL, 'Bilan SMT OHADA',
'plugin_code=OHBIL1', NULL, 'PL', 'Dany De Bontridder');
+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 ('SKEL', 'Skeleton for plugin', 'skel/index.php', NULL, 'Example of an
XML File for developing a plugin.', 'plugin_code=SKEL', NULL, 'PL', 'votre
nom');
+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 ('TOOLPCMN', 'Import/export plan', 'tool_pcmn/index.php', NULL,
'Import/export plan comptable', 'plugin_code=TOOLPCMN', NULL, 'PL', 'Dany De
Bontridder');
+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 ('TOOLS', 'Outils comptables', 'tools/index.php', NULL, 'Outils
comptable, chgt poste,fiche...', 'plugin_code=TOOLS', NULL, 'PL', 'Dany De
Bontridder');
+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 ('TRANSFORM', 'Transformation', 'transform/index.php', NULL,
'Transformation de données dans un autre format', 'plugin_code=TRANSFORM',
NULL, 'PL', 'Dany De Bontridder');
+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 ('TVA', 'TVA', 'tva/index.php', NULL, 'Plugin : Cette extension
permettait de faire les listings et declarations TVA', 'plugin_code=TVA', NULL,
'PL', 'Dany De Bontridder');
+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 ('AMORTIS', 'Amortissement', 'amortis/index.php', NULL, 'Gestion des
amortissements', 'plugin_code=AMORTIS', NULL, 'PL', 'Dany De Bontridder');
+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 ('BILANINTERNE', 'Bilan Interne', 'bilan_interne/index.php', NULL,
'Generation d''un bilan interne', 'plugin_code=BILANINTERNE', NULL, 'PL',
'Thierry Nancy');
+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 ('COPRO', 'Copropriété', 'coprop/index.php', NULL, 'Outils pour les
copropriétés', 'plugin_code=COPRO', NULL, 'PL', 'Dany De Bontridder');
+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 ('DOSDEMO', 'Dossier Démo', 'demo-noalyss/index.php', NULL, 'Permet la
restauration de différent dossiers dans le but d''avoir des dossiers de
démonstration', 'plugin_code=DOSDEMO', NULL, 'PL', 'Dany De Bontridder');
+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 ('NDER', 'Saisie et Chargement Document', 'noalyss_document/index.php',
NULL, 'Encodage rapide', 'plugin_code=NDER', NULL, 'PL', 'Dany De Bontridder');
+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 ('NDC', 'Chargement Document', 'noalyss_document/ndc_load.php', NULL,
'Chargement documents', 'plugin_code=NDC', NULL, 'PL', 'Dany De Bontridder');
+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 ('XMLPY', 'Paiement SEPA', 'noalyss_xmlpayment/index.php', NULL,
'création de fichier XML pour les paiements SEPA', 'plugin_code=XMLPY', NULL,
'PL', 'Dany De Bontridder');
+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 ('OHAT1', 'Trésorerie SMT', 'ohada/financial_ledger.php', NULL, 'Etats
annexes Trésorerie SMT OHADA', 'plugin_code=OHAT1', NULL, 'PL', 'Dany De
Bontridder');
+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 ('OHAT2', 'Dettes impayées', 'ohada/Unpaid_Supplier.php', NULL, 'Etats
annexes dettes impayées SMT OHADA', 'plugin_code=OHAT2', NULL, 'PL', 'Dany De
Bontridder');
+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 ('OHAT3', 'Créance impayées', 'ohada/Unpaid_Customer.php', NULL, 'Etats
annexes créances impayées SMT OHADA', 'plugin_code=OHAT3', NULL, 'PL', 'Dany De
Bontridder');
+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 ('OHAT4', 'Créance impayées dues', 'ohada/Unpaid_due_Customer.php',
NULL, 'Etats annexes créances impayées SMT OHADA', 'plugin_code=OHAT4', NULL,
'PL', 'Dany De Bontridder');
+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 ('OHRES1', 'Compte de résultat SMT', 'ohada/resultat1.php', NULL,
'Compte de résultat SMT OHADA', 'plugin_code=OHRES1', NULL, 'PL', 'Dany De
Bontridder');
+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 ('MGPR', 'Gestion Profil', 'profile_mgt/index.php', NULL, 'Permet
d''importer et d''exporter des profiles, avec toutes dépendances',
'plugin_code=MGPR', NULL, 'PL', 'Dany De Bontridder');
+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 ('RAPAV', 'Rapports avancés 📊', 'rapport_avance/index.php', NULL,
'Création de rapports avancés', 'plugin_code=RAPAV', NULL, 'PL', 'Dany De
Bontridder');
+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 ('RASH', 'RASH', 'rash/index.php', NULL, 'Le but de l’application est de
gérer l’entrée des bénéficiaires et le suivi de ceux-ci ainsi que
+ le reporting vers la Région Wallonne qui inclut des données
spécifiques à indiquer.', 'plugin_code=RASH', NULL, 'PL', 'Dany De Bontridder');
+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 ('RASHADM', 'RASH Administration', 'rash/adm.php', NULL, 'Permet de
gérer la sécurité de l''extension RASH', 'plugin_code=RASHADM', NULL, 'PL',
'Dany De Bontridder');
+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 ('RASHEXP', 'RASH Export', 'rash/rash-export.php', NULL, 'Permet
d''exporter des données de RASH', 'plugin_code=RASHEXP', NULL, 'PL', 'Dany De
Bontridder');
+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 ('SAV', 'Service après-vente', 'sav/index.php', NULL, 'Encodage de fiche
pour service après-vente', 'plugin_code=SAV', NULL, 'PL', 'Dany De Bontridder');
+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 ('OHAT5', 'Dettes impayées dues', 'ohada/Unpaid_due_Supplier.php', NULL,
'Etats annexes dettes impayées SMT OHADA', 'plugin_code=OHAT5', NULL, 'PL',
'Dany De Bontridder');
+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 ('OHAT6', 'Amortissement', 'ohada/Amortization.php', NULL, 'Etats
annexes amortissements SMT OHADA', 'plugin_code=OHAT6', NULL, 'PL', 'Dany De
Bontridder');
+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 ('EIXML', 'Export - Import XML', 'export-import-xml/index.php', NULL,
'Export and import backup as compressed XML files', 'plugin_code=EIXML', NULL,
'PL', 'Dany De Bontridder');
+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 ('TS4', 'Validation TS', 'noalyss-timesheet/validate-ts.php', NULL,
'Permet de valider les feuilles de présence(Timesheet) des personnes dont on
est responsable', 'plugin_code=TS4', NULL, 'PL', 'Dany De Bontridder');
@@ -1321,29 +1636,29 @@ INSERT INTO public.menu_ref (me_code, me_menu, me_file,
me_url, me_description,
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_NAME', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_CP', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_COMMUNE', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TVA', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_STREET', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_NUMBER', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TEL', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_PAYS', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_FAX', NULL);
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_ANALYTIC', 'nu');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_COUNTRY', 'BE');
+INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_NAME', '');
+INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_TVA', '');
+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', 'Y');
+INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_PJ_SUGGEST', 'A');
+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_CHECK_PERIODE',
'N');
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_UPDLAB', 'N');
+INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_UPDLAB', 'Y');
INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_STOCK', 'N');
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_ANC_FILTER', '6,7');
-INSERT INTO public.parameter (pr_id, pr_value) VALUES
('MY_DEFAULT_ROUND_ERROR_CRED', '755');
INSERT INTO public.parameter (pr_id, pr_value) VALUES
('MY_DEFAULT_ROUND_ERROR_DEB', '655');
-INSERT INTO public.parameter (pr_id, pr_value) VALUES ('MY_REPORT', 'N');
+INSERT INTO public.parameter (pr_id, pr_value) VALUES
('MY_DEFAULT_ROUND_ERROR_CRED', '755');
+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', 'Y');
@@ -1533,6 +1848,8 @@ INSERT INTO public.profile_menu (pm_id, me_code,
me_code_dep, p_id, p_order, p_t
INSERT 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, 878);
INSERT 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);
@@ -1649,6 +1966,8 @@ INSERT INTO public.profile_menu (pm_id, me_code,
me_code_dep, p_id, p_order, p_t
INSERT 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 (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 (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);
@@ -1687,7 +2006,6 @@ INSERT INTO public.profile_menu (pm_id, me_code,
me_code_dep, p_id, p_order, p_t
INSERT 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, '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 (876, '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 (877, '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 (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 (55, 'PERIODE', 'MACC', 1, 20,
'E', 0, 880);
INSERT 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, 880);
INSERT 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:AncAccList', NULL, 1,
NULL, 'P', 0, NULL);
@@ -1747,24 +2065,21 @@ INSERT INTO public.profile_menu (pm_id, me_code,
me_code_dep, p_id, p_order, p_t
INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order,
p_type_display, pm_default, pm_id_dep) VALUES (893, '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, 880);
INSERT 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, 879);
-INSERT 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 (69, 'C0PCMN', 'MACC', 1, 40,
'E', 0, 880);
-INSERT 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 (74, 'C0JRN', 'MACC', 1, 90, 'E',
0, 880);
-INSERT 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, 879);
INSERT 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, 880);
INSERT 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, 880);
INSERT 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, 879);
INSERT 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, 'C0OPT1', 'MCARD', 1, 85,
'E', 0, 878);
-INSERT 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, 'C0OPT1', 'MCARD', 1, 85,
'E', 0, 878);
+INSERT 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 (60, 'C0TVA', 'MACC', 1, 50, 'E',
0, 880);
+INSERT 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, 879);
INSERT 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, 880);
-INSERT 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, 878);
+INSERT INTO public.profile_menu (pm_id, me_code, me_code_dep, p_id, p_order,
p_type_display, pm_default, pm_id_dep) VALUES (894, 'TVA', 'EXT', 1, 9000, 'S',
0, 82);
@@ -1786,21 +2101,23 @@ INSERT INTO public.profile_sec_repository (ur_id, p_id,
r_id, ur_right) VALUES (
-INSERT INTO public.profile_user (user_name, pu_id, p_id) VALUES ('phpcompta',
1, 1);
-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 (4, '0%', 0.0000, 'Aucune tva n''est applicable', '4114,4514', 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 (6, 'EXPORT', 0.0000, 'Tva pour les exportations', '41141,45144', 0,
'O', 'O', '0B');
-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 (5, 'INTRA', 0.0000, 'Tva pour les livraisons / acquisition intra
communautaires', '41142,45142', 0, 'O', 'O', '0C');
-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 (7, 'COC', 0.0000, 'Opérations avec des cocontractants', '41144,45144',
0, 'O', 'O', '0D');
-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 (8, 'ART44', 0.0000, 'Opérations pour les opérations avec des assujettis
à l\''art 44 Code TVA', '41143,45143', 0, 'O', 'O', '0E');
-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 (3, '6%', 0.0600, 'Tva applicable aux journaux et livres', '4113,4513',
0, 'O', 'O', '60A');
-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 (2, '12%', 0.1200, 'Tva ', '4112,4512', 0, 'O', 'O', '120A');
-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 (1, '21%', 0.2100, 'Tva applicable à tout ce qui bien et service
divers', '4111,4511', 0, 'O', 'O', '210A');
+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 (60, 'NCG21', 0.2100, 'Note de crédit générale 21%', '451602,411602', 0,
'O', 'O', 'NCG21');
+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 (61, 'NC - intra', 0.2100, 'TVA Note de crédit sur intra',
'411603,451603', 1, 'O', 'O', 'INTNC');
+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 (70, 'IMP', 0.2100, 'TVA due sur importation hors EU, à payer',
'45142,#', 0, 'O', 'O', 'IMP');
+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 (52, 'Intra Vente ABC', 0.2100, 'Livraison art 39bis (transport neuf)
g.46', '411504,451504', 1, 'O', 'O', 'INTC');
+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 (2, '12%', 0.1200, 'Tva (due 7% gril 02 & 54 - déd 6% 82 &59)',
'4112,4512', 0, 'O', 'O', '120A');
+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 (3, '6%', 0.0600, 'Tva applicable aux journaux et livres (due 7% Gril
01& 54) (déd 6%Gril 81 ou 82,Gril 59)', '4113,4513', 0, 'O', 'O', '60A');
+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 (1, '21%', 0.2100, 'TVA générale [PC 70% due Gril. 03 & 54] [avec PC 60%
déd Gr. 82 & 59 ] [ PC 61% déd. Gr. 81 & 59] [PC 22%,23%,24% déd Gr.83 & 59
]', '4111,4511', 0, 'O', 'O', '21G');
+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 (40, '0%', 0.0000, 'Aucune tva n''est applicable, assujettit mixte,
partiel (TVA Gril 00)', '4114,4514', 0, 'O', 'O', '0TVA');
+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 (41, 'EXPORT', 0.0000, 'Tva pour les exportations', '41141,45144', 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 (51, 'INTRA-EM', 0.2100, 'Intra Opération lieu dans autre Etat membre
(g45 g85)', '411501,451501', 1, 'O', 'O', 'INTEM');
+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 (50, 'INTRA-BEL', 0.2100, 'Tva intra communautaires (PC:7% g:44
g:88)-(6% g.86 g:55)', '411502,451502', 1, 'O', 'O', 'INT');
@@ -1816,6 +2133,7 @@ INSERT INTO public.tva_rate (tva_id, tva_label, tva_rate,
tva_comment, tva_poste
+INSERT INTO public.tmp_stockgood (s_id, s_date) VALUES (1, '2024-08-19
21:48:08.722122');
@@ -1828,6 +2146,14 @@ INSERT INTO public.tva_rate (tva_id, tva_label,
tva_rate, tva_comment, tva_poste
+INSERT INTO public.tool_uos (uos_value) VALUES (1);
+INSERT INTO public.tool_uos (uos_value) VALUES (2);
+INSERT INTO public.tool_uos (uos_value) VALUES (3);
+INSERT INTO public.tool_uos (uos_value) VALUES (4);
+INSERT INTO public.tool_uos (uos_value) VALUES (5);
+INSERT INTO public.tool_uos (uos_value) VALUES (6);
+INSERT INTO public.tool_uos (uos_value) VALUES (7);
+INSERT INTO public.tool_uos (uos_value) VALUES (8);
@@ -1844,12 +2170,6 @@ INSERT INTO public.user_active_security (id, us_login,
us_ledger, us_action) VAL
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (1, 1, 1, 'W');
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (2, 1, 2, 'W');
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (3, 1, -1, 'W');
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (4, 2, 1, 'W');
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (5, 2, 2, 'W');
-INSERT INTO public.user_sec_action_profile (ua_id, p_id, p_granted, ua_right)
VALUES (6, 2, -1, 'W');
@@ -1936,9 +2256,9 @@ INSERT INTO public.version (val, v_description, v_date)
VALUES (196, 'remove tri
INSERT INTO public.version (val, v_description, v_date) VALUES (197, 'Adapt
for VAT CODE', '2024-07-27 22:11:14.756736');
INSERT INTO public.version (val, v_description, v_date) VALUES (198, 'Cosmetic
and VAT', '2024-07-27 22:11:14.840218');
INSERT INTO public.version (val, v_description, v_date) VALUES (199, 'Detail
VAT', '2024-07-29 16:02:22.5503');
-INSERT INTO public.version (val, v_description, v_date) VALUES (200, 'Widget
and improve menu', '2024-09-07 14:26:51.584828');
-INSERT INTO public.version (val, v_description, v_date) VALUES (201, 'receipt
with padding ', '2024-09-07 14:26:51.623587');
-INSERT INTO public.version (val, v_description, v_date) VALUES (202, 'Bug with
reconcile, improve view', '2024-09-07 14:26:51.627547');
+INSERT INTO public.version (val, v_description, v_date) VALUES (200, 'Widget
and improve menu', '2024-08-19 21:10:51.079778');
+INSERT INTO public.version (val, v_description, v_date) VALUES (201, 'receipt
with padding ', '2024-09-08 18:35:39.877341');
+INSERT INTO public.version (val, v_description, v_date) VALUES (202, 'Bug with
reconcile, improve view', '2024-09-08 18:35:39.90537');
@@ -1950,15 +2270,15 @@ 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_detail_ad_id_seq', 2, true);
-SELECT pg_catalog.setval('public.action_gestion_ag_id_seq', 1, false);
+SELECT pg_catalog.setval('public.action_gestion_ag_id_seq', 3, true);
-SELECT pg_catalog.setval('public.action_gestion_comment_agc_id_seq', 1, false);
+SELECT pg_catalog.setval('public.action_gestion_comment_agc_id_seq', 3, true);
@@ -2034,19 +2354,19 @@ 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_d_id_seq', 10, true);
-SELECT pg_catalog.setval('public.document_modele_md_id_seq', 1, false);
+SELECT pg_catalog.setval('public.document_modele_md_id_seq', 8, true);
-SELECT pg_catalog.setval('public.document_option_do_id_seq', 70, true);
+SELECT pg_catalog.setval('public.document_option_do_id_seq', 224, true);
-SELECT pg_catalog.setval('public.document_seq', 1, false);
+SELECT pg_catalog.setval('public.document_seq', 8, true);
@@ -2098,7 +2418,7 @@ SELECT pg_catalog.setval('public.jrn_note_n_id_seq', 1,
false);
-SELECT pg_catalog.setval('public.jrn_periode_id_seq', 52, true);
+SELECT pg_catalog.setval('public.jrn_periode_id_seq', 172, true);
@@ -2150,7 +2470,7 @@ 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_currency_id_seq', 44, true);
@@ -2178,7 +2498,7 @@ SELECT
pg_catalog.setval('public.poste_analytique_po_id_seq', 1, false);
-SELECT pg_catalog.setval('public.profile_menu_pm_id_seq', 893, true);
+SELECT pg_catalog.setval('public.profile_menu_pm_id_seq', 894, true);
@@ -2194,7 +2514,7 @@ SELECT
pg_catalog.setval('public.profile_sec_repository_ur_id_seq', 2, true);
-SELECT pg_catalog.setval('public.profile_user_pu_id_seq', 6, true);
+SELECT pg_catalog.setval('public.profile_user_pu_id_seq', 7, true);
@@ -2202,7 +2522,7 @@ 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_attr_def', 9001, true);
@@ -2226,15 +2546,15 @@ SELECT pg_catalog.setval('public.s_currency', 1, true);
-SELECT pg_catalog.setval('public.s_fdef', 6, true);
+SELECT pg_catalog.setval('public.s_fdef', 13, true);
-SELECT pg_catalog.setval('public.s_fiche', 20, true);
+SELECT pg_catalog.setval('public.s_fiche', 26, true);
-SELECT pg_catalog.setval('public.s_fiche_def_ref', 16, true);
+SELECT pg_catalog.setval('public.s_fiche_def_ref', 27, true);
@@ -2246,7 +2566,7 @@ SELECT pg_catalog.setval('public.s_formdef', 1, false);
-SELECT pg_catalog.setval('public.s_grpt', 2, true);
+SELECT pg_catalog.setval('public.s_grpt', 24, true);
@@ -2266,11 +2586,11 @@ SELECT pg_catalog.setval('public.s_isup', 1, false);
-SELECT pg_catalog.setval('public.s_jnt_fic_att_value', 371, true);
+SELECT pg_catalog.setval('public.s_jnt_fic_att_value', 442, true);
-SELECT pg_catalog.setval('public.s_jnt_id', 67, true);
+SELECT pg_catalog.setval('public.s_jnt_id', 187, true);
@@ -2294,7 +2614,11 @@ SELECT pg_catalog.setval('public.s_jrn_4', 1, false);
-SELECT pg_catalog.setval('public.s_jrn_def', 5, false);
+SELECT pg_catalog.setval('public.s_jrn_5', 1, false);
+
+
+
+SELECT pg_catalog.setval('public.s_jrn_def', 5, true);
@@ -2318,6 +2642,10 @@ 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', 1, false);
@@ -2330,15 +2658,15 @@ SELECT pg_catalog.setval('public.s_jrnx', 1, false);
-SELECT pg_catalog.setval('public.s_oa_group', 1, true);
+SELECT pg_catalog.setval('public.s_oa_group', 23, true);
-SELECT pg_catalog.setval('public.s_periode', 91, true);
+SELECT pg_catalog.setval('public.s_periode', 103, true);
-SELECT pg_catalog.setval('public.s_quantity', 7, true);
+SELECT pg_catalog.setval('public.s_quantity', 29, true);
@@ -2346,15 +2674,15 @@ SELECT pg_catalog.setval('public.s_stock_goods', 1,
false);
-SELECT pg_catalog.setval('public.s_tva', 1001, true);
+SELECT pg_catalog.setval('public.s_tva', 1006, true);
-SELECT pg_catalog.setval('public.s_user_act', 1, false);
+SELECT pg_catalog.setval('public.s_user_act', 28, true);
-SELECT pg_catalog.setval('public.s_user_jrn', 1, false);
+SELECT pg_catalog.setval('public.s_user_jrn', 9, true);
@@ -2426,11 +2754,11 @@ 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.tags_t_id_seq', 1, true);
-SELECT pg_catalog.setval('public.tmp_pcmn_id_seq', 1036, true);
+SELECT pg_catalog.setval('public.tmp_pcmn_id_seq', 1056, true);
@@ -2438,7 +2766,7 @@ 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.tmp_stockgood_s_id_seq', 1, true);
@@ -2450,7 +2778,7 @@ 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.uos_pk_seq', 8, true);
@@ -2474,3 +2802,68 @@ SELECT
pg_catalog.setval('public.widget_dashboard_wd_id_seq', 1, false);
+BEGIN;
+
+SELECT pg_catalog.lo_open('2346174', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b0304140000080000533c35595ec6320c2700000027000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e74657874504b0304140000080000533c35590000000000000000000000001a000000436f6e66696775726174696f6e73322f7374617475736261722f504b0304140008080800533c355900000000000000000000000027000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c0300504b0708000000000200000000000000504b0304140000080000
[...]
+SELECT pg_catalog.lowrite(0,
'\x2ef1dcac589433acc0826284029ce82e09a8406a50a7c0a148a090d00c46d573c7abb1cbe2abc7928c95a6d7c7289089834f73a393b13662df4b7c51b9bf1ed6f7f497b95a99480f04b899a116b06f7c151775b6b2cdbb52644cdbdc3366757544cae200feb05bd79ea21268783ba4ca04edb7a57b0bd910de90be46b07aea99d2904cfcabeb9cceb8d51ba25dfb323445ded89a92c20ac83c48d2ab1d29aa9c89933eebb3532816b162890d963195090afa1ac070382411e3b2f9a5b97c5d2c2ad80dc6559b2a1302d0acbf504aa2ea2081097d3636541d664b7cf4d05c42edee50ecc3e355
[...]
+SELECT pg_catalog.lowrite(0,
'\xfd88c346779e7a592c3bcad3ac288ea53f4f9d2d96e141f83142c705e9ade649325926f335accad7cef639f1103d787ac96219c8e756373be3b1e325fd084feddd6e6bc005de17ced1373c2de669359f13398cfd0580f77d177f3cccd37d64ffcce50ab29f43da18312de0211e35ae739983f1bc850797373eee60dd8405ff469ce8a7797a9ea76b3cda6d269eea68d3383ec644fe7c89cfe5218ff61f16783c787b3e64b30a08289aa41713f0f558cbe7620a7f6d6bb21844f8324ff5223d0e1ec3b5fcd1c76695de4e256fde17b410bc44ba912ac9858bcc3cd5d4a6213cede1637cc49f1f
[...]
+SELECT pg_catalog.lowrite(0,
'\x51cb965fd10b2fdcc684dc8a1a36fc924e9ffecfd57105468daa4da54b5f4bf5ea4da1bffe4ad3282b0d962eddcf84f7059f87bbf99c35a44e9dbef6f3861316c9b7e2ef65813324e74f5b3a055a3ec2aee314561dd042012a8fbcfffe4ff2934f56712cedc19ed6a1c3adbcdd46dbf5dab72f432fbe589d9e7a6ab1f2209b010ff3c68d4795e9edb737329936a40a15f2d233cf2cb12455b7a4973973120d1c783bdd73cf3494e372bc1dd4cee1c357d115575cc6e3ba9bdab59be39a7c1e7ef816aa562d3f356af4259d3debdc2470e6cc0545c29c36ad39f5ec59952554e792b58f784212
[...]
+SELECT pg_catalog.lowrite(0,
'\xaf48caad861b0fb5f230fdfd776dc5cbfbcd37fb94a056d4d433030a1b0c19b292860ebd23603eda0ae26d0b478095c487875220123618f5e148fb3099115fb56aa93e21a8b65e57a0b643305eb1223c9c573bc9082603d1963257aeaca6eb988c86ac4c255ec3895467b60dc667467cfaead591aaec6d35a6c71f2f4f8306d50868fa336bd6aff2d34f2f91d3defff27edeaa3e5a44446d902e11f7a487b2339234ba09d1391697a51b794ed03b09a9696ddbce962b54b84e7ef6d9ca52c386c524fdc385b726aad16202792128f9a79f8ef0744cf142a1a18da8ba8bbe0328bd84e6cc7a74
[...]
+SELECT pg_catalog.lowrite(0,
'\x00140000080000533c35590000000000000000000000001c00000000000000000000000000dc000000436f6e66696775726174696f6e73322f70726f67726573736261722f504b01021400140000080000533c3559000000000000000000000000180000000000000000000000000016010000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000533c35590000000000000000000000001a000000000000000000000000004c010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b01021400140000080000533c3559000000
[...]
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346176', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b0304140000080000f63b35595ec6320c2700000027000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e74657874504b0304140000080000f63b35590000000000000000000000001c000000436f6e66696775726174696f6e73322f616363656c657261746f722f504b0304140000080000f63b35590000000000000000000000001f000000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0304140000080000f63b35590000000000000000000000001c000000436f6e66
[...]
+SELECT pg_catalog.lowrite(0,
'\xa811350a51236a14a246d4881a85a811350a51236a448d42d4881a85a81135a246216a448d42d4881a51a31035a246216a448da851881a51a31035a246d4880051236a14a246d428448da811350a51236a14a246d4881a85a811350a51236a448d42d4881a85a81135a246216a448d42d4881a51a31035a246216a448d42d4881a51a31035a246216a448da851881a51a31035a246d428448da851881a51236a14a246d428448da811350a51236a14a246d428448da811350a51236ad41dfaffd02cc970dca746f20000000049454e44ae426082504b0304140008080800f63b355900000000
[...]
+SELECT pg_catalog.lowrite(0,
'\xf9c8c4090971c4c509070f96f2c30f5bd4f3cfffacd6addbe7e5ab96fa50fe5fe02a2f2f38060b949ee31e5031d1d9cc57a50730664c0ff9e8a39581aaef1076346deabda5b7654b814bd2bc8d779495555256664a9987f24db6686e25203d451eaea3d4a8bdbe8ce0d70ebbc8837d81bafe8c1149f8babc052d3be1bcf38e09bc8c4a1213e3c8cbcbf4fafcbfffb653f66c4c510fca7cced2f0d3ada8c6830a58b1bf70a3654bff5eead8b167c584d23beeb82c534e055be9d998241eb85224df5c2885139f959ec8f8f640cc94d0c8c848a27e7dff7c355dba34a6478fa6164914be987562
[...]
+SELECT pg_catalog.lowrite(0,
'\x9cb5b4e4e6cd5c89fe91ee0d61642b74272c2c902b570acf1652b2a41f73e67463c0809a66db172d3ac1e4c99bb97a35d367a9998e1ebdcaa851cbe9dfbf26efbdd7c9386569d0a02c6bd70ee3b1c756b379b3797286a0203f0e1f4ea679f372180a9c0b2158ba7430376e641b178f743a495a5a165959795cb992c9d9b3692426a6111f9fcac183c99c3c79dde1f77625b453a311bcf34e47c68f6f6cdc969bab63ce9c7dcc9ab5d3ab059f1c919999cb871fee66f1e213cc9e7dbf319558747418ab570fe3d14757b16edd19277bc1d8c7324bd0c993d77dea64af9e4115e0bebd044cf0c4
[...]
+SELECT pg_catalog.lowrite(0,
'\x09448dfd5a3e27e92d8627bdb0af2f86571d976234f82ff92400bf17b96e936bfe4770cdde87d7d80bf262bbbc75ef1c54c5d579901a336700b8266676912d3635b5941dcf2f07f0d9449d59f02ff50dc1655dcf3b0581942c6617ebf5b581feb6fd0be012af86d0b93313c005419d69284c6e3a91486f03bc24f076119341445303c2b20ff67daa4612d1ec04fb036ef27c46df5cd29e4dfb7347a4ce520037850bc389e8627803f643419d70331d4569184a9d183d456fadac7ca6243d251325d512496f986ddaebeadd8ca9e2dbe1a4f96970e3d392a5c23e939c77be0d6e37c79711d1cf
[...]
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346177', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b0304140000080000063c35595ec6320c2700000027000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e74657874504b0304140000080000063c355900000000000000000000000018000000436f6e66696775726174696f6e73322f746f6f6c6261722f504b0304140000080000063c35590000000000000000000000001f000000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0304140000080000063c35590000000000000000000000001a000000436f6e6669677572
[...]
+SELECT pg_catalog.lowrite(0,
'\x2cfe17832711ff77b784954f8fd68b29e75a9ccd91f0f208c8f8c34bca1378adb569df7e655b6198c8f5beb61fa28f7926eabca305870fed3f5d3f18df8996fdc7ebf1fb161c6ea98f40eeebe29e16b4c2bbdbbc7b5bd1b7786e05bc4acbe0446c7667b04da17d9999441f032d988ec5bffad8cceea23d3b7d5859aecc41ab9cf6241fb5f7c053e0ddf651cbafb7850fe44a68ff0aeab68d6ff26cf26ca9ab1b6d18f5bc2ed44fec6ba9dbb1bf60b0e5b5d696ba2d9ebad3dbc24d9b870a10ea433ff928b73e0c3bf6d68d1e3c70f874c3fee896d34f859b9ada269a3c4330d194dbb6cdbb05
[...]
+SELECT pg_catalog.lowrite(0,
'\x356e5c5215647d440c90a2990015121c35aaae346edc1af98d37d6ca67cec46bfb0ba5184631fe5ccceaee20567727c67a44d14686243d7ecb3dce3f7d305ff874954696274f361a3dba9ef4d043e58292dd5f7f9da31327ced1a953ff466974890d4879d9b35f4e050be6a0cc99cd6da0d75d7715bdfc725da95bb7ca528f1e0be59933b7c5f1cda5a8bb23f959a84394ffc18c14d397a1484f922664213afe297f453ad9d5b11e8f97a857afb8f4e9a7f74978f0ccf0d34f8769ce9c9db47cf95ee53b48cf877bc0e953bc782eaa51a330ce393569528a72e408f47b5d7ffdd53463461bbe
[...]
+SELECT pg_catalog.lowrite(0,
'\x6f8679f35aa751a510963267ce6f267b09b4e58967d42eed4b5feac9eee6479ad6a041b707cc3b70e0344d98605a31c75398495a4eb7c3364f3c5121cd325478c14bc5ddfe02892f11555cb37bc109715b8513a17844fdfac5145b69ea4b54a6471f9d4f8b17ef4d93c2074950b424405d47b40aa851a320dd74d33501630331376a545cc2b46edd611a3c786572e2909ff4872c0f741446e1b207868478bd667c92af0b6558d10088e29147ca4a7dfa5435253bc4d2e1c69839731793dd7ec5a8ae07eabf55ad1a584d0b0536870d7326a1e8ab96004635570fb36a277aa09f85b1f8e8a041
[...]
+SELECT pg_catalog.lowrite(0,
'\x763b8b500f5e1f76bc17b475ac6cc666c0fe602bb693f4705d44a188dddaf1708f14d5e681a4aa09cf3b2fc338bee209452752ee679e8f732e4868bbb6cddfdab21749b555de462e253d4af5e603f042b782d30c8e145285240821c50d8291a78804e901f304e101d0cff947c0e52d6c6b709b1b492652c01b090fd1e3c2d3ca9ffb783c0348f5e80101760bcd3d2e1ed20f05e169db9ee3e5e86701e9ca78c1f56464e55d02dc7a6ef71bec3e46a9cc8af4304610891941053807b07ffe5d90a2f293394139d9a7188fb24fc36730d213b63fecd7487a46e9d1298434dfc360b7831714d710
[...]
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346178', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b0304140000080000063c35595ec6320c2700000027000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e74657874504b0304140000080000063c355900000000000000000000000018000000436f6e66696775726174696f6e73322f746f6f6c6261722f504b0304140000080000063c35590000000000000000000000001f000000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b0304140000080000063c35590000000000000000000000001a000000436f6e6669677572
[...]
+SELECT pg_catalog.lowrite(0,
'\x2cfe17832711ff77b784954f8fd68b29e75a9ccd91f0f208c8f8c34bca1378adb569df7e655b6198c8f5beb61fa28f7926eabca305870fed3f5d3f18df8996fdc7ebf1fb161c6ea98f40eeebe29e16b4c2bbdbbc7b5bd1b7786e05bc4acbe0446c7667b04da17d9999441f032d988ec5bffad8cceea23d3b7d5859aecc41ab9cf6241fb5f7c053e0ddf651cbafb7850fe44a68ff0aeab68d6ff26cf26ca9ab1b6d18f5bc2ed44fec6ba9dbb1bf60b0e5b5d696ba2d9ebad3dbc24d9b870a10ea433ff928b73e0c3bf6d68d1e3c70f874c3fee896d34f859b9ada269a3c4330d194dbb6cdbb05
[...]
+SELECT pg_catalog.lowrite(0,
'\x356e5c5215647d440c90a2990015121c35aaae346edc1af98d37d6ca67cec46bfb0ba5184631fe5ccceaee20567727c67a44d14686243d7ecb3dce3f7d305ff874954696274f361a3dba9ef4d043e58292dd5f7f9da31327ced1a953ff466974890d4879d9b35f4e050be6a0cc99cd6da0d75d7715bdfc725da95bb7ca528f1e0be59933b7c5f1cda5a8bb23f959a84394ffc18c14d397a1484f922664213afe297f453ad9d5b11e8f97a857afb8f4e9a7f74978f0ccf0d34f8769ce9c9db47cf95ee53b48cf877bc0e953bc782eaa51a330ce393569528a72e408f47b5d7ffdd53463461bbe
[...]
+SELECT pg_catalog.lowrite(0,
'\x6f8679f35aa751a510963267ce6f267b09b4e58967d42eed4b5feac9eee6479ad6a041b707cc3b70e0344d98605a31c75398495a4eb7c3364f3c5121cd325478c14bc5ddfe02892f11555cb37bc109715b8513a17844fdfac5145b69ea4b54a6471f9d4f8b17ef4d93c2074950b424405d47b40aa851a320dd74d33501630331376a545cc2b46edd611a3c786572e2909ff4872c0f741446e1b207868478bd667c92af0b6558d10088e29147ca4a7dfa5435253bc4d2e1c69839731793dd7ec5a8ae07eabf55ad1a584d0b0536870d7326a1e8ab96004635570fb36a277aa09f85b1f8e8a041
[...]
+SELECT pg_catalog.lowrite(0,
'\x763b8b500f5e1f76bc17b475ac6cc666c0fe602bb693f4705d44a188dddaf1708f14d5e681a4aa09cf3b2fc338bee209452752ee679e8f732e4868bbb6cddfdab21749b555de462e253d4af5e603f042b782d30c8e145285240821c50d8291a78804e901f304e101d0cff947c0e52d6c6b709b1b492652c01b090fd1e3c2d3ca9ffb783c0348f5e80101760bcd3d2e1ed20f05e169db9ee3e5e86701e9ca78c1f56464e55d02dc7a6ef71bec3e46a9cc8af4304610891941053807b07ffe5d90a2f293394139d9a7188fb24fc36730d213b63fecd7487a46e9d1298434dfc360b7831714d710
[...]
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346179', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b03041400000800004f3b3559856c398a2e0000002e000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e7370726561647368656574504b03041400000800004f3b35590000000000000000000000001f000000436f6e66696775726174696f6e73322f696d616765732f4269746d6170732f504b03041400080808004f3b355900000000000000000000000027000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c0300504b070800000000020000000000
[...]
+SELECT pg_catalog.lowrite(0,
'\x79f2b9547728ad5bb78f33cf7cc9b16f5f38efa72a400a816f20efd268747044a5d21399110f2b5e062e046a855a1eabe9d4a911df7d775d5c62e2d1266b3fffbc9df3cf7fc376508411d75c730aafbe3a80ea7badb367ffa52ebae8ed48f8d99500bf434a1fa5ee8baabb6854c5a70188e4a7c18a2f410d240a155e5a5a226fbf3dc845e1fdf5d75efaf69d6e2bbc3063dab4dfb8f3cecf5c9ebbe0823672ebad1d2321783205a40394fca4b546881ea24ae989e467817c0b740589ca263d63c69c25cd9b1fad85505454cec517bfc3eedd91920a155b3cfdf44f4c9dbacce5b9871f3e2742
[...]
+SELECT pg_catalog.lowrite(0,
'\x1a6f727226efbdb793a64dff476cec36b35c8fa1a1817cf14537316f5e4f1112521413a9cb75ae0a3cc897d0d32d0091ea8a53656150ae5c104b970ed24c9ad44aa8d5f3e4e44c9e7d761d5dbafcc21f7f9c745ad83932b2a4552eb3b8b8143efbccf382c6b1f0130821183dba81d9f63367d258b932cee36371057bb30183f6a1be917bf68cb69acecd9f7fd4e584a9ae8ea128cb3cc36f68897d8167ddde748dd83fce575f59fb68f6ee6d37cede25323373f9ecb3bdb46efd03f3e71f313bef0f3c504b2c5b364853b1629172d7bd0cdaf7dde9e0b6d09332365b09e8d5f85cead5ab5786
[...]
+SELECT pg_catalog.lowrite(0,
'\xa7e10dd03982d2fb9d2392c7598c212823bd8d70f6597b4e11f3b2e6085aebef80279061aab7c0a0e34161d5ddbef128ab4d5402fb76acb23c6b1d3f2f6ad02f7da61acc5f829258bd31f91c977102f8f15c3c961bd6a9c269e6f85b8932fa5c62b19143c148482f734dd5c154dcd42830cecc4f24aed9be9e608ead64506bad2533efe5cc1a5959aaa66128c975b7e285d3071f23c7a82a2af574c2aa672de6158da98c25ea6d8ea062a49753c5b5cded9936537d2d456a3cae37c7e178b47bb4dc8f34f4da0251d5ebc066a0295d0b5e12b632269f766ce90bb8ce586e52a70afabcf7231d
[...]
+SELECT pg_catalog.lowrite(0,
'\x56fc8e4f698ed9d2230dc6f606661b998c00a41c211ece4d38978b4cfe0653001d7f1e4702970ced80dbe0fbc9ba27c9f8a9d98b7ffb5ad30e3a6bbce098864637e4eb9db7f90ebd2cf7231a07df5690cb3760c127727877d0753f3af2191fd8681674167ac8be56b21fad8f025f26847d4d70a0bcc67d3427594163e905525643ce9593fd395036a11869267af78a3ba89cf97ab41d5be06f6bde9e487d7d05efe4e5e5fda1426b58d575a1729ef1e55fa661313de28910a84f73727373738219dd1ef1e09a2cf55809b7e48fe6ebbb46850d70d0b181a0797cb2d715506e42545e245d2b11
[...]
+SELECT pg_catalog.lowrite(0,
'\x000000e7db00005468756d626e61696c732f7468756d626e61696c2e706e67504b010214001400080808004f3b35591c43e951690100001b0500001500000000000000000000000000e33901004d4554412d494e462f6d616e69666573742e786d6c504b05060000000012001200d30400008f3b01000000');
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346181', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b030414000008000019483559856c398a2e0000002e000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e7370726561647368656574504b0304140000080000194835590000000000000000000000001a000000436f6e66696775726174696f6e73322f7374617475736261722f504b03041400080808001948355900000000000000000000000027000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c0300504b0708000000000200000000000000504b03
[...]
+SELECT pg_catalog.lowrite(0,
'\x28e6cfdfa8a64dfb9df7defb53151787bbc354ca416d012e566aec1fa1962614c4acd21379a003c4cf00690c2aaad6779d3a3562cc98b3a45fbf569a216b131476ee3cc4e38fffa89e7efa27555414eeed2fd42e881fabd49817432d49b08949a527927f0bc83850519546969b9bcee4c9e7cab5d79ee251d9eddd5bccfefdc51c3c581a24e9229ba4a47832339338eeb82c12138def917fff7d9061c33e571f7eb832cc7f5cb21fd45790f7cf588ae98b29a527f25432ec9b0e9c0364875a1e2b39f7dc16327dfa40a95fdf7da1975f7fddc1279ffcc582051bf9f5d71decdd5b1c6409a383
[...]
+SELECT pg_catalog.lowrite(0,
'\x04515161346c5896b66d2b53b76e84ddeb74f7ee8bbcf1c636dded23fcc43e29a7b570a5a59b3530c42c10034096cfcfb00a033f3f0d63c73612afbedacaa6b0cbcece63edda04162f3ec9c68d89563e50a34737b012787bf75ee2adb75cd3504ca15f8692896099f5c48049fbb32dfcfaf7af8965f2d1d8d8ad8522f0c0b6a6e5b8bdf2b74b97ea5602efecd974bef9e6603ec660ad45df4eda9e2d971be751508e2366ce9d4be7cb2ff7f3fcf3e6f1f4fdfad564c9126b6f82acac3cce9fbfc1f9f3378c35830122224ad0bd7b348306d5a263c7aa66b1d02d5b5660f9f2419a3ffe382563
[...]
+SELECT pg_catalog.lowrite(0,
'\xc1cf82c09285b182a036a558316857058ba55571a92456fa92e5b2d287eda24b2b3eb0555cadd28755dad588a1a8951441a8692df2500a1895c792b29218928f2424863c0a4920bb7fccde77f69d3b3367ce39f726df57cf6fad6fdd73cf99993bdf3933bfb35fb387b927a9b19320cf03b09a99edfdb575ae62e65da6ce5600cb00dc28c775f04af97c06c0652c7924e5b7af32e55e55b3dd628c2a4eefaf23e7569ae31347f4bb29ac626754b75809bf4cea0c22b2f76211bc73e52b6163f2a0de8dc115127799e33b32fd699b5da5cae9a044727ff0dd22e61cc81154d8e6c25015159550
[...]
+SELECT pg_catalog.lowrite(0,
'\x705be8ef1e1533b38ad2c6f5fd9f5863a37480a13f403cc6f0e4754adf8b74bc20cb59da7fdf2a807c6932748d88a3b5aa6b94be9c326e091c9937269fce180c5d822dcfd93a2a6a5635a8ac754fc5af752a18b78a7e6ae446e44b1afb0c1122cefaec4b9b474be22b35803e9da8192a93df3e1fd1e82574e973d02cd00a2f82fe7ff98d6d8369e3936523f3e932f2445c5c4c3f3668d4a491bfe1df53231f51c4bf55f497461a702b737e64bf8f1d02faa7a3409a1b3548f07c470eca6af7ff801e0b77a1e6796188d198dac34167bcc4475c3ff1347dfe5f41ef9b4d2693b061f4b7135986
[...]
+SELECT pg_catalog.lowrite(0,
'\x0000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000019010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000051010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000087010000436f6e66696775726174696f6e73322f
[...]
+SELECT pg_catalog.lo_close(0);
+
+SELECT pg_catalog.lo_open('2346476', 131072);
+SELECT pg_catalog.lowrite(0,
'\x504b030414000008000019483559856c398a2e0000002e000000080000006d696d65747970656170706c69636174696f6e2f766e642e6f617369732e6f70656e646f63756d656e742e7370726561647368656574504b0304140000080000194835590000000000000000000000001a000000436f6e66696775726174696f6e73322f7374617475736261722f504b03041400080808001948355900000000000000000000000027000000436f6e66696775726174696f6e73322f616363656c657261746f722f63757272656e742e786d6c0300504b0708000000000200000000000000504b03
[...]
+SELECT pg_catalog.lowrite(0,
'\x28e6cfdfa8a64dfb9df7defb53151787bbc354ca416d012e566aec1fa1962614c4acd21379a003c4cf00690c2aaad6779d3a3562cc98b3a45fbf569a216b131476ee3cc4e38fffa89e7efa27555414eeed2fd42e881fabd49817432d49b08949a527927f0bc83850519546969b9bcee4c9e7cab5d79ee251d9eddd5bccfefdc51c3c581a24e9229ba4a47832339338eeb82c12138def917fff7d9061c33e571f7eb832cc7f5cb21fd45790f7cf588ae98b29a527f25432ec9b0e9c0364875a1e2b39f7dc16327dfa40a95fdf7da1975f7fddc1279ffcc582051bf9f5d71decdd5b1c6409a383
[...]
+SELECT pg_catalog.lowrite(0,
'\x04515161346c5896b66d2b53b76e84ddeb74f7ee8bbcf1c636dded23fcc43e29a7b570a5a59b3530c42c10034096cfcfb00a033f3f0d63c73612afbedacaa6b0cbcece63edda04162f3ec9c68d89563e50a34737b012787bf75ee2adb75cd3504ca15f8692896099f5c48049fbb32dfcfaf7af8965f2d1d8d8ad8522f0c0b6a6e5b8bdf2b74b97ea5602efecd974bef9e6603ec660ad45df4eda9e2d971be751508e2366ce9d4be7cb2ff7f3fcf3e6f1f4fdfad564c9126b6f82acac3cce9fbfc1f9f3378c35830122224ad0bd7b348306d5a263c7aa66b1d02d5b5660f9f2419a3ffe382563
[...]
+SELECT pg_catalog.lowrite(0,
'\xc1cf82c09285b182a036a558316857058ba55571a92456fa92e5b2d287eda24b2b3eb0555cadd28755dad588a1a8951441a8692df2500a1895c792b29218928f2424863c0a4920bb7fccde77f69d3b3367ce39f726df57cf6fad6fdd73cf99993bdf3933bfb35fb387b927a9b19320cf03b09a99edfdb575ae62e65da6ce5600cb00dc28c775f04af97c06c0652c7924e5b7af32e55e55b3dd628c2a4eefaf23e7569ae31347f4bb29ac626754b75809bf4cea0c22b2f76211bc73e52b6163f2a0de8dc115127799e33b32fd699b5da5cae9a044727ff0dd22e61cc81154d8e6c25015159550
[...]
+SELECT pg_catalog.lowrite(0,
'\x705be8ef1e1533b38ad2c6f5fd9f5863a37480a13f403cc6f0e4754adf8b74bc20cb59da7fdf2a807c6932748d88a3b5aa6b94be9c326e091c9937269fce180c5d822dcfd93a2a6a5635a8ac754fc5af752a18b78a7e6ae446e44b1afb0c1122cefaec4b9b474be22b35803e9da8192a93df3e1fd1e82574e973d02cd00a2f82fe7ff98d6d8369e3936523f3e932f2445c5c4c3f3668d4a491bfe1df53231f51c4bf55f497461a702b737e64bf8f1d02faa7a3409a1b3548f07c470eca6af7ff801e0b77a1e6796188d198dac34167bcc4475c3ff1347dfe5f41ef9b4d2693b061f4b7135986
[...]
+SELECT pg_catalog.lowrite(0,
'\x0000436f6e66696775726174696f6e73322f666c6f617465722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000019010000436f6e66696775726174696f6e73322f706f7075706d656e752f504b0102140014000008000019483559000000000000000000000000180000000000000000000000000051010000436f6e66696775726174696f6e73322f6d656e756261722f504b01021400140000080000194835590000000000000000000000001a0000000000000000000000000087010000436f6e66696775726174696f6e73322f
[...]
+SELECT pg_catalog.lo_close(0);
+
+COMMIT;
+
+
diff --git a/include/sql/mod1/schema.sql b/include/sql/mod1/schema.sql
index 54019d901..b47e34817 100644
--- a/include/sql/mod1/schema.sql
+++ b/include/sql/mod1/schema.sql
@@ -5564,6 +5564,15 @@ CREATE SEQUENCE public.s_jrn_4
+CREATE SEQUENCE public.s_jrn_5
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+
CREATE SEQUENCE public.s_jrn_def
START WITH 5
INCREMENT BY 1
@@ -5618,6 +5627,15 @@ CREATE SEQUENCE public.s_jrn_pj4
+CREATE SEQUENCE public.s_jrn_pj5
+ START WITH 1
+ INCREMENT BY 1
+ NO MINVALUE
+ NO MAXVALUE
+ CACHE 1;
+
+
+
CREATE SEQUENCE public.s_jrn_rapt
START WITH 1
INCREMENT BY 1
@@ -6494,8 +6512,8 @@ CREATE VIEW public.v_contact AS
JOIN public.fiche_def fd ON ((f.fd_id = fd.fd_id)))
WHERE (fd.frd_id = 16)
)
- SELECT f_id,
- f_enable,
+ SELECT cd.f_id,
+ cd.f_enable,
( SELECT fiche_detail.ad_value
FROM public.fiche_detail
WHERE ((fiche_detail.ad_id = 32) AND (fiche_detail.f_id = cd.f_id)))
AS contact_fname,
@@ -6520,7 +6538,7 @@ CREATE VIEW public.v_contact AS
( SELECT fiche_detail.ad_value
FROM public.fiche_detail
WHERE ((fiche_detail.ad_id = 26) AND (fiche_detail.f_id = cd.f_id)))
AS contact_fax,
- fd_id AS card_category
+ cd.fd_id AS card_category
FROM contact_data cd;
@@ -6620,10 +6638,10 @@ COMMENT ON VIEW public.vw_fiche_attr IS 'Some attribute
for all cards';
CREATE VIEW public.vw_fiche_name AS
- SELECT f_id,
- ad_value AS name
+ SELECT fiche_detail.f_id,
+ fiche_detail.ad_value AS name
FROM public.fiche_detail
- WHERE (ad_id = 1);
+ WHERE (fiche_detail.ad_id = 1);
@@ -7014,16 +7032,16 @@ CREATE VIEW public.v_quant_detail AS
CREATE VIEW public.v_tva_rate AS
- SELECT tva_id,
- tva_rate,
- tva_code,
- tva_label,
- tva_comment,
- split_part(tva_poste, ','::text, 1) AS tva_purchase,
- split_part(tva_poste, ','::text, 2) AS tva_sale,
- tva_both_side,
- tva_payment_purchase,
- tva_payment_sale
+ SELECT tva_rate.tva_id,
+ tva_rate.tva_rate,
+ tva_rate.tva_code,
+ tva_rate.tva_label,
+ tva_rate.tva_comment,
+ split_part(tva_rate.tva_poste, ','::text, 1) AS tva_purchase,
+ split_part(tva_rate.tva_poste, ','::text, 2) AS tva_sale,
+ tva_rate.tva_both_side,
+ tva_rate.tva_payment_purchase,
+ tva_rate.tva_payment_sale
FROM public.tva_rate;
- [Noalyss-commit] [noalyss] 05/19: Bug : warning for ledger C0JRN when no category card is checked, (continued)
- [Noalyss-commit] [noalyss] 05/19: Bug : warning for ledger C0JRN when no category card is checked, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 09/19: Cosmetic menu, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 12/19: VAT warning : update the VAT CODE, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 17/19: Cosmetic : remove border, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 14/19: MOD1: setting base TVA, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 01/19: Code change + typo, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 08/19: MOD2 : update, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 18/19: nav-level2.active and nav-level3 active: border color, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 19/19: REVERT 9bc780c62 SALE : by default invoice not checked, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 04/19: Cosmetic, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 06/19: Update MOD1, Belgian template add VAT, document, ...,
dwm <=
- [Noalyss-commit] [noalyss] 16/19: Synchro with stable DO NOT INTEGRATE to pre-stable nor stable, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 02/19: Fix : France saldo until end of exercice in Gestion, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 10/19: SALE : by default invoice not checked, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 13/19: INSTALL: template must always use its own db structure, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 11/19: TVA show up , sorted by ID, dwm, 2024/09/25
- [Noalyss-commit] [noalyss] 15/19: MOD2 : remove schema, dwm, 2024/09/25