From MAILER-DAEMON Sun Nov 11 14:58:48 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1TXdg8-0001V3-T8
	for mharc-phpcompta-dev@gnu.org; Sun, 11 Nov 2012 14:58:48 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Sun, 11 Nov 2012 20:47:21 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.766922.1352663928.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r5152 - in phpcompta/tags/rel650/include: . template
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Sun, 11 Nov 2012 19:58:47 -0000

Author: danydb
Date: 2012-11-11 20:47:20 +0100 (Sun, 11 Nov 2012)
New Revision: 5152

Modified:
   phpcompta/tags/rel650/include/class_acc_ledger_purchase.php
   phpcompta/tags/rel650/include/class_acc_ledger_sold.php
   phpcompta/tags/rel650/include/template/ledger_detail_ach.php
   phpcompta/tags/rel650/include/template/ledger_detail_ven.php
Log:
0000756: Achat ou vente pour rembourser de la TVA, marchandise ou quant. =
=3D 0

Modified: phpcompta/tags/rel650/include/class_acc_ledger_purchase.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/class_acc_ledger_purchase.php	2012-10-3=
0 21:25:19 UTC (rev 5151)
+++ phpcompta/tags/rel650/include/class_acc_ledger_purchase.php	2012-11-1=
1 19:47:20 UTC (rev 5152)
@@ -342,14 +342,15 @@
             $tot_perso=3D0;
             $tot_tva_nd=3D0;
             $tot_tva_ndded=3D0;
+			$tva=3Darray();
             /* Save all the items without vat and no deductible vat and =
expense*/
             for ($i=3D0;$i< $nb_item;$i++)
             {
 				$n_both=3D0;
                 if ( strlen(trim(${'e_march'.$i})) =3D=3D 0 ) continue;
-                if ( ${'e_march'.$i.'_price'} =3D=3D 0 ) continue;
+           /*     if ( ${'e_march'.$i.'_price'} =3D=3D 0 ) continue;
                 if ( ${'e_quant'.$i} =3D=3D 0 ) continue;
-
+*/
                 /* First we save all the items without vat */
                 $fiche=3Dnew Fiche($this->db);
                 $fiche->get_by_qcode(${"e_march".$i});

Modified: phpcompta/tags/rel650/include/class_acc_ledger_sold.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/class_acc_ledger_sold.php	2012-10-30 21=
:25:19 UTC (rev 5151)
+++ phpcompta/tags/rel650/include/class_acc_ledger_sold.php	2012-11-11 19=
:47:20 UTC (rev 5152)
@@ -275,13 +275,12 @@
             $tot_tva=3D0;
             $tot_debit=3D0;
             $this->db->start();
+			$tva=3Darray();
             /* Save all the items without vat */
             for ($i=3D0;$i< $nb_item;$i++)
             {
 				$n_both=3D0;
                 if ( strlen(trim(${'e_march'.$i})) =3D=3D 0 ) continue;
-                if ( ${'e_march'.$i.'_price'} =3D=3D 0 ) continue;
-                if ( ${'e_quant'.$i} =3D=3D 0 ) continue;
=20
                 /* First we save all the items without vat */
                 $fiche=3Dnew Fiche($this->db);

Modified: phpcompta/tags/rel650/include/template/ledger_detail_ach.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/template/ledger_detail_ach.php	2012-10-=
30 21:25:19 UTC (rev 5151)
+++ phpcompta/tags/rel650/include/template/ledger_detail_ach.php	2012-11-=
11 19:47:20 UTC (rev 5152)
@@ -161,7 +161,8 @@
     }
     $row.=3Dtd($input->input().$hidden);
     $row.=3Dtd($sym_tva,'style=3D"text-align:center"');
-	$pu=3Dbcdiv($q['qp_price'],$q['qp_quantite']);
+	$pu=3D0;
+	if ( $q['qp_quantite'] !=3D 0 ) $pu=3Dbcdiv($q['qp_price'],$q['qp_quant=
ite']);
     $row.=3Dtd(nbm($pu),'class=3D"num"');
     $row.=3Dtd(nbm($q['qp_quantite']),'class=3D"num"');
=20

Modified: phpcompta/tags/rel650/include/template/ledger_detail_ven.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/template/ledger_detail_ven.php	2012-10-=
30 21:25:19 UTC (rev 5151)
+++ phpcompta/tags/rel650/include/template/ledger_detail_ven.php	2012-11-=
11 19:47:20 UTC (rev 5152)
@@ -154,7 +154,8 @@
=20
     $row.=3Dtd($input->input().$hidden);
     $sym_tva=3D'';
-	$pu=3Dbcdiv($q['qs_price'],$q['qs_quantite']);
+	$pu=3D0;
+	if ($q['qs_quantite'] !=3D 0)	$pu=3Dbcdiv($q['qs_price'],$q['qs_quantit=
e']);
     $row.=3Dtd(nbm($pu),'class=3D"num"');
     $row.=3Dtd(nbm($q['qs_quantite']),'class=3D"num"');
 	$sym_tva=3D'';



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


From MAILER-DAEMON Sun Nov 11 15:03:06 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1TXdkI-0002BE-I9
	for mharc-phpcompta-dev@gnu.org; Sun, 11 Nov 2012 15:03:06 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Sun, 11 Nov 2012 20:51:40 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.766937.1352664185.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r5153 - in phpcompta/tags/rel650/include: . template
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Sun, 11 Nov 2012 20:03:05 -0000

Author: danydb
Date: 2012-11-11 20:51:40 +0100 (Sun, 11 Nov 2012)
New Revision: 5153

Modified:
   phpcompta/tags/rel650/include/fiche.inc.php
   phpcompta/tags/rel650/include/template/fiche_list.php
Log:
0000750: place de nouvelle fiche et effacer

Modified: phpcompta/tags/rel650/include/fiche.inc.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/fiche.inc.php	2012-11-11 19:47:20 UTC (=
rev 5152)
+++ phpcompta/tags/rel650/include/fiche.inc.php	2012-11-11 19:51:40 UTC (=
rev 5153)
@@ -201,8 +201,8 @@
 		$cond   order by 2 offset $offset $limit
 	");
 	$nb_line =3D Database::num_row($res);
+	if ($write !=3D 1 || $allcard !=3D 0 )  $str_add_card=3D"";
 	require_once 'template/fiche_list.php';
-	if ($write =3D=3D 1 && $allcard =3D=3D 0 ) echo $str_add_card;
 	echo '<hr>'.$bar;
 	exit();
 }

Modified: phpcompta/tags/rel650/include/template/fiche_list.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/template/fiche_list.php	2012-11-11 19:4=
7:20 UTC (rev 5152)
+++ phpcompta/tags/rel650/include/template/fiche_list.php	2012-11-11 19:5=
1:40 UTC (rev 5153)
@@ -76,6 +76,7 @@
=20
=20
 	</table>
+	<?=3D$str_add_card?>
 <?=3DHtmlInput::hidden('action',"1");?>
 <?=3DHtmlInput::submit('delete','Effacer la s=C3=A9lection ')?>
 <? if ( $allcard =3D=3D  0  ): ?>



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


From MAILER-DAEMON Sun Nov 11 15:06:33 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1TXdnd-0002XJ-TG
	for mharc-phpcompta-dev@gnu.org; Sun, 11 Nov 2012 15:06:33 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Sun, 11 Nov 2012 20:55:08 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.766956.1352664393.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r5154 - phpcompta/tags/rel650/include
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Sun, 11 Nov 2012 20:06:33 -0000

Author: danydb
Date: 2012-11-11 20:55:08 +0100 (Sun, 11 Nov 2012)
New Revision: 5154

Modified:
   phpcompta/tags/rel650/include/param_pcmn.inc.php
Log:
0000742: remplacer le mot 'classe ' par le mot ' poste (comptable)'

Modified: phpcompta/tags/rel650/include/param_pcmn.inc.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/param_pcmn.inc.php	2012-11-11 19:51:40 =
UTC (rev 5153)
+++ phpcompta/tags/rel650/include/param_pcmn.inc.php	2012-11-11 19:55:08 =
UTC (rev 5154)
@@ -251,9 +251,9 @@
 ?>
 <TABLE class=3D"result">
                              <TR>
-                             <TH> Classe </TH>
+                             <TH> Poste comptable </TH>
                              <TH> Libell=C3=A9 </TH>
-                             <TH> Parent </TH>
+                             <TH> Poste comptable Parent </TH>
                              <TH> Type </TH>
                              </TR>
                              <?php



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


From MAILER-DAEMON Thu Nov 22 16:01:42 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1Tbdu2-0003xe-TE
	for mharc-phpcompta-dev@gnu.org; Thu, 22 Nov 2012 16:01:42 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Thu, 22 Nov 2012 21:50:28 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.876312.1353618101.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r5155 - phpcompta/tags/rel650/html/admin/sql/mod2
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Thu, 22 Nov 2012 21:01:41 -0000

Author: danydb
Date: 2012-11-22 21:50:27 +0100 (Thu, 22 Nov 2012)
New Revision: 5155

Added:
   phpcompta/tags/rel650/html/admin/sql/mod2/data.sql
Removed:
   phpcompta/tags/rel650/html/admin/sql/mod2/data.sql
Log:
fix problem with french accounting

Deleted: phpcompta/tags/rel650/html/admin/sql/mod2/data.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/html/admin/sql/mod2/data.sql	2012-11-11 19:55:0=
8 UTC (rev 5154)
+++ phpcompta/tags/rel650/html/admin/sql/mod2/data.sql	2012-11-22 20:50:2=
7 UTC (rev 5155)
@@ -1,1126 +0,0 @@
-
-SET client_encoding =3D 'UTF8';
-SET standard_conforming_strings =3D off;
-SET check_function_bodies =3D false;
-SET client_min_messages =3D warning;
-SET escape_string_warning =3D off;
-
-SET search_path =3D public, pg_catalog;
-
-
-SELECT pg_catalog.setval('action_detail_ad_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('action_gestion_ag_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('bilan_b_id_seq', 4, true);
-
-
-
-SELECT pg_catalog.setval('bud_card_bc_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('bud_detail_bd_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('bud_detail_periode_bdp_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('del_action_del_id_seq', 1, true);
-
-
-
-SELECT pg_catalog.setval('document_d_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('document_modele_md_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('document_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('document_state_s_id_seq', 3, true);
-
-
-
-SELECT pg_catalog.setval('document_type_dt_id_seq', 25, false);
-
-
-
-SELECT pg_catalog.setval('extension_ex_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('forecast_cat_fc_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('forecast_f_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('forecast_item_fi_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('historique_analytique_ha_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jnt_id', 53, true);
-
-
-
-SELECT pg_catalog.setval('jnt_letter_jl_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('jrn_info_ji_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('letter_cred_lc_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('letter_deb_ld_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('mod_payment_mp_id_seq', 10, true);
-
-
-
-SELECT pg_catalog.setval('op_def_op_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('op_predef_detail_opd_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_oa_group', 7, true);
-
-
-
-SELECT pg_catalog.setval('plan_analytique_pa_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('poste_analytique_po_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_attr_def', 27, true);
-
-
-
-SELECT pg_catalog.setval('s_cbc', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_central', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_central_order', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_centralized', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_currency', 1, true);
-
-
-
-SELECT pg_catalog.setval('s_fdef', 6, true);
-
-
-
-SELECT pg_catalog.setval('s_fiche', 79, true);
-
-
-
-SELECT pg_catalog.setval('s_fiche_def_ref', 18, true);
-
-
-
-SELECT pg_catalog.setval('s_form', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_formdef', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_grpt', 102, true);
-
-
-
-SELECT pg_catalog.setval('s_idef', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_internal', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_invoice', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_isup', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jnt_fic_att_value', 875, true);
-
-
-
-SELECT pg_catalog.setval('s_jrn', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_1', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_2', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_3', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_4', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_def', 5, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_op', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_pj1', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_pj2', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_pj3', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_pj4', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_jrn_rapt', 20, true);
-
-
-
-SELECT pg_catalog.setval('s_jrnaction', 5, true);
-
-
-
-SELECT pg_catalog.setval('s_jrnx', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_periode', 117, true);
-
-
-
-SELECT pg_catalog.setval('s_quantity', 13, true);
-
-
-
-SELECT pg_catalog.setval('s_stock_goods', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_tva', 1000, false);
-
-
-
-SELECT pg_catalog.setval('s_user_act', 1, false);
-
-
-
-SELECT pg_catalog.setval('s_user_jrn', 8, true);
-
-
-
-SELECT pg_catalog.setval('seq_bud_hypothese_bh_id', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_1', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_10', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_2', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_20', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_21', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_22', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_3', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_4', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_5', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_6', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_7', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_8', 1, false);
-
-
-
-SELECT pg_catalog.setval('seq_doc_type_9', 1, false);
-
-
-
-SELECT pg_catalog.setval('todo_list_tl_id_seq', 1, false);
-
-
-
-SELECT pg_catalog.setval('user_sec_extension_use_id_seq', 1, false);
-
-
-
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
135, 'Ajoute ou modifie des cat=C3=A9gories de documents', 'parametre', '=
PARCATDOC');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
10, 'Ajout de plan analytique', 'compta_anal', 'CAPA');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
20, 'Ajout de poste analytique', 'compta_anal', 'CAPO');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
30, 'Ajout de groupe analytique', 'compta_anal', 'CAGA');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
35, 'Ajout d''operation diverses', 'compta_anal', 'CAOD');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
40, 'Impression', 'compta_anal', 'CAIMP');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
00, 'Gestion', 'gestion', 'GESTION');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
05, 'Import en Banque', 'gestion', 'GEBQ');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
07, 'Effacement d''op=C3=A9ration', 'gestion', 'GEOP');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
10, 'Courrier (lecture & =C3=A9criture)', 'gestion', 'GECOUR');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
11, 'Fournisseur', 'gestion', 'GESUPPL');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
12, 'Client', 'gestion', 'GECUST');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
00, 'Rapport', 'impression', 'IMPRAP');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
10, 'Journaux', 'impression', 'IMPJRN');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
20, 'Fiche', 'impression', 'IMPFIC');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
30, 'Poste', 'impression', 'IMPPOSTE');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
40, 'Bilan', 'impression', 'IMPBIL');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
50, 'Balance', 'impression', 'IMPBAL');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (8=
00, 'Ajout de fiche', 'fiche', 'FICADD');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (8=
05, 'Cr=C3=A9ation, modification et effacement de fiche', 'fiche', 'FIC')=
;
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (9=
10, 'cr=C3=A9ation, modification et effacement de cat=C3=A9gorie de fiche=
', 'fiche', 'FICCAT');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
100, 'Mode comptabilit=C3=A9 analytique', 'parametre', 'PARCA');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
110, 'Ajout de p=C3=A9riode', 'parametre', 'PARPER');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
120, 'Cat=C3=A9gorie des fiches', 'parametre', 'PARFIC');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
130, 'Document', 'parametre', 'PARDOC');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
140, 'Modification journaux', 'parametre', 'PARJRN');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
150, 'TVA', 'parametre', 'PARTVA');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
160, 'Moyen de paiement', 'parametre', 'PARMP');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
180, 'Cl=C3=B4ture ', 'parametre', 'PARCLO');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
185, 'Changement du plan comptable ', 'parametre', 'PARPCMN');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
170, 'Poste Comptable de base', 'parametre', 'PARPOS');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
190, 'Centralisation', 'parametre', 'PARCENT');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
200, '=C3=89criture d''ouverture', 'parametre', 'PAREO');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
210, 'Mode strict', 'parametre', 'PARSTR');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
220, 'Coordonn=C3=A9es soci=C3=A9t=C3=A9', 'parametre', 'PARCOORD');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
230, 'Cr=C3=A9ation de rapport', 'parametre', 'PARRAP');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
240, 'Effacement et cr=C3=A9ation d''op=C3=A9ration pr=C3=A9d=C3=A9finie'=
, 'parametre', 'PARPREDE');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
245, 'S=C3=A9curit=C3=A9 du dossier', 'parametre', 'PARSEC');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
500, 'Stock (lecture)', 'stock', 'STOLE');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
510, 'Stock (changement)', 'stock', 'STOWRITE');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
13, 'Administration', 'gestion', 'GEADM');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
600, 'Gestion des extensions', 'extension', 'EXTENSION');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
701, 'Consultation', 'prvision', 'PREVCON');
-INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
702, 'Modification et cration', 'prvision', 'PREVMOD');
-
-
-
-
-
-
-
-
-
-INSERT INTO attr_def (ad_id, ad_text) VALUES (1, 'Nom');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (2, 'Taux TVA');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (3, 'Num=C3=A9ro de compte'=
);
-INSERT INTO attr_def (ad_id, ad_text) VALUES (4, 'Nom de la banque');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (5, 'Poste Comptable');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (6, 'Prix vente');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (7, 'Prix achat');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (8, 'Dur=C3=A9e Amortisseme=
nt');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (9, 'Description');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (10, 'Date d=C3=A9but');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (11, 'Montant initial');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (12, 'Personne de contact '=
);
-INSERT INTO attr_def (ad_id, ad_text) VALUES (13, 'num=C3=A9ro de tva ')=
;
-INSERT INTO attr_def (ad_id, ad_text) VALUES (14, 'Adresse ');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (16, 'pays ');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (17, 't=C3=A9l=C3=A9phone '=
);
-INSERT INTO attr_def (ad_id, ad_text) VALUES (18, 'email ');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (19, 'Gestion stock');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (20, 'Partie fiscalement no=
n d=C3=A9ductible');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (21, 'TVA non d=C3=A9ductib=
le');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (22, 'TVA non d=C3=A9ductib=
le r=C3=A9cup=C3=A9rable par l''imp=C3=B4t');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (23, 'Quick Code');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (24, 'Ville');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (25, 'Soci=C3=A9t=C3=A9');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (26, 'Fax');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (27, 'GSM');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (15, 'code postal');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (30, 'Numero de client');
-INSERT INTO attr_def (ad_id, ad_text) VALUES (31, 'Dpense  charge du gra=
nt (partie prive)');
-
-
-
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 2);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 2);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 2);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 3);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 4);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 13);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 14);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 15);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 16);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 17);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 18);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 13);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 14);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 15);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 16);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 17);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 18);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 13);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 14);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 16);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 17);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 18);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 6);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 7);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 6);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 7);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 7);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 19);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 19);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 4);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 10);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 4);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 10);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 12);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 9);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 8);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 9);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 10);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 11);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 11);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 15);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 15);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 9);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 24);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 24);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 24);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 17);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 18);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 25);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 26);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 27);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (17, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (17, 9);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (18, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (18, 9);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 1);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 4);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 3);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 5);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 15);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 16);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 24);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 23);
-INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 30);
-
-
-
-
-
-
-INSERT INTO bilan (b_id, b_name, b_file_template, b_file_form, b_type) V=
ALUES (5, 'Comptes de r=C3=A9sultat', 'document/fr_fr/fr_plan_abrege_pers=
o_cr1000.rtf', 'document/fr_fr/fr_plan_abrege_perso_cr1000.form', 'rtf');
-INSERT INTO bilan (b_id, b_name, b_file_template, b_file_form, b_type) V=
ALUES (1, 'Bilan fran=C3=A7ais', 'document/fr_fr/fr_plan_abrege_perso_bil=
10000.ods', 'document/fr_fr/fr_plan_abrege_perso_bil10000.form', 'ods');
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO document_state (s_id, s_value) VALUES (1, 'Cl=C3=B4tur=C3=A9=
');
-INSERT INTO document_state (s_id, s_value) VALUES (2, 'A suivre');
-INSERT INTO document_state (s_id, s_value) VALUES (3, 'A faire');
-INSERT INTO document_state (s_id, s_value) VALUES (4, 'Abandonn=C3=A9');
-
-
-
-INSERT INTO document_type (dt_id, dt_value) VALUES (1, 'Document Interne=
');
-INSERT INTO document_type (dt_id, dt_value) VALUES (2, 'Bons de commande=
 client');
-INSERT INTO document_type (dt_id, dt_value) VALUES (3, 'Bon de commande =
Fournisseur');
-INSERT INTO document_type (dt_id, dt_value) VALUES (4, 'Facture');
-INSERT INTO document_type (dt_id, dt_value) VALUES (5, 'Lettre de rappel=
');
-INSERT INTO document_type (dt_id, dt_value) VALUES (6, 'Courrier');
-INSERT INTO document_type (dt_id, dt_value) VALUES (7, 'Proposition');
-INSERT INTO document_type (dt_id, dt_value) VALUES (8, 'Email');
-INSERT INTO document_type (dt_id, dt_value) VALUES (9, 'Divers');
-INSERT INTO document_type (dt_id, dt_value) VALUES (10, 'Note de frais')=
;
-INSERT INTO document_type (dt_id, dt_value) VALUES (20, 'R=C3=A9ception =
commande Fournisseur');
-INSERT INTO document_type (dt_id, dt_value) VALUES (21, 'R=C3=A9ception =
commande Client');
-INSERT INTO document_type (dt_id, dt_value) VALUES (22, 'R=C3=A9ception =
magazine');
-
-
-
-
-
-
-
-
-
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (2, '400', 'Client', true, 9);
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (1, '604', 'Marchandises', true, 2);
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (3, '5500', 'Banque', true, 4);
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (4, '440', 'Fournisseur', true, 8);
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (5, '61', 'S & B D', true, 3);
-INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (6, '700', 'Vente', true, 1);
-
-
-
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (13,=
 'D=C3=A9penses non admises', 674);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (14,=
 'Administration des Finances', NULL);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (15,=
 'Autres fiches', NULL);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (4, =
'Banque', 51);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (5, =
'Pr=C3=AAt > a un an', 27);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (8, =
'Fournisseurs', 400);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (6, =
'Pr=C3=AAt < a un an', NULL);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (16,=
 'Contact', NULL);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (1, =
'Vente Service', 706);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (2, =
'Achat Marchandises', 603);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (9, =
'Clients', 410);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (10,=
 'Salaire Administrateur', 644);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (11,=
 'Salaire Ouvrier', 641);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (12,=
 'Salaire Employ=C3=A9', 641);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (7, =
'Mat=C3=A9riel =C3=A0 amortir, immobilisation corporelle', 21);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (3, =
'Achat Service et biens divers', 61);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (17,=
 'Escomptes accord=C3=A9es', 66);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (18,=
 'Produits Financiers', 76);
-INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (25,=
 'Compte Salari=C3=A9 / Administrateur', NULL);
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000398, 3000000, 1, 'Prestation [ case 03 ]', '[700%]-[7000005]');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000399, 3000000, 2, 'Prestation intra [ case 47 ]', '[7000005]');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000400, 3000000, 3, 'Tva due   [case 54]', '[4513]+[4512]+[4511] FROM=3D=
01.2005');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000401, 3000000, 4, 'Marchandises, mati=C3=A8re premi=C3=A8re et auxili=
aire [case 81 ]', '[60%]');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000402, 3000000, 7, 'Service et bien divers [case 82]', '[61%]');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000403, 3000000, 8, 'bien d''invest [ case 83 ]', '[2400%]');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000404, 3000000, 9, 'TVA d=C3=A9ductible [ case 59 ]', 'abs([4117]-[411=
%])');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000405, 3000000, 8, 'TVA non ded -> voiture', '[610022]*0.21/2');
-INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000406, 3000000, 9, 'Acompte TVA', '[4117]');
-
-
-
-INSERT INTO format_csv_banque (name, include_file) VALUES ('Fortis', 'fo=
rtis_be.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('EUB', 'eub_b=
e.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('ING', 'ing_b=
e.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('CBC', 'cbc_b=
e.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('Argenta Belg=
ique', 'argenta_be.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('CBC Belgique=
', 'cbc_be.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('Dexia', 'dex=
ia_be.inc.php');
-INSERT INTO format_csv_banque (name, include_file) VALUES ('VMS Keytrade=
', 'keytrade_be.inc.php');
-
-
-
-INSERT INTO formdef (fr_id, fr_label) VALUES (3000000, 'TVA d=C3=A9clara=
tion Belge');
-
-
-
-
-
-
-
-
-
-INSERT INTO info_def (id_type, id_description) VALUES ('BON_COMMANDE', '=
Numero de bon de commande');
-INSERT INTO info_def (id_type, id_description) VALUES ('OTHER', 'Info di=
verses');
-
-
-
-
-
-
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 2,=
 3, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 12=
, 8, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 3,=
 17, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 12=
, 28, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 2,=
 37, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 2,=
 41, 1);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 6,=
 4, 120);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 6,=
 42, 120);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 7,=
 5, 130);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 7,=
 38, 130);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 7,=
 43, 130);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 14=
, 10, 40);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 14=
, 21, 40);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 14=
, 30, 40);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 16=
, 12, 70);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 16=
, 23, 70);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 16=
, 32, 70);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 17=
, 13, 80);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 17=
, 24, 80);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 17=
, 33, 80);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 18=
, 14, 90);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 18=
, 25, 90);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 18=
, 34, 90);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 23=
, 45, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 23=
, 46, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 23=
, 47, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 23=
, 48, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 23=
, 49, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 23=
, 50, 400);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 24=
, 51, 60);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 24=
, 52, 60);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 15=
, 11, 50);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 15=
, 22, 50);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 15=
, 31, 50);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 5,=
 1, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 5,=
 6, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 5,=
 15, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 5,=
 26, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 5,=
 35, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 5,=
 39, 30);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 1,=
 2, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 1,=
 7, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 1,=
 16, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 1,=
 27, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 1,=
 36, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 1,=
 40, 0);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 4,=
 18, 2);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 12=
, 19, 3);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 19=
, 44, 2);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 13=
, 9, 31);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 13=
, 20, 31);
-INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 13=
, 29, 31);
-
-
-
-
-
-
-
-
-
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (2, 'Voir', 'Voir toutes les factures', 'user_jr=
n.php', 'action=3Dvoir_jrn', 'FR', 'VEN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (4, 'Voir Impay=C3=A9s', 'Voir toutes les factur=
es non pay=C3=A9es', 'user_jrn.php', 'action=3Dvoir_jrn_non_paye', 'FR', =
'VEN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (1, 'Nouvelle', 'Cr=C3=A9ation d''une facture', =
'user_jrn.php', 'action=3Dinsert_vente&blank', 'FR', 'VEN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (10, 'Nouveau', 'Encode un nouvel achat (mat=C3=A9=
riel, marchandises, services et biens divers)', 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'ACH');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (12, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'ACH');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (14, 'Voir Impay=C3=A9s', 'Voir toutes les factu=
res non pay=C3=A9es', 'user_jrn.php', 'action=3Dvoir_jrn_non_paye', 'FR',=
 'ACH');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (20, 'Nouveau', 'Encode un nouvel achat (mat=C3=A9=
riel, marchandises, services et biens divers)', 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'FIN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (22, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'FIN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (40, 'Soldes', 'Voir les soldes des comptes en b=
anques', 'user_jrn.php', 'action=3Dsolde', 'FR', 'FIN');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (30, 'Nouveau', NULL, 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'ODS');
-INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (32, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'ODS');
-
-
-
-INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (4, 'Op=C3=A9ration Diverses', NULL, NULL, NULL=
, NULL, 5, 5, false, NULL, 'ODS', 'OD-01', 'ODS');
-INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (2, 'Vente', '', '', '2', '6', 10, 10, true, ''=
'echeance''', 'VEN', 'VEN-01', 'VEN');
-INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (3, 'Achat', '', '', '5', '4', 10, 10, true, ''=
'echeance''', 'ACH', 'ACH-01', 'ACH');
-INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (1, 'Financier', '', '', '3,2,4,5', '3,2,4,5', =
10, 10, true, '''echeance''', 'FIN', 'FIN-01', 'FIN');
-
-
-
-
-
-
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 105, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 105, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 105, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 105, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 106, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 106, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 106, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 106, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 107, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 107, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 107, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 107, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 108, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 108, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 108, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 108, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 109, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 109, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 109, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 109, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 110, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 110, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 110, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 110, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 111, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 111, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 111, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 111, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 112, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 112, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 112, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 112, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 113, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 113, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 113, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 113, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 114, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 114, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 114, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 114, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 115, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 115, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 115, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 115, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 116, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 116, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 116, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 116, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 117, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 117, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 117, 'OP')=
;
-INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 117, 'OP')=
;
-
-
-
-
-
-
-INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('VEN', 'Vente');
-INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('ACH', 'Achat');
-INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('ODS', 'Op=C3=A9rat=
ions Diverses');
-INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('FIN', 'Banque');
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (2, 'Caisse', 1, 'VEN', NULL, NULL);
-INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (4, 'Caisse', 1, 'ACH', NULL, NULL);
-INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (1, 'Paiement =C3=A9lectronique', 1, 'VEN', NULL, NULL=
);
-INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (3, 'Par g=C3=A9rant ou administrateur', 2, 'ACH', NUL=
L, NULL);
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_NAME', 'LaMule');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TVA', 'FR33 123 456 =
789');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_STREET', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_NUMBER', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_CP', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TEL', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_PAYS', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_COMMUNE', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_FAX', '');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_ANALYTIC', 'nu');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_COUNTRY', 'FR');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_STRICT', 'Y');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TVA_USE', 'Y');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_PJ_SUGGEST', 'Y');
-INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_CHECK_PERIODE', 'N')=
;
-
-
-
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('BANQUE', '51=
', 'Poste comptable par d=C3=A9faut pour les banques');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('CAISSE', '53=
', 'Poste comptable par d=C3=A9faut pour les caisses');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('CUSTOMER', '=
410', 'Poste comptable par d=C3=A9faut pour les clients');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('VENTE', '707=
', 'Poste comptable par d=C3=A9faut pour les ventes');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('VIREMENT_INT=
ERNE', '58', 'Poste comptable par d=C3=A9faut pour les virements internes=
');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('DEP_PRIV', '=
4890', 'Depense a charge du gerant');
-INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('SUPPLIER', '=
400', 'Poste par d=C3=A9faut pour les fournisseurs');
-
-
-
-INSERT INTO parm_money (pm_id, pm_code, pm_rate) VALUES (1, 'EUR', 1.000=
0);
-
-
-
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (105, '2009-01-01', '2009-01-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (106, '2009-02-01', '2009-02-28', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (107, '2009-03-01', '2009-03-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (108, '2009-04-01', '2009-04-30', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (109, '2009-05-01', '2009-05-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (110, '2009-06-01', '2009-06-30', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (111, '2009-07-01', '2009-07-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (112, '2009-08-01', '2009-08-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (113, '2009-09-01', '2009-09-30', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (114, '2009-10-01', '2009-10-31', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (115, '2009-11-01', '2009-11-30', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (116, '2009-12-01', '2009-12-30', '2009', false, false);
-INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (117, '2009-12-31', '2009-12-31', '2009', false, false);
-
-
-
-INSERT INTO parm_poste (p_value, p_type) VALUES ('1', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('12', 'CON');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('2', 'ACT');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('3', 'ACT');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('41', 'ACT');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('42', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('43', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('44', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('45', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('46', 'CON');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('47', 'CON');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('481', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('482', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('483', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('484', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('485', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('486', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('487', 'ACT');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('49', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('5', 'ACT');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('6', 'CHA');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('7', 'PAS');
-INSERT INTO parm_poste (p_value, p_type) VALUES ('40', 'ACT');
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1', 'comptes de capitaux', '0', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('101', 'Capital', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('105', 'Ecarts de r=C3=A9=C3=A9valuation', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1061', 'R=C3=A9serve l=C3=A9gale', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1063', 'R=C3=A9serves statutaires ou contractuelles', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1064', 'R=C3=A9serves r=C3=A9glement=C3=A9es', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1068', 'Autres r=C3=A9serves', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('108', 'Compte de l''exploitant', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('12', 'r=C3=A9sultat de l''exercice (b=C3=A9n=C3=A9fice ou perte)', '1'=
, 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('145', 'Amortissements d=C3=A9rogatoires', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('146', 'Provision sp=C3=A9ciale de r=C3=A9=C3=A9valuation', '1', 'PAS')=
;
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('147', 'Plus-values r=C3=A9investies', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('148', 'Autres provisions r=C3=A9glement=C3=A9es', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('15', 'Provisions pour risques et charges', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('16', 'emprunts et dettes assimilees', '1', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('2', 'comptes d''immobilisations', '0', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('20', 'immobilisations incorporelles', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('201', 'Frais d''=C3=A9tablissement', '20', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('206', 'Droit au bail', '20', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('207', 'Fonds commercial', '20', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('208', 'Autres immobilisations incorporelles', '20', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('21', 'immobilisations corporelles', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('23', 'immobilisations en cours', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('27', 'autres immobilisations financieres', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('280', 'Amortissements des immobilisations incorporelles', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('281', 'Amortissements des immobilisations corporelles', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('290', 'Provisions pour d=C3=A9pr=C3=A9ciation des immobilisations inco=
rporelles', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('291', 'Provisions pour d=C3=A9pr=C3=A9ciation des immobilisations corp=
orelles (m=C3=AAme ventilation que celle du compte 21)', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('297', 'Provisions pour d=C3=A9pr=C3=A9ciation des autres immobilisatio=
ns financi=C3=A8res', '2', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('3', 'comptes de stocks et en cours', '0', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('31', 'matieres premi=C3=A8res (et fournitures)', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('32', 'autres approvisionnements', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('33', 'en-cours de production de biens', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('34', 'en-cours de production de services', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('35', 'stocks de produits', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('37', 'stocks de marchandises', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('391', 'Provisions pour d=C3=A9pr=C3=A9ciation des mati=C3=A8res premi=C3=
=A8res (et fournitures)', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('392', 'Provisions pour d=C3=A9pr=C3=A9ciation des autres approvisionne=
ments', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('393', 'Provisions pour d=C3=A9pr=C3=A9ciation des en-cours de producti=
on de biens', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('394', 'Provisions pour d=C3=A9pr=C3=A9ciation des en-cours de producti=
on de services', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('395', 'Provisions pour d=C3=A9pr=C3=A9ciation des stocks de produits',=
 '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('397', 'Provisions pour d=C3=A9pr=C3=A9ciation des stocks de marchandis=
es', '3', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4', 'comptes de tiers', '0', 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('400', 'Fournisseurs et Comptes rattach=C3=A9s', '4', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('409', 'Fournisseurs d=C3=A9biteurs', '4', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('410', 'Clients et Comptes rattach=C3=A9s', '4', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('419', 'Clients cr=C3=A9diteurs', '4', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('421', 'Personnel - R=C3=A9mun=C3=A9rations dues', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('428', 'Personnel - Charges =C3=A0 payer et produits =C3=A0 recevoir', =
'4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('43', 'S=C3=A9curit=C3=A9 sociale et autres organismes sociaux', '4', '=
PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('444', 'Etat - Imp=C3=B4ts sur les b=C3=A9n=C3=A9fices', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445', 'Etat - Taxes sur le chiffre d''affaires', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('447', 'Autres imp=C3=B4ts, taxes et versements assimil=C3=A9s', '4', '=
PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('45', 'Groupe et associes', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('455', 'Associ=C3=A9s - Comptes courants', '45', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('46', 'D=C3=A9biteurs divers et cr=C3=A9diteurs divers', '4', 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('47', 'comptes transitoires ou d''attente', '4', 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('481', 'Charges =C3=A0 r=C3=A9partir sur plusieurs exercices', '4', 'PA=
S');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('486', 'Charges constat=C3=A9es d''avance', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('487', 'Produits constat=C3=A9s d''avance', '4', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('491', 'Provisions pour d=C3=A9pr=C3=A9ciation des comptes de clients',=
 '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('496', 'Provisions pour d=C3=A9pr=C3=A9ciation des comptes de d=C3=A9bi=
teurs divers', '4', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('5', 'comptes financiers', '0', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('50', 'valeurs mobili=C3=A8res de placement', '5', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('51', 'banques, =C3=A9tablissements financiers et assimil=C3=A9s', '5',=
 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('53', 'Caisse', '5', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('54', 'r=C3=A9gies d''avance et accr=C3=A9ditifs', '5', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('58', 'virements internes', '5', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('590', 'Provisions pour d=C3=A9pr=C3=A9ciation des valeurs mobili=C3=A8=
res de placement', '5', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('6', 'comptes de charges', '0', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('60', 'Achats (sauf 603)', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('603', 'variations des stocks (approvisionnements et marchandises)', '6=
', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('61', 'autres charges externes - Services ext=C3=A9rieurs', '6', 'CHA')=
;
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('62', 'autres charges externes - Autres services ext=C3=A9rieurs', '6',=
 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('63', 'Imp=C3=B4ts, taxes et versements assimiles', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('641', 'R=C3=A9mun=C3=A9rations du personnel', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('644', 'R=C3=A9mun=C3=A9ration du travail de l''exploitant', '6', 'CHA'=
);
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('645', 'Charges de s=C3=A9curit=C3=A9 sociale et de pr=C3=A9voyance', '=
6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('646', 'Cotisations sociales personnelles de l''exploitant', '6', 'CHA'=
);
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('65', 'Autres charges de gestion courante', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('66', 'Charges financi=C3=A8res', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('67', 'Charges exceptionnelles', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('681', 'Dotations aux amortissements et aux provisions - Charges d''exp=
loitation', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('686', 'Dotations aux amortissements et aux provisions - Charges financ=
i=C3=A8res', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('687', 'Dotations aux amortissements et aux provisions - Charges except=
ionnelles', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('691', 'Participation des salari=C3=A9s aux r=C3=A9sultats', '6', 'CHA'=
);
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('695', 'Imp=C3=B4ts sur les b=C3=A9n=C3=A9fices', '6', 'CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('697', 'Imposition forfaitaire annuelle des soci=C3=A9t=C3=A9s', '6', '=
CHA');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('699', 'Produits - Reports en arri=C3=A8re des d=C3=A9ficits', '6', 'CH=
A');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('7', 'comptes de produits', '0', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('701', 'Ventes de produits finis', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('706', 'Prestations de services', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('707', 'Ventes de marchandises', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('708', 'Produits des activit=C3=A9s annexes', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('709', 'Rabais, remises et ristournes accord=C3=A9s par l''entreprise',=
 '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('713', 'Variation des stocks (en-cours de production, produits)', '7', =
'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('72', 'Production immobilis=C3=A9e', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('73', 'Produits nets partiels sur op=C3=A9rations =C3=A0 long terme', '=
7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('74', 'Subventions d''exploitation', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('75', 'Autres produits de gestion courante', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('753', 'Jetons de pr=C3=A9sence et r=C3=A9mun=C3=A9rations d''administr=
ateurs, g=C3=A9rants,...', '75', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('754', 'Ristournes per=C3=A7ues des coop=C3=A9ratives (provenant des ex=
c=C3=A9dents)', '75', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('755', 'Quotes-parts de r=C3=A9sultat sur op=C3=A9rations faites en com=
mun', '75', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('76', 'Produits financiers', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('77', 'Produits exceptionnels', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('781', 'Reprises sur amortissements et provisions (=C3=A0 inscrire dans=
 les produits d''exploitation)', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('786', 'Reprises sur provisions pour risques (=C3=A0 inscrire dans les =
produits financiers)', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('787', 'Reprises sur provisions (=C3=A0 inscrire dans les produits exce=
ptionnels)', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('79', 'Transferts de charges', '7', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('8', 'Comptes sp=C3=A9ciaux', '0', 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('9', 'Comptes analytiques', '0', 'CON');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456601', 'TVA 19,6% - France m=C3=A9tropolitaine - Taux immobilisatio=
ns D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445701', 'TVA 19,6% - France m=C3=A9tropolitaine - Taux immobilisation=
s Collect=C3=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456602', 'TVA x% - France m=C3=A9tropolitaine - Taux anciens D=C3=A9d=
uctible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445702', 'TVA x% - France m=C3=A9tropolitaine - Taux anciens Collect=C3=
=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456603', 'TVA 8,5%  - DOM - Taux normal D=C3=A9ductible', '4456', 'AC=
T');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445703', 'TVA 8,5%  - DOM - Taux normal Collect=C3=A9e ', '4457', 'PAS=
');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456604', 'TVA 8,5% - DOM - Taux normal NPR D=C3=A9ductible', '4456', =
'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445704', 'TVA 8,5% - DOM - Taux normal NPR Collect=C3=A9e ', '4457', '=
PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456605', 'TVA 2,1% - DOM - Taux r=C3=A9duit D=C3=A9ductible', '4456',=
 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445705', 'TVA 2,1% - DOM - Taux r=C3=A9duit Collect=C3=A9e ', '4457', =
'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456606', 'TVA 1,75% - DOM - Taux I D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445706', 'TVA 1,75% - DOM - Taux I Collect=C3=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456607', 'TVA 1,05% - DOM - Taux publications de presse D=C3=A9ductib=
le', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445707', 'TVA 1,05% - DOM - Taux publications de presse Collect=C3=A9e=
 ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456608', 'TVA x% - DOM - Taux octroi de mer D=C3=A9ductible', '4456',=
 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445708', 'TVA x% - DOM - Taux octroi de mer Collect=C3=A9e ', '4457', =
'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456609', 'TVA x% - DOM - Taux immobilisations D=C3=A9ductible', '4456=
', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445709', 'TVA x% - DOM - Taux immobilisations Collect=C3=A9e ', '4457'=
, 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566010', 'TVA 13% - Corse - Taux I D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457010', 'TVA 13% - Corse - Taux I Collect=C3=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566011', 'TVA 8% - Corse - Taux II D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457011', 'TVA 8% - Corse - Taux II Collect=C3=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566012', 'TVA 2,1% - Corse - Taux III D=C3=A9ductible', '4456', 'ACT=
');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457012', 'TVA 2,1% - Corse - Taux III Collect=C3=A9e ', '4457', 'PAS'=
);
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566013', 'TVA 0,9% - Corse - Taux IV D=C3=A9ductible', '4456', 'ACT'=
);
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457013', 'TVA 0,9% - Corse - Taux IV Collect=C3=A9e ', '4457', 'PAS')=
;
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566014', 'TVA x% - Corse - Taux immobilisations D=C3=A9ductible', '4=
456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457014', 'TVA x% - Corse - Taux immobilisations Collect=C3=A9e ', '44=
57', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566015', 'TVA x% - Acquisitions intracommunautaires/Pays D=C3=A9duct=
ible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457015', 'TVA x% - Acquisitions intracommunautaires/Pays Collect=C3=A9=
e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566016', 'TVA x% - Acquisitions intracommunautaires immobilisations/=
Pays D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457016', 'TVA x% - Acquisitions intracommunautaires immobilisations/P=
ays Collect=C3=A9e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566017', 'TVA x% - Non imposable : Achats en franchise D=C3=A9ductib=
le', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457017', 'TVA x% - Non imposable : Achats en franchise Collect=C3=A9e=
 ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566018', 'TVA x% - Non imposable : Exports hors CE/Pays D=C3=A9ducti=
ble', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457018', 'TVA x% - Non imposable : Exports hors CE/Pays Collect=C3=A9=
e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566019', 'TVA x% - Non imposable : Autres op=C3=A9rations D=C3=A9duc=
tible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457019', 'TVA x% - Non imposable : Autres op=C3=A9rations Collect=C3=A9=
e ', '4457', 'PAS');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pa=
ys D=C3=A9ductible', '4456', 'ACT');
-INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pay=
s Collect=C3=A9e ', '4457', 'PAS');
-
-
-
-
-
-
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (101, 'FR_NOR', 0.1960, 'TVA 19,6% - France m=C3=A9tropolitaine=
 - Taux normal', '445661,44571');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (102, 'FR_RED', 0.0550, 'TVA 5,5% - France m=C3=A9tropolitaine =
- Taux r=C3=A9duit', '445662,44572');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (103, 'FR_SRED', 0.0210, 'TVA 2,1% - France m=C3=A9tropolitaine=
 - Taux super r=C3=A9duit', '445663,44573');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (104, 'FR_IMMO', 0.1960, 'TVA 19,6% - France m=C3=A9tropolitain=
e - Taux immobilisations', '4456601,445701');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (105, 'FR_ANC', 0.0000, 'TVA x% - France m=C3=A9tropolitaine - =
Taux anciens', '4456602,445702');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (201, 'DOM', 0.0850, 'TVA 8,5%  - DOM - Taux normal', '4456603,=
445703');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (202, 'DOM_NPR', 0.0850, 'TVA 8,5% - DOM - Taux normal NPR', '4=
456604,445704');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (203, 'DOM_REDUIT', 0.0210, 'TVA 2,1% - DOM - Taux r=C3=A9duit'=
, '4456605,445705');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (204, 'DOM_I', 0.0175, 'TVA 1,75% - DOM - Taux I', '4456606,445=
706');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (205, 'DOM_PRESSE', 0.0105, 'TVA 1,05% - DOM - Taux publication=
s de presse', '4456607,445707');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (206, 'DOM_OCTROI', 0.0000, 'TVA x% - DOM - Taux octroi de mer'=
, '4456608,445708');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (207, 'DOM_IMMO', 0.0000, 'TVA x% - DOM - Taux immobilisations'=
, '4456609,445709');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (301, 'COR_I', 0.1300, 'TVA 13% - Corse - Taux I', '44566010,44=
57010');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (302, 'COR_II', 0.0800, 'TVA 8% - Corse - Taux II', '44566011,4=
457011');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (303, 'COR_III', 0.0210, 'TVA 2,1% - Corse - Taux III', '445660=
12,4457012');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (304, 'COR_IV', 0.0090, 'TVA 0,9% - Corse - Taux IV', '44566013=
,4457013');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (305, 'COR_IMMO', 0.0000, 'TVA x% - Corse - Taux immobilisation=
s', '44566014,4457014');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (401, 'INTRA', 0.0000, 'TVA x% - Acquisitions intracommunautair=
es/Pays', '44566015,4457015');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (402, 'INTRA_IMMMO', 0.0000, 'TVA x% - Acquisitions intracommun=
autaires immobilisations/Pays', '44566016,4457016');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (501, 'FRANCH', 0.0000, 'TVA x% - Non imposable : Achats en fra=
nchise', '44566017,4457017');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (502, 'EXPORT', 0.0000, 'TVA x% - Non imposable : Exports hors =
CE/Pays', '44566018,4457018');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (503, 'AUTRE', 0.0000, 'TVA x% - Non imposable : Autres op=C3=A9=
rations', '44566019,4457019');
-INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (504, 'INTRA_LIV', 0.0000, 'TVA x% - Non imposable : Livraisons=
 intracommunautaires/Pays', '44566020,4457020');
-
-
-
-INSERT INTO user_local_pref (user_id, parameter_type, parameter_value) V=
ALUES ('1', 'MINIREPORT', '0');
-INSERT INTO user_local_pref (user_id, parameter_type, parameter_value) V=
ALUES ('1', 'PERIODE', '105');
-
-
-
-
-
-
-
-
-
-
-
-
-INSERT INTO version (val) VALUES (75);
-
-
-

Copied: phpcompta/tags/rel650/html/admin/sql/mod2/data.sql (from rev 5152=
, phpcompta/tags/rel650/html/admin/sql/mod2/data.sql)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/html/admin/sql/mod2/data.sql	                  =
      (rev 0)
+++ phpcompta/tags/rel650/html/admin/sql/mod2/data.sql	2012-11-22 20:50:2=
7 UTC (rev 5155)
@@ -0,0 +1,1126 @@
+
+SET client_encoding =3D 'UTF8';
+SET standard_conforming_strings =3D off;
+SET check_function_bodies =3D false;
+SET client_min_messages =3D warning;
+SET escape_string_warning =3D off;
+
+SET search_path =3D public, pg_catalog;
+
+
+SELECT pg_catalog.setval('action_detail_ad_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('action_gestion_ag_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('bilan_b_id_seq', 4, true);
+
+
+
+SELECT pg_catalog.setval('bud_card_bc_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('bud_detail_bd_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('bud_detail_periode_bdp_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('del_action_del_id_seq', 1, true);
+
+
+
+SELECT pg_catalog.setval('document_d_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('document_modele_md_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('document_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('document_state_s_id_seq', 3, true);
+
+
+
+SELECT pg_catalog.setval('document_type_dt_id_seq', 25, false);
+
+
+
+SELECT pg_catalog.setval('extension_ex_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('forecast_cat_fc_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('forecast_f_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('forecast_item_fi_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('historique_analytique_ha_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jnt_id', 53, true);
+
+
+
+SELECT pg_catalog.setval('jnt_letter_jl_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('jrn_info_ji_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('letter_cred_lc_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('letter_deb_ld_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('mod_payment_mp_id_seq', 10, true);
+
+
+
+SELECT pg_catalog.setval('op_def_op_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('op_predef_detail_opd_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_oa_group', 7, true);
+
+
+
+SELECT pg_catalog.setval('plan_analytique_pa_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('poste_analytique_po_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_attr_def', 27, true);
+
+
+
+SELECT pg_catalog.setval('s_cbc', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_central', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_central_order', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_centralized', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_currency', 1, true);
+
+
+
+SELECT pg_catalog.setval('s_fdef', 6, true);
+
+
+
+SELECT pg_catalog.setval('s_fiche', 79, true);
+
+
+
+SELECT pg_catalog.setval('s_fiche_def_ref', 18, true);
+
+
+
+SELECT pg_catalog.setval('s_form', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_formdef', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_grpt', 102, true);
+
+
+
+SELECT pg_catalog.setval('s_idef', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_internal', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_invoice', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_isup', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jnt_fic_att_value', 875, true);
+
+
+
+SELECT pg_catalog.setval('s_jrn', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_1', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_2', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_3', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_4', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_def', 5, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_op', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_pj1', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_pj2', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_pj3', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_pj4', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_jrn_rapt', 20, true);
+
+
+
+SELECT pg_catalog.setval('s_jrnaction', 5, true);
+
+
+
+SELECT pg_catalog.setval('s_jrnx', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_periode', 117, true);
+
+
+
+SELECT pg_catalog.setval('s_quantity', 13, true);
+
+
+
+SELECT pg_catalog.setval('s_stock_goods', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_tva', 1000, false);
+
+
+
+SELECT pg_catalog.setval('s_user_act', 1, false);
+
+
+
+SELECT pg_catalog.setval('s_user_jrn', 8, true);
+
+
+
+SELECT pg_catalog.setval('seq_bud_hypothese_bh_id', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_1', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_10', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_2', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_20', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_21', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_22', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_3', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_4', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_5', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_6', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_7', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_8', 1, false);
+
+
+
+SELECT pg_catalog.setval('seq_doc_type_9', 1, false);
+
+
+
+SELECT pg_catalog.setval('todo_list_tl_id_seq', 1, false);
+
+
+
+SELECT pg_catalog.setval('user_sec_extension_use_id_seq', 1, false);
+
+
+
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
135, 'Ajoute ou modifie des cat=C3=A9gories de documents', 'parametre', '=
PARCATDOC');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
10, 'Ajout de plan analytique', 'compta_anal', 'CAPA');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
20, 'Ajout de poste analytique', 'compta_anal', 'CAPO');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
30, 'Ajout de groupe analytique', 'compta_anal', 'CAGA');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
35, 'Ajout d''operation diverses', 'compta_anal', 'CAOD');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (2=
40, 'Impression', 'compta_anal', 'CAIMP');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
00, 'Gestion', 'gestion', 'GESTION');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
05, 'Import en Banque', 'gestion', 'GEBQ');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
07, 'Effacement d''op=C3=A9ration', 'gestion', 'GEOP');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
10, 'Courrier (lecture & =C3=A9criture)', 'gestion', 'GECOUR');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
11, 'Fournisseur', 'gestion', 'GESUPPL');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
12, 'Client', 'gestion', 'GECUST');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
00, 'Rapport', 'impression', 'IMPRAP');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
10, 'Journaux', 'impression', 'IMPJRN');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
20, 'Fiche', 'impression', 'IMPFIC');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
30, 'Poste', 'impression', 'IMPPOSTE');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
40, 'Bilan', 'impression', 'IMPBIL');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (7=
50, 'Balance', 'impression', 'IMPBAL');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (8=
00, 'Ajout de fiche', 'fiche', 'FICADD');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (8=
05, 'Cr=C3=A9ation, modification et effacement de fiche', 'fiche', 'FIC')=
;
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (9=
10, 'cr=C3=A9ation, modification et effacement de cat=C3=A9gorie de fiche=
', 'fiche', 'FICCAT');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
100, 'Mode comptabilit=C3=A9 analytique', 'parametre', 'PARCA');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
110, 'Ajout de p=C3=A9riode', 'parametre', 'PARPER');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
120, 'Cat=C3=A9gorie des fiches', 'parametre', 'PARFIC');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
130, 'Document', 'parametre', 'PARDOC');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
140, 'Modification journaux', 'parametre', 'PARJRN');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
150, 'TVA', 'parametre', 'PARTVA');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
160, 'Moyen de paiement', 'parametre', 'PARMP');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
180, 'Cl=C3=B4ture ', 'parametre', 'PARCLO');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
185, 'Changement du plan comptable ', 'parametre', 'PARPCMN');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
170, 'Poste Comptable de base', 'parametre', 'PARPOS');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
190, 'Centralisation', 'parametre', 'PARCENT');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
200, '=C3=89criture d''ouverture', 'parametre', 'PAREO');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
210, 'Mode strict', 'parametre', 'PARSTR');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
220, 'Coordonn=C3=A9es soci=C3=A9t=C3=A9', 'parametre', 'PARCOORD');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
230, 'Cr=C3=A9ation de rapport', 'parametre', 'PARRAP');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
240, 'Effacement et cr=C3=A9ation d''op=C3=A9ration pr=C3=A9d=C3=A9finie'=
, 'parametre', 'PARPREDE');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
245, 'S=C3=A9curit=C3=A9 du dossier', 'parametre', 'PARSEC');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
500, 'Stock (lecture)', 'stock', 'STOLE');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
510, 'Stock (changement)', 'stock', 'STOWRITE');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (3=
13, 'Administration', 'gestion', 'GEADM');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
600, 'Gestion des extensions', 'extension', 'EXTENSION');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
701, 'Consultation', 'prvision', 'PREVCON');
+INSERT INTO action (ac_id, ac_description, ac_module, ac_code) VALUES (1=
702, 'Modification et cration', 'prvision', 'PREVMOD');
+
+
+
+
+
+
+
+
+
+INSERT INTO attr_def (ad_id, ad_text) VALUES (1, 'Nom');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (2, 'Taux TVA');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (3, 'Num=C3=A9ro de compte'=
);
+INSERT INTO attr_def (ad_id, ad_text) VALUES (4, 'Nom de la banque');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (5, 'Poste Comptable');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (6, 'Prix vente');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (7, 'Prix achat');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (8, 'Dur=C3=A9e Amortisseme=
nt');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (9, 'Description');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (10, 'Date d=C3=A9but');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (11, 'Montant initial');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (12, 'Personne de contact '=
);
+INSERT INTO attr_def (ad_id, ad_text) VALUES (13, 'num=C3=A9ro de tva ')=
;
+INSERT INTO attr_def (ad_id, ad_text) VALUES (14, 'Adresse ');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (16, 'pays ');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (17, 't=C3=A9l=C3=A9phone '=
);
+INSERT INTO attr_def (ad_id, ad_text) VALUES (18, 'email ');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (19, 'Gestion stock');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (20, 'Partie fiscalement no=
n d=C3=A9ductible');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (21, 'TVA non d=C3=A9ductib=
le');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (22, 'TVA non d=C3=A9ductib=
le r=C3=A9cup=C3=A9rable par l''imp=C3=B4t');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (23, 'Quick Code');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (24, 'Ville');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (25, 'Soci=C3=A9t=C3=A9');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (26, 'Fax');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (27, 'GSM');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (15, 'code postal');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (30, 'Numero de client');
+INSERT INTO attr_def (ad_id, ad_text) VALUES (31, 'Dpense  charge du gra=
nt (partie prive)');
+
+
+
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 2);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 2);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 2);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 3);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 4);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 13);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 14);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 15);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 16);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 17);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 18);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 13);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 14);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 15);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 16);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 17);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 18);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 13);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 14);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 16);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 17);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 18);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 6);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 7);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 6);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 7);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 7);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 19);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 19);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 4);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 10);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 4);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 10);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 12);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 9);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 8);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 9);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 10);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 11);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 11);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 15);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 15);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 9);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (1, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (3, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (4, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (5, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (6, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (10, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (11, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (12, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (13, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (15, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (7, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (9, 24);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (8, 24);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (14, 24);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 17);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 18);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 25);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 26);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 27);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (16, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (17, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (17, 9);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (18, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (18, 9);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 1);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 4);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 3);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 5);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 15);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 16);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 24);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (25, 23);
+INSERT INTO attr_min (frd_id, ad_id) VALUES (2, 30);
+
+
+
+
+
+
+INSERT INTO bilan (b_id, b_name, b_file_template, b_file_form, b_type) V=
ALUES (5, 'Comptes de r=C3=A9sultat', 'document/fr_fr/fr_plan_abrege_pers=
o_cr1000.rtf', 'document/fr_fr/fr_plan_abrege_perso_cr1000.form', 'rtf');
+INSERT INTO bilan (b_id, b_name, b_file_template, b_file_form, b_type) V=
ALUES (1, 'Bilan fran=C3=A7ais', 'document/fr_fr/fr_plan_abrege_perso_bil=
10000.ods', 'document/fr_fr/fr_plan_abrege_perso_bil10000.form', 'ods');
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO document_state (s_id, s_value) VALUES (1, 'Cl=C3=B4tur=C3=A9=
');
+INSERT INTO document_state (s_id, s_value) VALUES (2, 'A suivre');
+INSERT INTO document_state (s_id, s_value) VALUES (3, 'A faire');
+INSERT INTO document_state (s_id, s_value) VALUES (4, 'Abandonn=C3=A9');
+
+
+
+INSERT INTO document_type (dt_id, dt_value) VALUES (1, 'Document Interne=
');
+INSERT INTO document_type (dt_id, dt_value) VALUES (2, 'Bons de commande=
 client');
+INSERT INTO document_type (dt_id, dt_value) VALUES (3, 'Bon de commande =
Fournisseur');
+INSERT INTO document_type (dt_id, dt_value) VALUES (4, 'Facture');
+INSERT INTO document_type (dt_id, dt_value) VALUES (5, 'Lettre de rappel=
');
+INSERT INTO document_type (dt_id, dt_value) VALUES (6, 'Courrier');
+INSERT INTO document_type (dt_id, dt_value) VALUES (7, 'Proposition');
+INSERT INTO document_type (dt_id, dt_value) VALUES (8, 'Email');
+INSERT INTO document_type (dt_id, dt_value) VALUES (9, 'Divers');
+INSERT INTO document_type (dt_id, dt_value) VALUES (10, 'Note de frais')=
;
+INSERT INTO document_type (dt_id, dt_value) VALUES (20, 'R=C3=A9ception =
commande Fournisseur');
+INSERT INTO document_type (dt_id, dt_value) VALUES (21, 'R=C3=A9ception =
commande Client');
+INSERT INTO document_type (dt_id, dt_value) VALUES (22, 'R=C3=A9ception =
magazine');
+
+
+
+
+
+
+
+
+
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (2, '410', 'Client', true, 9);
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (1, '604', 'Marchandises', true, 2);
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (3, '51', 'Banque', true, 4);
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (4, '400', 'Fournisseur', true, 8);
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (5, '61', 'S & B D', true, 3);
+INSERT INTO fiche_def (fd_id, fd_class_base, fd_label, fd_create_account=
, frd_id) VALUES (6, '700', 'Vente', true, 1);
+
+
+
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (13,=
 'D=C3=A9penses non admises', 674);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (14,=
 'Administration des Finances', NULL);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (15,=
 'Autres fiches', NULL);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (4, =
'Banque', 51);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (5, =
'Pr=C3=AAt > a un an', 27);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (8, =
'Fournisseurs', 400);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (6, =
'Pr=C3=AAt < a un an', NULL);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (16,=
 'Contact', NULL);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (1, =
'Vente Service', 706);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (2, =
'Achat Marchandises', 603);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (9, =
'Clients', 410);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (10,=
 'Salaire Administrateur', 644);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (11,=
 'Salaire Ouvrier', 641);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (12,=
 'Salaire Employ=C3=A9', 641);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (7, =
'Mat=C3=A9riel =C3=A0 amortir, immobilisation corporelle', 21);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (3, =
'Achat Service et biens divers', 61);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (17,=
 'Escomptes accord=C3=A9es', 66);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (18,=
 'Produits Financiers', 76);
+INSERT INTO fiche_def_ref (frd_id, frd_text, frd_class_base) VALUES (25,=
 'Compte Salari=C3=A9 / Administrateur', NULL);
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000398, 3000000, 1, 'Prestation [ case 03 ]', '[700%]-[7000005]');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000399, 3000000, 2, 'Prestation intra [ case 47 ]', '[7000005]');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000400, 3000000, 3, 'Tva due   [case 54]', '[4513]+[4512]+[4511] FROM=3D=
01.2005');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000401, 3000000, 4, 'Marchandises, mati=C3=A8re premi=C3=A8re et auxili=
aire [case 81 ]', '[60%]');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000402, 3000000, 7, 'Service et bien divers [case 82]', '[61%]');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000403, 3000000, 8, 'bien d''invest [ case 83 ]', '[2400%]');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000404, 3000000, 9, 'TVA d=C3=A9ductible [ case 59 ]', 'abs([4117]-[411=
%])');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000405, 3000000, 8, 'TVA non ded -> voiture', '[610022]*0.21/2');
+INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES =
(3000406, 3000000, 9, 'Acompte TVA', '[4117]');
+
+
+
+INSERT INTO format_csv_banque (name, include_file) VALUES ('Fortis', 'fo=
rtis_be.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('EUB', 'eub_b=
e.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('ING', 'ing_b=
e.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('CBC', 'cbc_b=
e.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('Argenta Belg=
ique', 'argenta_be.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('CBC Belgique=
', 'cbc_be.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('Dexia', 'dex=
ia_be.inc.php');
+INSERT INTO format_csv_banque (name, include_file) VALUES ('VMS Keytrade=
', 'keytrade_be.inc.php');
+
+
+
+INSERT INTO formdef (fr_id, fr_label) VALUES (3000000, 'TVA d=C3=A9clara=
tion Belge');
+
+
+
+
+
+
+
+
+
+INSERT INTO info_def (id_type, id_description) VALUES ('BON_COMMANDE', '=
Numero de bon de commande');
+INSERT INTO info_def (id_type, id_description) VALUES ('OTHER', 'Info di=
verses');
+
+
+
+
+
+
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 2,=
 3, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 12=
, 8, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 3,=
 17, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 12=
, 28, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 2,=
 37, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 2,=
 41, 1);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 6,=
 4, 120);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 6,=
 42, 120);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 7,=
 5, 130);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 7,=
 38, 130);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 7,=
 43, 130);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 14=
, 10, 40);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 14=
, 21, 40);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 14=
, 30, 40);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 16=
, 12, 70);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 16=
, 23, 70);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 16=
, 32, 70);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 17=
, 13, 80);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 17=
, 24, 80);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 17=
, 33, 80);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 18=
, 14, 90);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 18=
, 25, 90);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 18=
, 34, 90);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 23=
, 45, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 23=
, 46, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 23=
, 47, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 23=
, 48, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 23=
, 49, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 23=
, 50, 400);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 24=
, 51, 60);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 24=
, 52, 60);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 15=
, 11, 50);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 15=
, 22, 50);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 15=
, 31, 50);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 5,=
 1, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 5,=
 6, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 5,=
 15, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 5,=
 26, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 5,=
 35, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 5,=
 39, 30);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (1, 1,=
 2, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 1,=
 7, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 1,=
 16, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 1,=
 27, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (5, 1,=
 36, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 1,=
 40, 0);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 4,=
 18, 2);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 12=
, 19, 3);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (6, 19=
, 44, 2);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (2, 13=
, 9, 31);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (3, 13=
, 20, 31);
+INSERT INTO jnt_fic_attr (fd_id, ad_id, jnt_id, jnt_order) VALUES (4, 13=
, 29, 31);
+
+
+
+
+
+
+
+
+
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (2, 'Voir', 'Voir toutes les factures', 'user_jr=
n.php', 'action=3Dvoir_jrn', 'FR', 'VEN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (4, 'Voir Impay=C3=A9s', 'Voir toutes les factur=
es non pay=C3=A9es', 'user_jrn.php', 'action=3Dvoir_jrn_non_paye', 'FR', =
'VEN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (1, 'Nouvelle', 'Cr=C3=A9ation d''une facture', =
'user_jrn.php', 'action=3Dinsert_vente&blank', 'FR', 'VEN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (10, 'Nouveau', 'Encode un nouvel achat (mat=C3=A9=
riel, marchandises, services et biens divers)', 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'ACH');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (12, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'ACH');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (14, 'Voir Impay=C3=A9s', 'Voir toutes les factu=
res non pay=C3=A9es', 'user_jrn.php', 'action=3Dvoir_jrn_non_paye', 'FR',=
 'ACH');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (20, 'Nouveau', 'Encode un nouvel achat (mat=C3=A9=
riel, marchandises, services et biens divers)', 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'FIN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (22, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'FIN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (40, 'Soldes', 'Voir les soldes des comptes en b=
anques', 'user_jrn.php', 'action=3Dsolde', 'FR', 'FIN');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (30, 'Nouveau', NULL, 'user_jrn.php', 'action=3D=
new&blank', 'FR', 'ODS');
+INSERT INTO jrn_action (ja_id, ja_name, ja_desc, ja_url, ja_action, ja_l=
ang, ja_jrn_type) VALUES (32, 'Voir', 'Voir toutes les factures', 'user_j=
rn.php', 'action=3Dvoir_jrn', 'FR', 'ODS');
+
+
+
+INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (4, 'Op=C3=A9ration Diverses', NULL, NULL, NULL=
, NULL, 5, 5, false, NULL, 'ODS', 'OD-01', 'ODS');
+INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (2, 'Vente', '', '', '2', '6', 10, 10, true, ''=
'echeance''', 'VEN', 'VEN-01', 'VEN');
+INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (3, 'Achat', '', '', '5', '4', 10, 10, true, ''=
'echeance''', 'ACH', 'ACH-01', 'ACH');
+INSERT INTO jrn_def (jrn_def_id, jrn_def_name, jrn_def_class_deb, jrn_de=
f_class_cred, jrn_def_fiche_deb, jrn_def_fiche_cred, jrn_deb_max_line, jr=
n_cred_max_line, jrn_def_ech, jrn_def_ech_lib, jrn_def_type, jrn_def_code=
, jrn_def_pj_pref) VALUES (1, 'Financier', '', '', '3,2,4,5', '3,2,4,5', =
10, 10, true, '''echeance''', 'FIN', 'FIN-01', 'FIN');
+
+
+
+
+
+
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 105, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 105, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 105, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 105, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 106, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 106, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 106, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 106, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 107, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 107, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 107, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 107, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 108, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 108, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 108, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 108, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 109, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 109, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 109, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 109, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 110, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 110, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 110, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 110, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 111, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 111, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 111, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 111, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 112, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 112, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 112, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 112, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 113, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 113, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 113, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 113, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 114, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 114, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 114, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 114, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 115, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 115, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 115, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 115, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 116, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 116, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 116, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 116, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (4, 117, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (2, 117, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (3, 117, 'OP')=
;
+INSERT INTO jrn_periode (jrn_def_id, p_id, status) VALUES (1, 117, 'OP')=
;
+
+
+
+
+
+
+INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('VEN', 'Vente');
+INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('ACH', 'Achat');
+INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('ODS', 'Op=C3=A9rat=
ions Diverses');
+INSERT INTO jrn_type (jrn_type_id, jrn_desc) VALUES ('FIN', 'Banque');
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (2, 'Caisse', 1, 'VEN', NULL, NULL);
+INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (4, 'Caisse', 1, 'ACH', NULL, NULL);
+INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (1, 'Paiement =C3=A9lectronique', 1, 'VEN', NULL, NULL=
);
+INSERT INTO mod_payment (mp_id, mp_lib, mp_jrn_def_id, mp_type, mp_fd_id=
, mp_qcode) VALUES (3, 'Par g=C3=A9rant ou administrateur', 2, 'ACH', NUL=
L, NULL);
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_NAME', 'LaMule');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TVA', 'FR33 123 456 =
789');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_STREET', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_NUMBER', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_CP', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TEL', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_PAYS', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_COMMUNE', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_FAX', '');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_ANALYTIC', 'nu');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_COUNTRY', 'FR');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_STRICT', 'Y');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_TVA_USE', 'Y');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_PJ_SUGGEST', 'Y');
+INSERT INTO parameter (pr_id, pr_value) VALUES ('MY_CHECK_PERIODE', 'N')=
;
+
+
+
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('BANQUE', '51=
', 'Poste comptable par d=C3=A9faut pour les banques');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('CAISSE', '53=
', 'Poste comptable par d=C3=A9faut pour les caisses');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('CUSTOMER', '=
410', 'Poste comptable par d=C3=A9faut pour les clients');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('VENTE', '707=
', 'Poste comptable par d=C3=A9faut pour les ventes');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('VIREMENT_INT=
ERNE', '58', 'Poste comptable par d=C3=A9faut pour les virements internes=
');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('DEP_PRIV', '=
4890', 'Depense a charge du gerant');
+INSERT INTO parm_code (p_code, p_value, p_comment) VALUES ('SUPPLIER', '=
400', 'Poste par d=C3=A9faut pour les fournisseurs');
+
+
+
+INSERT INTO parm_money (pm_id, pm_code, pm_rate) VALUES (1, 'EUR', 1.000=
0);
+
+
+
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (105, '2009-01-01', '2009-01-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (106, '2009-02-01', '2009-02-28', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (107, '2009-03-01', '2009-03-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (108, '2009-04-01', '2009-04-30', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (109, '2009-05-01', '2009-05-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (110, '2009-06-01', '2009-06-30', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (111, '2009-07-01', '2009-07-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (112, '2009-08-01', '2009-08-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (113, '2009-09-01', '2009-09-30', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (114, '2009-10-01', '2009-10-31', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (115, '2009-11-01', '2009-11-30', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (116, '2009-12-01', '2009-12-30', '2009', false, false);
+INSERT INTO parm_periode (p_id, p_start, p_end, p_exercice, p_closed, p_=
central) VALUES (117, '2009-12-31', '2009-12-31', '2009', false, false);
+
+
+
+INSERT INTO parm_poste (p_value, p_type) VALUES ('1', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('12', 'CON');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('2', 'ACT');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('3', 'ACT');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('41', 'ACT');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('42', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('43', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('44', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('45', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('46', 'CON');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('47', 'CON');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('481', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('482', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('483', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('484', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('485', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('486', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('487', 'ACT');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('49', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('5', 'ACT');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('6', 'CHA');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('7', 'PAS');
+INSERT INTO parm_poste (p_value, p_type) VALUES ('40', 'ACT');
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1', 'comptes de capitaux', '0', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('101', 'Capital', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('105', 'Ecarts de r=C3=A9=C3=A9valuation', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1061', 'R=C3=A9serve l=C3=A9gale', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1063', 'R=C3=A9serves statutaires ou contractuelles', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1064', 'R=C3=A9serves r=C3=A9glement=C3=A9es', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('1068', 'Autres r=C3=A9serves', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('108', 'Compte de l''exploitant', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('12', 'r=C3=A9sultat de l''exercice (b=C3=A9n=C3=A9fice ou perte)', '1'=
, 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('145', 'Amortissements d=C3=A9rogatoires', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('146', 'Provision sp=C3=A9ciale de r=C3=A9=C3=A9valuation', '1', 'PAS')=
;
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('147', 'Plus-values r=C3=A9investies', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('148', 'Autres provisions r=C3=A9glement=C3=A9es', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('15', 'Provisions pour risques et charges', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('16', 'emprunts et dettes assimilees', '1', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('2', 'comptes d''immobilisations', '0', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('20', 'immobilisations incorporelles', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('201', 'Frais d''=C3=A9tablissement', '20', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('206', 'Droit au bail', '20', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('207', 'Fonds commercial', '20', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('208', 'Autres immobilisations incorporelles', '20', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('21', 'immobilisations corporelles', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('23', 'immobilisations en cours', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('27', 'autres immobilisations financieres', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('280', 'Amortissements des immobilisations incorporelles', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('281', 'Amortissements des immobilisations corporelles', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('290', 'Provisions pour d=C3=A9pr=C3=A9ciation des immobilisations inco=
rporelles', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('291', 'Provisions pour d=C3=A9pr=C3=A9ciation des immobilisations corp=
orelles (m=C3=AAme ventilation que celle du compte 21)', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('297', 'Provisions pour d=C3=A9pr=C3=A9ciation des autres immobilisatio=
ns financi=C3=A8res', '2', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('3', 'comptes de stocks et en cours', '0', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('31', 'matieres premi=C3=A8res (et fournitures)', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('32', 'autres approvisionnements', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('33', 'en-cours de production de biens', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('34', 'en-cours de production de services', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('35', 'stocks de produits', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('37', 'stocks de marchandises', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('391', 'Provisions pour d=C3=A9pr=C3=A9ciation des mati=C3=A8res premi=C3=
=A8res (et fournitures)', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('392', 'Provisions pour d=C3=A9pr=C3=A9ciation des autres approvisionne=
ments', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('393', 'Provisions pour d=C3=A9pr=C3=A9ciation des en-cours de producti=
on de biens', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('394', 'Provisions pour d=C3=A9pr=C3=A9ciation des en-cours de producti=
on de services', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('395', 'Provisions pour d=C3=A9pr=C3=A9ciation des stocks de produits',=
 '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('397', 'Provisions pour d=C3=A9pr=C3=A9ciation des stocks de marchandis=
es', '3', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4', 'comptes de tiers', '0', 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('400', 'Fournisseurs et Comptes rattach=C3=A9s', '4', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('409', 'Fournisseurs d=C3=A9biteurs', '4', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('410', 'Clients et Comptes rattach=C3=A9s', '4', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('419', 'Clients cr=C3=A9diteurs', '4', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('421', 'Personnel - R=C3=A9mun=C3=A9rations dues', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('428', 'Personnel - Charges =C3=A0 payer et produits =C3=A0 recevoir', =
'4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('43', 'S=C3=A9curit=C3=A9 sociale et autres organismes sociaux', '4', '=
PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('444', 'Etat - Imp=C3=B4ts sur les b=C3=A9n=C3=A9fices', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445', 'Etat - Taxes sur le chiffre d''affaires', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('447', 'Autres imp=C3=B4ts, taxes et versements assimil=C3=A9s', '4', '=
PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('45', 'Groupe et associes', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('455', 'Associ=C3=A9s - Comptes courants', '45', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('46', 'D=C3=A9biteurs divers et cr=C3=A9diteurs divers', '4', 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('47', 'comptes transitoires ou d''attente', '4', 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('481', 'Charges =C3=A0 r=C3=A9partir sur plusieurs exercices', '4', 'PA=
S');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('486', 'Charges constat=C3=A9es d''avance', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('487', 'Produits constat=C3=A9s d''avance', '4', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('491', 'Provisions pour d=C3=A9pr=C3=A9ciation des comptes de clients',=
 '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('496', 'Provisions pour d=C3=A9pr=C3=A9ciation des comptes de d=C3=A9bi=
teurs divers', '4', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('5', 'comptes financiers', '0', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('50', 'valeurs mobili=C3=A8res de placement', '5', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('51', 'banques, =C3=A9tablissements financiers et assimil=C3=A9s', '5',=
 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('53', 'Caisse', '5', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('54', 'r=C3=A9gies d''avance et accr=C3=A9ditifs', '5', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('58', 'virements internes', '5', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('590', 'Provisions pour d=C3=A9pr=C3=A9ciation des valeurs mobili=C3=A8=
res de placement', '5', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('6', 'comptes de charges', '0', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('60', 'Achats (sauf 603)', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('603', 'variations des stocks (approvisionnements et marchandises)', '6=
', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('61', 'autres charges externes - Services ext=C3=A9rieurs', '6', 'CHA')=
;
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('62', 'autres charges externes - Autres services ext=C3=A9rieurs', '6',=
 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('63', 'Imp=C3=B4ts, taxes et versements assimiles', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('641', 'R=C3=A9mun=C3=A9rations du personnel', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('644', 'R=C3=A9mun=C3=A9ration du travail de l''exploitant', '6', 'CHA'=
);
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('645', 'Charges de s=C3=A9curit=C3=A9 sociale et de pr=C3=A9voyance', '=
6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('646', 'Cotisations sociales personnelles de l''exploitant', '6', 'CHA'=
);
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('65', 'Autres charges de gestion courante', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('66', 'Charges financi=C3=A8res', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('67', 'Charges exceptionnelles', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('681', 'Dotations aux amortissements et aux provisions - Charges d''exp=
loitation', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('686', 'Dotations aux amortissements et aux provisions - Charges financ=
i=C3=A8res', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('687', 'Dotations aux amortissements et aux provisions - Charges except=
ionnelles', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('691', 'Participation des salari=C3=A9s aux r=C3=A9sultats', '6', 'CHA'=
);
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('695', 'Imp=C3=B4ts sur les b=C3=A9n=C3=A9fices', '6', 'CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('697', 'Imposition forfaitaire annuelle des soci=C3=A9t=C3=A9s', '6', '=
CHA');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('699', 'Produits - Reports en arri=C3=A8re des d=C3=A9ficits', '6', 'CH=
A');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('7', 'comptes de produits', '0', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('701', 'Ventes de produits finis', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('706', 'Prestations de services', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('707', 'Ventes de marchandises', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('708', 'Produits des activit=C3=A9s annexes', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('709', 'Rabais, remises et ristournes accord=C3=A9s par l''entreprise',=
 '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('713', 'Variation des stocks (en-cours de production, produits)', '7', =
'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('72', 'Production immobilis=C3=A9e', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('73', 'Produits nets partiels sur op=C3=A9rations =C3=A0 long terme', '=
7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('74', 'Subventions d''exploitation', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('75', 'Autres produits de gestion courante', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('753', 'Jetons de pr=C3=A9sence et r=C3=A9mun=C3=A9rations d''administr=
ateurs, g=C3=A9rants,...', '75', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('754', 'Ristournes per=C3=A7ues des coop=C3=A9ratives (provenant des ex=
c=C3=A9dents)', '75', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('755', 'Quotes-parts de r=C3=A9sultat sur op=C3=A9rations faites en com=
mun', '75', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('76', 'Produits financiers', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('77', 'Produits exceptionnels', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('781', 'Reprises sur amortissements et provisions (=C3=A0 inscrire dans=
 les produits d''exploitation)', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('786', 'Reprises sur provisions pour risques (=C3=A0 inscrire dans les =
produits financiers)', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('787', 'Reprises sur provisions (=C3=A0 inscrire dans les produits exce=
ptionnels)', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('79', 'Transferts de charges', '7', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('8', 'Comptes sp=C3=A9ciaux', '0', 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('9', 'Comptes analytiques', '0', 'CON');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456601', 'TVA 19,6% - France m=C3=A9tropolitaine - Taux immobilisatio=
ns D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445701', 'TVA 19,6% - France m=C3=A9tropolitaine - Taux immobilisation=
s Collect=C3=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456602', 'TVA x% - France m=C3=A9tropolitaine - Taux anciens D=C3=A9d=
uctible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445702', 'TVA x% - France m=C3=A9tropolitaine - Taux anciens Collect=C3=
=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456603', 'TVA 8,5%  - DOM - Taux normal D=C3=A9ductible', '4456', 'AC=
T');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445703', 'TVA 8,5%  - DOM - Taux normal Collect=C3=A9e ', '4457', 'PAS=
');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456604', 'TVA 8,5% - DOM - Taux normal NPR D=C3=A9ductible', '4456', =
'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445704', 'TVA 8,5% - DOM - Taux normal NPR Collect=C3=A9e ', '4457', '=
PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456605', 'TVA 2,1% - DOM - Taux r=C3=A9duit D=C3=A9ductible', '4456',=
 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445705', 'TVA 2,1% - DOM - Taux r=C3=A9duit Collect=C3=A9e ', '4457', =
'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456606', 'TVA 1,75% - DOM - Taux I D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445706', 'TVA 1,75% - DOM - Taux I Collect=C3=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456607', 'TVA 1,05% - DOM - Taux publications de presse D=C3=A9ductib=
le', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445707', 'TVA 1,05% - DOM - Taux publications de presse Collect=C3=A9e=
 ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456608', 'TVA x% - DOM - Taux octroi de mer D=C3=A9ductible', '4456',=
 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445708', 'TVA x% - DOM - Taux octroi de mer Collect=C3=A9e ', '4457', =
'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4456609', 'TVA x% - DOM - Taux immobilisations D=C3=A9ductible', '4456=
', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('445709', 'TVA x% - DOM - Taux immobilisations Collect=C3=A9e ', '4457'=
, 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566010', 'TVA 13% - Corse - Taux I D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457010', 'TVA 13% - Corse - Taux I Collect=C3=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566011', 'TVA 8% - Corse - Taux II D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457011', 'TVA 8% - Corse - Taux II Collect=C3=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566012', 'TVA 2,1% - Corse - Taux III D=C3=A9ductible', '4456', 'ACT=
');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457012', 'TVA 2,1% - Corse - Taux III Collect=C3=A9e ', '4457', 'PAS'=
);
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566013', 'TVA 0,9% - Corse - Taux IV D=C3=A9ductible', '4456', 'ACT'=
);
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457013', 'TVA 0,9% - Corse - Taux IV Collect=C3=A9e ', '4457', 'PAS')=
;
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566014', 'TVA x% - Corse - Taux immobilisations D=C3=A9ductible', '4=
456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457014', 'TVA x% - Corse - Taux immobilisations Collect=C3=A9e ', '44=
57', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566015', 'TVA x% - Acquisitions intracommunautaires/Pays D=C3=A9duct=
ible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457015', 'TVA x% - Acquisitions intracommunautaires/Pays Collect=C3=A9=
e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566016', 'TVA x% - Acquisitions intracommunautaires immobilisations/=
Pays D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457016', 'TVA x% - Acquisitions intracommunautaires immobilisations/P=
ays Collect=C3=A9e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566017', 'TVA x% - Non imposable : Achats en franchise D=C3=A9ductib=
le', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457017', 'TVA x% - Non imposable : Achats en franchise Collect=C3=A9e=
 ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566018', 'TVA x% - Non imposable : Exports hors CE/Pays D=C3=A9ducti=
ble', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457018', 'TVA x% - Non imposable : Exports hors CE/Pays Collect=C3=A9=
e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566019', 'TVA x% - Non imposable : Autres op=C3=A9rations D=C3=A9duc=
tible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457019', 'TVA x% - Non imposable : Autres op=C3=A9rations Collect=C3=A9=
e ', '4457', 'PAS');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('44566020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pa=
ys D=C3=A9ductible', '4456', 'ACT');
+INSERT INTO tmp_pcmn (pcm_val, pcm_lib, pcm_val_parent, pcm_type) VALUES=
 ('4457020', 'TVA x% - Non imposable : Livraisons intracommunautaires/Pay=
s Collect=C3=A9e ', '4457', 'PAS');
+
+
+
+
+
+
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (101, 'FR_NOR', 0.1960, 'TVA 19,6% - France m=C3=A9tropolitaine=
 - Taux normal', '445661,44571');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (102, 'FR_RED', 0.0550, 'TVA 5,5% - France m=C3=A9tropolitaine =
- Taux r=C3=A9duit', '445662,44572');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (103, 'FR_SRED', 0.0210, 'TVA 2,1% - France m=C3=A9tropolitaine=
 - Taux super r=C3=A9duit', '445663,44573');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (104, 'FR_IMMO', 0.1960, 'TVA 19,6% - France m=C3=A9tropolitain=
e - Taux immobilisations', '4456601,445701');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (105, 'FR_ANC', 0.0000, 'TVA x% - France m=C3=A9tropolitaine - =
Taux anciens', '4456602,445702');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (201, 'DOM', 0.0850, 'TVA 8,5%  - DOM - Taux normal', '4456603,=
445703');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (202, 'DOM_NPR', 0.0850, 'TVA 8,5% - DOM - Taux normal NPR', '4=
456604,445704');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (203, 'DOM_REDUIT', 0.0210, 'TVA 2,1% - DOM - Taux r=C3=A9duit'=
, '4456605,445705');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (204, 'DOM_I', 0.0175, 'TVA 1,75% - DOM - Taux I', '4456606,445=
706');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (205, 'DOM_PRESSE', 0.0105, 'TVA 1,05% - DOM - Taux publication=
s de presse', '4456607,445707');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (206, 'DOM_OCTROI', 0.0000, 'TVA x% - DOM - Taux octroi de mer'=
, '4456608,445708');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (207, 'DOM_IMMO', 0.0000, 'TVA x% - DOM - Taux immobilisations'=
, '4456609,445709');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (301, 'COR_I', 0.1300, 'TVA 13% - Corse - Taux I', '44566010,44=
57010');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (302, 'COR_II', 0.0800, 'TVA 8% - Corse - Taux II', '44566011,4=
457011');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (303, 'COR_III', 0.0210, 'TVA 2,1% - Corse - Taux III', '445660=
12,4457012');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (304, 'COR_IV', 0.0090, 'TVA 0,9% - Corse - Taux IV', '44566013=
,4457013');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (305, 'COR_IMMO', 0.0000, 'TVA x% - Corse - Taux immobilisation=
s', '44566014,4457014');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (401, 'INTRA', 0.0000, 'TVA x% - Acquisitions intracommunautair=
es/Pays', '44566015,4457015');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (402, 'INTRA_IMMMO', 0.0000, 'TVA x% - Acquisitions intracommun=
autaires immobilisations/Pays', '44566016,4457016');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (501, 'FRANCH', 0.0000, 'TVA x% - Non imposable : Achats en fra=
nchise', '44566017,4457017');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (502, 'EXPORT', 0.0000, 'TVA x% - Non imposable : Exports hors =
CE/Pays', '44566018,4457018');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (503, 'AUTRE', 0.0000, 'TVA x% - Non imposable : Autres op=C3=A9=
rations', '44566019,4457019');
+INSERT INTO tva_rate (tva_id, tva_label, tva_rate, tva_comment, tva_post=
e) VALUES (504, 'INTRA_LIV', 0.0000, 'TVA x% - Non imposable : Livraisons=
 intracommunautaires/Pays', '44566020,4457020');
+
+
+
+INSERT INTO user_local_pref (user_id, parameter_type, parameter_value) V=
ALUES ('1', 'MINIREPORT', '0');
+INSERT INTO user_local_pref (user_id, parameter_type, parameter_value) V=
ALUES ('1', 'PERIODE', '105');
+
+
+
+
+
+
+
+
+
+
+
+
+INSERT INTO version (val) VALUES (75);
+
+
+



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


From MAILER-DAEMON Thu Nov 29 16:54:30 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1TeC3y-0005om-S8
	for mharc-phpcompta-dev@gnu.org; Thu, 29 Nov 2012 16:54:30 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Thu, 29 Nov 2012 22:44:01 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.898226.1354226070.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r445 - in trunk/rapport_avance: . include
	include/template
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Thu, 29 Nov 2012 21:54:29 -0000

Author: danydb
Date: 2012-11-29 22:44:01 +0100 (Thu, 29 Nov 2012)
New Revision: 445

Modified:
   trunk/rapport_avance/ajax_save_param_detail.php
   trunk/rapport_avance/include/class_formulaire_param.php
   trunk/rapport_avance/include/class_formulaire_param_detail.php
   trunk/rapport_avance/include/class_rapav_declaration.php
   trunk/rapport_avance/include/class_rapport_avance_sql.php
   trunk/rapport_avance/include/template/param_detail_new.php
   trunk/rapport_avance/rapav_javascript.js
Log:
rapport_avance : ajout 4i?\195?\168me formule

Modified: trunk/rapport_avance/ajax_save_param_detail.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/ajax_save_param_detail.php	2012-10-02 17:33:52 U=
TC (rev 444)
+++ trunk/rapport_avance/ajax_save_param_detail.php	2012-11-29 21:44:01 U=
TC (rev 445)
@@ -31,98 +31,125 @@
  */
 require_once 'class_impress.php';
 require_once 'include/class_formulaire_param_detail.php';
-$fp_id=3D0;
-switch($tab)
+$fp_id =3D 0;
+switch ($tab)
 {
 	case 'account_tva':
-		$acc_tva=3Dnew RAPAV_Account_Tva();
-		$acc_tva->tva_id=3D$code_tva;
-		$acc_tva->tmp_val=3D$formtva;
-		$acc_tva->jrn_def_type=3D$code_jrn;
-		$acc_tva->p_id=3D$p_id;
-		$acc_tva->type_detail=3D2;
-		$acc_tva->tt_id=3D$code_base;
+		$acc_tva =3D new RAPAV_Account_Tva();
+		$acc_tva->tva_id =3D $code_tva;
+		$acc_tva->tmp_val =3D $formtva;
+		$acc_tva->jrn_def_type =3D $code_jrn;
+		$acc_tva->p_id =3D $p_id;
+		$acc_tva->type_detail =3D 2;
+		$acc_tva->tt_id =3D $code_base;
 		if ($acc_tva->verify() =3D=3D 1)
 		{
-			$code=3D'nok';
-			$html=3D"Erreur dans la formule ".$acc_tva->errcode;
+			$code =3D 'nok';
+			$html =3D "Erreur dans la formule " . $acc_tva->errcode;
 		}
 		else
 		{
 			$acc_tva->insert();
-			$code=3D'ok';
-			$fp_id=3D$acc_tva->fp_id;
-			$html=3D'<td>';
+			$code =3D 'ok';
+			$fp_id =3D $acc_tva->fp_id;
+			$html =3D '<td>';
 			ob_start();
 			$acc_tva->display_row();
 			$html.=3Dob_get_contents();
 			ob_end_clean();
 			$html.=3D '</td>';
-			$html.=3D'<td id=3D"del_'.$acc_tva->fp_id.'">';
-			$html.=3DHtmlInput::anchor("Effacer","",sprintf("onclick=3D\"delete_p=
aram_detail('%s','%s','%s','%s')\""
-					, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossier'],=
 $acc_tva->fp_id));
+			$html.=3D'<td id=3D"del_' . $acc_tva->fp_id . '">';
+			$html.=3DHtmlInput::anchor("Effacer", "", sprintf("onclick=3D\"delete=
_param_detail('%s','%s','%s','%s')\""
+									, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossie=
r'], $acc_tva->fp_id));
 			$html.=3D '</td>';
 		}
 		break;
 	case 'formula':
-		$acc_formula=3Dnew RAPAV_Formula();
-		$acc_formula->fp_formula=3D$formula_new;
-		$acc_formula->p_id=3D$p_id;
-		$acc_formula->type_detail=3D1;
+		$acc_formula =3D new RAPAV_Formula();
+		$acc_formula->fp_formula =3D $formula_new;
+		$acc_formula->p_id =3D $p_id;
+		$acc_formula->type_detail =3D 1;
 		if ($acc_formula->verify() =3D=3D 1)
 		{
-			$code=3D'nok';
-			$html=3D$acc_formula->errcode;
+			$code =3D 'nok';
+			$html =3D $acc_formula->errcode;
 		}
 		else
 		{
 			$acc_formula->insert();
-			$fp_id=3D$acc_formula->fp_id;
-			$code=3D'ok';
-			$html=3D'<td>';
+			$fp_id =3D $acc_formula->fp_id;
+			$code =3D 'ok';
+			$html =3D '<td>';
 			ob_start();
 			$acc_formula->display_row();
 			$html.=3Dob_get_contents();
 			ob_end_clean();
 			$html.=3D '</td>';
-			$html.=3D'<td id=3D"del_'.$acc_formula->fp_id.'">';
-			$html.=3DHtmlInput::anchor("Effacer","",sprintf("onclick=3D\"delete_p=
aram_detail('%s','%s','%s','%s')\""
-				, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossier'], =
$acc_formula->fp_id));
+			$html.=3D'<td id=3D"del_' . $acc_formula->fp_id . '">';
+			$html.=3DHtmlInput::anchor("Effacer", "", sprintf("onclick=3D\"delete=
_param_detail('%s','%s','%s','%s')\""
+									, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossie=
r'], $acc_formula->fp_id));
 			$html.=3D'</td>';
-
 		}
 		break;
 	case 'compute_id':
-		$acc_compute=3Dnew RAPAV_Compute();
-		$acc_compute->fp_formula=3D$form_compute;
-		$acc_compute->p_id=3D$p_id;
-		$acc_compute->type_detail=3D3;
+		$acc_compute =3D new RAPAV_Compute();
+		$acc_compute->fp_formula =3D $form_compute;
+		$acc_compute->p_id =3D $p_id;
+		$acc_compute->type_detail =3D 3;
 		if ($acc_compute->verify() =3D=3D 1)
 		{
-			$code=3D'nok';
-			$html=3D$acc_compute->errcode;
+			$code =3D 'nok';
+			$html =3D $acc_compute->errcode;
 		}
 		else
 		{
 			$acc_compute->insert();
-			$fp_id=3D$acc_compute->fp_id;
-			$code=3D'ok';
-			$html=3D'<td>';
+			$fp_id =3D $acc_compute->fp_id;
+			$code =3D 'ok';
+			$html =3D '<td>';
 			ob_start();
 			$acc_compute->display_row();
 			$html.=3Dob_get_contents();
 			ob_end_clean();
 			$html.=3D '</td>';
-			$html.=3D'<td id=3D"del_'.$acc_compute->fp_id.'">';
-			$html.=3DHtmlInput::anchor("Effacer","",sprintf("onclick=3D\"delete_p=
aram_detail('%s','%s','%s','%s')\""
-					, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossier'],=
 $acc_compute->fp_id));
+			$html.=3D'<td id=3D"del_' . $acc_compute->fp_id . '">';
+			$html.=3DHtmlInput::anchor("Effacer", "", sprintf("onclick=3D\"delete=
_param_detail('%s','%s','%s','%s')\""
+									, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossie=
r'], $acc_compute->fp_id));
 			$html.=3D'</td>';
-
 		}
 		break;
+	case 'new_account_id':
+		$acc_account =3D new RAPAV_Account();
+		$acc_account->tmp_val =3D $account_first;
+		$acc_account->with_tmp_val =3D $account_second;
+		$acc_account->p_id =3D $p_id;
+		$acc_account->type_detail =3D 4;
+		$acc_account->type_sum_account=3D $account_sum_type;
+		if ($acc_account->verify() =3D=3D 1)
+		{
+			$code =3D 'nok';
+			$html =3D $acc_account->errcode;
+		}
+		else
+		{
+			$acc_account->insert();
+			$fp_id =3D $acc_account->fp_id;
+			$code =3D 'ok';
+			$html =3D '<td>';
+			ob_start();
+			$acc_account->display_row();
+			$html.=3Dob_get_contents();
+			ob_end_clean();
+			$html.=3D '</td>';
+			$html.=3D'<td id=3D"del_' . $acc_account->fp_id . '">';
+			$html.=3DHtmlInput::anchor("Effacer", "", sprintf("onclick=3D\"delete=
_param_detail('%s','%s','%s','%s')\""
+									, $_REQUEST['plugin_code'], $_REQUEST['ac'], $_REQUEST['gDossie=
r'], $acc_account->fp_id));
+			$html.=3D'</td>';
+		}
+		break;
 }
 //echo $html;exit();
-$html=3Descape_xml($html);
+$html =3D escape_xml($html);
=20
 header('Content-type: text/xml; charset=3DUTF-8');
 echo <<<EOF

Modified: trunk/rapport_avance/include/class_formulaire_param.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/include/class_formulaire_param.php	2012-10-02 17=
:33:52 UTC (rev 444)
+++ trunk/rapport_avance/include/class_formulaire_param.php	2012-11-29 21=
:44:01 UTC (rev 445)
@@ -185,6 +185,9 @@
 			case '3':
 				return new RAPAV_Compute($this->parametre[$p_index]['fp_id']);
 				break;
+			case '4':
+				return new RAPAV_Account($this->parametre[$p_index]['fp_id']);
+				break;
 		}
 	}
 	/**
@@ -196,7 +199,7 @@
 		echo HtmlInput::hidden('p_id[]', $this->obj->p_id);
 		$max =3D count($this->parametre);
 		echo HtmlInput::hidden("count_" . $this->id, $max);
-		echo '<h5 class=3D"title">' . 'code ' . $this->obj->p_code . '</h5>';
+		//echo '<h5 class=3D"title">' . 'code ' . $this->obj->p_code . '</h5>'=
;
 		echo '<p>';
 		echo '<table id=3D"table_' . $this->id . '">';
 		for ($i =3D 0; $i < $max; $i++)

Modified: trunk/rapport_avance/include/class_formulaire_param_detail.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/include/class_formulaire_param_detail.php	2012-1=
0-02 17:33:52 UTC (rev 444)
+++ trunk/rapport_avance/include/class_formulaire_param_detail.php	2012-1=
1-29 21:44:01 UTC (rev 445)
@@ -35,7 +35,8 @@
 	function input_new($p_id)
 	{
 		$parent =3D new Formulaire_Param($p_id);
-		echo HtmlInput::title_box($parent->p_code . " " . $parent->p_libelle, =
'param_detail_div');
+		echo HtmlInput::title_box('Formule', 'param_detail_div');
+		echo '<h2>'.$parent->p_code . " " . $parent->p_libelle.'</h2>';
 		require_once 'template/param_detail_new.php';
 	}
=20
@@ -190,5 +191,62 @@
 	}
=20
 }
+/**
+ * @TODO poste comptable utilis=C3=A9 avec le poste comptable, choix ent=
re diff cr=C3=A9dit - debit, diff d=C3=A9bit-cr=C3=A9dit, cr=C3=A9dit, d=C3=
=A9bit
+ */
+class RAPAV_Account extends Formulaire_Param_Detail
+{
=20
+	function display_row()
+	{
+		global $cn;
+		$total_type_account=3D$cn->get_value('select tt_label from rapport_adv=
anced.total_type_account where tt_id=3D$1',
+				array($this->type_sum_account));
+		printf("Total %s poste comptable %s utilis=C3=A9 avec le poste comptab=
le %s",
+				$total_type_account,$this->tmp_val,$this->with_tmp_val);
+	}
+
+	static function new_row($p_id)
+	{
+		global $cn;
+		$sum_type=3Dnew ISelect('account_sum_type');
+		$sum_type->value=3D$cn->make_array("select tt_id, tt_label from rappor=
t_advanced.total_type_account ");
+
+		$account =3D new IPoste("account_first", "", "account_first_id");
+		$account->size =3D 10;
+		$account->label =3D _("Recherche poste");
+		$account->set_attribute('gDossier', dossier::id());
+		$account->set_attribute('account', $account->id);
+
+		$account_second =3D new IPoste("account_second", "", "account_second_i=
d");
+		$account_second->size =3D 10;
+		$account_second->label =3D _("Recherche poste");
+		$account_second->set_attribute('gDossier', dossier::id());
+		$account_second->set_attribute('account', $account_second->id);
+		echo '<p>';
+		echo 'Calculer ';
+		echo $sum_type->input();
+		echo '</p>';
+		echo '<p>';
+		echo 'du poste comptable ';
+		echo $account->input();
+		echo '</p>';
+		echo '<p>';
+		echo ' utilis=C3=A9 avec le poste comptable ';
+		echo $account_second->input();
+		echo '</p>';
+	}
+	function verify()
+	{
+
+		if ( trim($this->tmp_val)=3D=3D"" || trim($this->with_tmp_val)=3D=3D""=
)
+		{
+			$this->errcode=3D" Un poste comptable est manquant";
+			return 1;
+		}
+		return 0;
+	}
+
+}
+
 ?>

Modified: trunk/rapport_avance/include/class_rapav_declaration.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/include/class_rapav_declaration.php	2012-10-02 1=
7:33:52 UTC (rev 444)
+++ trunk/rapport_avance/include/class_rapav_declaration.php	2012-11-29 2=
1:44:01 UTC (rev 445)
@@ -249,7 +249,8 @@
 		bcscale(2);
 		$this->amount =3D "0";
=20
-		$array =3D $cn->get_array("select fp_id,p_id,tmp_val,tva_id,fp_formula=
,fp_signed,jrn_def_type,tt_id,type_detail
+		$array =3D $cn->get_array("select fp_id,p_id,tmp_val,tva_id,fp_formula=
,fp_signed,jrn_def_type,tt_id,type_detail,
+			with_tmp_val,type_sum_account
 			from rapport_advanced.formulaire_param_detail where p_id=3D$1", array=
($this->param->p_id));
 		$this->compute_date($p_start, $p_end);
 		for ($e =3D 0; $e < count($array); $e++)
@@ -290,6 +291,9 @@
 			case '3':
 				$ret =3D new Rapav_dd_Compute();
 				break;
+			case '4':
+				$ret =3D new Rapav_dd_Account();
+				break;
 			default:
 				throw new Exception("Type inconnu");
 		}
@@ -307,7 +311,7 @@
 	function from_array($p_array)
 	{
 		$this->form =3D new Formulaire_Param_Detail();
-		$attribute =3D explode(',', 'fp_id,p_id,tmp_val,tva_id,fp_formula,fp_s=
igned,jrn_def_type,tt_id,type_detail');
+		$attribute =3D explode(',', 'fp_id,p_id,tmp_val,tva_id,fp_formula,fp_s=
igned,jrn_def_type,tt_id,type_detail,with_tmp_val,type_sum_account');
 		foreach ($attribute as $e)
 		{
 			$this->form->$e =3D $p_array[$e];
@@ -523,4 +527,113 @@
=20
 }
=20
+/**
+ * @brief handle the param_detail type Account
+ * The type_sum_account gives the type of total
+ *   - 0 D-C
+ *   - 1 C-D
+ *   - 2 D
+ *   - 4 C
+ * it uses tmp_val, with_tmp_val and type_sum_account
+ * @see RAPAV_Account
+ */
+class Rapav_dd_Account extends Rapav_Declaration_Detail
+{
+
+	function compute($p_start, $p_end)
+	{
+		global $cn;
+		bcscale(2);
+		switch ($this->form->type_sum_account)
+		{
+			// Saldo
+			case 1:
+			case 2:
+				// Compute D-C
+				$sql =3D "
+						select sum(jrnx_amount)
+						from (
+							select distinct jrn1.j_id,case when jrn1.j_debit =3D 't' then jrn=
1.j_montant else jrn1.j_montant*(-1) end as jrnx_amount
+							from jrnx as jrn1
+							join jrnx as jrn2 on (jrn1.j_grpt=3Djrn2.j_grpt)
+							where
+							jrn1.j_poste like $1
+							and
+							jrn2.j_poste like $2
+							and (jrn1.j_date >=3D to_date($3,'DD.MM.YYYY') and jrn1.j_date <=3D=
 to_date($4,'DD.MM.YYYY'))
+							) as tv_amount
+							 ";
+				$amount=3D$cn->get_value($sql,array(
+					$this->form->tmp_val,
+					$this->form->with_tmp_val,
+					$p_start,
+					$p_end
+					));
+				// if C-D is asked then reverse the result
+				if ($this->form->type_sum_account=3D=3D2) $amount=3Dbcmul($amount,-1=
);
+				break;
+			// Only DEBIT
+			case 3:
+					$sql =3D "
+						select sum(jrnx_amount)
+						from (
+							select distinct jrn1.j_id,jrn1.j_montant as jrnx_amount
+							from jrnx as jrn1
+							join jrnx as jrn2 on (jrn1.j_grpt=3Djrn2.j_grpt)
+							where
+							jrn1.j_poste like $1
+							and
+							jrn2.j_poste like $2
+							and
+							jrn1.j_debit=3D't'
+							and
+							(jrn1.j_date >=3D to_date($3,'DD.MM.YYYY') and jrn1.j_date <=3D t=
o_date($4,'DD.MM.YYYY'))
+							) as tv_amount
+							 ";
+				$amount=3D$cn->get_value($sql,array(
+					$this->form->tmp_val,
+					$this->form->with_tmp_val,
+					$p_start,
+					$p_end
+					));
+				break;
+			// Only CREDIT
+			case 4:
+					$sql =3D "
+						select sum(jrnx_amount)
+						from (
+							select distinct jrn1.j_id,jrn1.j_montant as jrnx_amount
+							from jrnx as jrn1
+							join jrnx as jrn2 on (jrn1.j_grpt=3Djrn2.j_grpt)
+							where
+							jrn1.j_poste like $1
+							and
+							jrn2.j_poste like $2
+							and
+							jrn1.j_debit=3D'f'
+							and
+							(jrn1.j_date >=3D to_date($3,'DD.MM.YYYY') and jrn1.j_date <=3D t=
o_date($4,'DD.MM.YYYY'))
+							) as tv_amount
+							 ";
+				$amount=3D$cn->get_value($sql,array(
+					$this->form->tmp_val,
+					$this->form->with_tmp_val,
+					$p_start,
+					$p_end
+					));
+				break;
+
+			default:
+				if ( DEBUG) var_dump($this);
+				die (__FILE__.":".__LINE__." UNKNOW SUM TYPE");
+				break;
+		}
+		/*
+		 * 4 possibilities with type_sum_account
+		 */
+		return $amount;
+	}
+
+}
+
 ?>

Modified: trunk/rapport_avance/include/class_rapport_avance_sql.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/include/class_rapport_avance_sql.php	2012-10-02 =
17:33:52 UTC (rev 444)
+++ trunk/rapport_avance/include/class_rapport_avance_sql.php	2012-11-29 =
21:44:01 UTC (rev 445)
@@ -118,7 +118,9 @@
 			"fp_signed"=3D>"fp_signed",
 			"jrn_def_type"=3D>"jrn_def_type",
 			"tt_id"=3D>"tt_id",
-			"type_detail"=3D>"type_detail"
+			"type_detail"=3D>"type_detail",
+			"with_tmp_val"=3D>"with_tmp_val",
+			"type_sum_account"=3D>"type_sum_account"
 		);
=20
 		$this->type =3D array(
@@ -130,7 +132,10 @@
 			"fp_signed"=3D>"numeric",
 			"jrn_def_type"=3D>"text",
 			"tt_id"=3D>"numeric",
-			"type_detail"=3D>"numeric"
+			"type_detail"=3D>"numeric",
+			"with_tmp_val"=3D>"text",
+			"type_sum_account"=3D>"numeric"
+
 		);
=20
 		$this->default =3D array(

Modified: trunk/rapport_avance/include/template/param_detail_new.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/include/template/param_detail_new.php	2012-10-02=
 17:33:52 UTC (rev 444)
+++ trunk/rapport_avance/include/template/param_detail_new.php	2012-11-29=
 21:44:01 UTC (rev 445)
@@ -47,6 +47,11 @@
 			Poste comptable et code TVA
 		</a>
 	</td>
+	<td id=3D"new_account_id_bt"  class=3D"tool" style=3D"background:inheri=
t">
+		<a class=3D"mtitle" href=3D"javascript:void(0)"   onclick=3D"show_type=
_formula('new_account_id')">
+			Poste comptable
+		</a>
+	</td>
 </tr>
 </table>
 <div style=3D"width:100%;height:290px;margin:1px">
@@ -95,4 +100,15 @@
=20
 </form>
 </div>
+	<div id=3D"new_account_id" style=3D"display: none">
+<form id=3D"new_paded" method=3D"POST" onsubmit=3D"save_param_detail('ne=
w_paded');return false">
+
+	<?=3DHtmlInput::request_to_hidden(array('gDossier','ac','plugin_code','=
p_id'))?>
+
+	<?=3DHtmlInput::hidden('tab','new_account_id')?>
+		<?=3DRAPAV_Account::new_row($p_id)?>
+<?=3DHtmlInput::submit('save','Sauve')?>
+
+</form>
+</div>
 </div>
\ No newline at end of file

Modified: trunk/rapport_avance/rapav_javascript.js
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- trunk/rapport_avance/rapav_javascript.js	2012-10-02 17:33:52 UTC (rev=
 444)
+++ trunk/rapport_avance/rapav_javascript.js	2012-11-29 21:44:01 UTC (rev=
 445)
@@ -214,7 +214,7 @@
 {
 	try
 	{
-		var div=3D['new_account_tva_id','new_formula_id','new_compute_id'];
+		var div=3D['new_account_tva_id','new_formula_id','new_compute_id','new=
_account_id'];
 		for (var r =3D0;r<div.length;r++ ) {
 			$(div[r]).hide();
 			$(div[r]+'_bt').style.backgroundColor=3D"inherit";



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


From MAILER-DAEMON Thu Nov 29 17:28:00 2012
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1TeCaO-00035v-OY
	for mharc-phpcompta-dev@gnu.org; Thu, 29 Nov 2012 17:28:00 -0500
To: phpcompta-dev@nongnu.org
Content-Type: text/plain; charset=UTF-8
Date: Thu, 29 Nov 2012 23:17:33 +0100 (CET)
Content-Transfer-Encoding: quoted-printable
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x
X-Received-From: 91.121.80.190
Message-ID: <mailman.898292.1354228080.854.phpcompta-dev@nongnu.org>
From: phpcompta-dev@nongnu.org
Subject: [Phpcompta-dev] r5156 - in phpcompta/tags/rel650: html/js include
	sql
X-BeenThere: phpcompta-dev@nongnu.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: phpcompta-dev@nongnu.org
List-Id: <phpcompta-dev.nongnu.org>
List-Unsubscribe: <https://lists.nongnu.org/mailman/options/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=unsubscribe>
List-Archive: <http://lists.nongnu.org/archive/html/phpcompta-dev>
List-Post: <mailto:phpcompta-dev@nongnu.org>
List-Help: <mailto:phpcompta-dev-request@nongnu.org?subject=help>
List-Subscribe: <https://lists.nongnu.org/mailman/listinfo/phpcompta-dev>,
	<mailto:phpcompta-dev-request@nongnu.org?subject=subscribe>
X-List-Received-Date: Thu, 29 Nov 2012 22:27:59 -0000

Author: danydb
Date: 2012-11-29 23:17:33 +0100 (Thu, 29 Nov 2012)
New Revision: 5156

Modified:
   phpcompta/tags/rel650/html/js/infobulle.js
   phpcompta/tags/rel650/include/class_acc_compute.php
   phpcompta/tags/rel650/include/class_fiche.php
   phpcompta/tags/rel650/sql/upgrade.sql
Log:
#738: Attribut en pourcent doit ?\195?\170tre compris entre 0 et 100 au l=
ieu de 0 et 1

Modified: phpcompta/tags/rel650/html/js/infobulle.js
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/html/js/infobulle.js	2012-11-22 20:50:27 UTC (r=
ev 5155)
+++ phpcompta/tags/rel650/html/js/infobulle.js	2012-11-29 22:17:33 UTC (r=
ev 5156)
@@ -45,9 +45,10 @@
 content[15]=3D"Laissez =C3=A0 0 pour ne rien changer";
 content[16]=3D"Vous devez donner la date par op=C3=A9ration";
 content[17]=3D"Cliquez sur le titre d'une colonne pour trier";
-content[18]=3D"Donner une partie du nom, pr=C3=A9nom, de la description,=
 du poste comptable, du n=C2=B0 de TVA ou quick code";
-content[19]=3D"Donner une partie du nom, de la description,  du n=C2=B0 =
de TVA ou quick code";
+content[18]=3D"Donnez une partie du nom, pr=C3=A9nom, de la description,=
 du poste comptable, du n=C2=B0 de TVA ou quick code";
+content[19]=3D"Donnez une partie du nom, de la description,  du n=C2=B0 =
de TVA ou quick code";
 content[20]=3D"Les menus ne peuvent d=C3=A9pendre que dans d'un menu pri=
ncipal ou d'un menu, si cette liste est vide, ajouter des modules ou menu=
 principal sans donner de d=C3=A9pendance";
+content[21]=3D"Donnez un nombre entre 0 & 100";
 function showBulle(p_ctl)
 {
     d=3Ddocument.getElementById('bulle');

Modified: phpcompta/tags/rel650/include/class_acc_compute.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/class_acc_compute.php	2012-11-22 20:50:=
27 UTC (rev 5155)
+++ phpcompta/tags/rel650/include/class_acc_compute.php	2012-11-29 22:17:=
33 UTC (rev 5156)
@@ -49,7 +49,7 @@
 		  'nd_vat_rate'=3D>'nd_vat_rate',
 		  'amount_perso'=3D>'amount_perso',
 		  'amount_perso_rate'=3D>'amount_perso_rate'				  );
-=20
+
  */
=20
=20
@@ -126,9 +126,11 @@
         if ( $this->check && $this->order > 2 )  throw new Exception ('O=
RDER NOT RESPECTED');
=20
         $this->amount_nd=3Dbcmul($this->amount,$this->amount_nd_rate);
+        $this->amount_nd=3Dbcdiv($this->amount_nd,100);
         $this->amount_nd=3Dround($this->amount_nd,2);
         // the nd part for the vat
         $nd_vat=3Dbcmul($this->amount_vat,$this->amount_nd_rate);
+        $nd_vat=3Dbcdiv($nd_vat,100);
         $nd_vat=3Dround($nd_vat,2);
=20
     }
@@ -139,6 +141,7 @@
=20
         if ($this->amount_vat =3D=3D 0 ) $this->compute_vat();
         $this->nd_vat=3Dbcmul($this->amount_vat,$this->nd_vat_rate);
+        $this->nd_vat=3Dbcdiv($this->nd_vat,100);
         $this->nd_vat=3Dround($this->nd_vat,2);
     }
=20
@@ -149,6 +152,7 @@
=20
         if ($this->amount_vat =3D=3D 0 ) $this->compute_vat();
         $this->nd_ded_vat=3Dbcmul($this->amount_vat,$this->nd_ded_vat_ra=
te);
+        $this->nd_ded_vat=3Dbcdiv($this->nd_ded_vat,100);
         $this->nd_ded_vat=3Dround($this->nd_ded_vat,2);
     }
=20
@@ -158,6 +162,7 @@
         $this->order=3D2;
         if ( $this->amount =3D=3D 0 ) return;
         $this->amount_perso=3Dbcmul($this->amount,$this->amount_perso_ra=
te);
+        $this->amount_perso=3Dbcdiv($this->amount_perso,100);
         $this->amount_perso=3Dround($this->amount_perso,2);
=20
=20

Modified: phpcompta/tags/rel650/include/class_fiche.php
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/include/class_fiche.php	2012-11-22 20:50:27 UTC=
 (rev 5155)
+++ phpcompta/tags/rel650/include/class_fiche.php	2012-11-29 22:17:33 UTC=
 (rev 5156)
@@ -428,7 +428,7 @@
         foreach ($array as $attr)
         {
             $table=3D0;
-            $msg=3D"";
+            $msg=3D"";$bulle=3D'';
             if ( $attr->ad_id =3D=3D ATTR_DEF_ACCOUNT)
             {
                 $w=3Dnew IPoste("av_text".$attr->ad_id);
@@ -521,8 +521,11 @@
 			$w->table =3D $table;
 			$w->label =3D $attr->ad_text;
 			$w->name =3D "av_text" . $attr->ad_id;
-
-			$r.=3D"<TR>" . td($w->label, ' class=3D"input_text" ') . td($w->input=
()." $msg")." </TR>";
+			if ($attr->ad_id =3D=3D 21 || $attr->ad_id=3D=3D22||$attr->ad_id=3D=3D=
20||$attr->ad_id=3D=3D31)
+			{
+				$bulle=3DHtmlInput::infobulle(21);
+			}
+			$r.=3D"<TR>" . td($w->label." $bulle", ' class=3D"input_text" ') . td=
($w->input()." $msg")." </TR>";
 		}
 		$r.=3D '</table>';
         return $r;
@@ -690,7 +693,10 @@
 			$w->name =3D "av_text" . $r->ad_id;
 			$w->readOnly =3D $p_readonly;
=20
-
+			if ($r->ad_id =3D=3D 21 || $r->ad_id=3D=3D22||$r->ad_id=3D=3D20||$r->=
ad_id=3D=3D31)
+			{
+				$bulle=3DHtmlInput::infobulle(21);
+			}
 			$ret.=3D"<TR>" . td($r->ad_text . $bulle) . td($w->input()." ". $msg)=
 . " </TR>";
 		}
=20

Modified: phpcompta/tags/rel650/sql/upgrade.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- phpcompta/tags/rel650/sql/upgrade.sql	2012-11-22 20:50:27 UTC (rev 51=
55)
+++ phpcompta/tags/rel650/sql/upgrade.sql	2012-11-29 22:17:33 UTC (rev 51=
56)
@@ -0,0 +1,33 @@
+CREATE OR REPLACE FUNCTION comptaproc.format_account(p_account account_t=
ype)
+  RETURNS account_type AS
+$BODY$
+
+declare
+
+sResult account_type;
+
+begin
+sResult :=3D lower(p_account);
+
+sResult :=3D translate(sResult,E'=C3=A9=C3=A8=C3=AA=C3=AB=C3=A0=C3=A2=C3=
=A4=C3=AF=C3=AE=C3=BC=C3=BB=C3=B9=C3=B6=C3=B4=C3=A7','eeeeaaaiiuuuooc');
+sResult :=3D translate(sResult,E' $=E2=82=AC=C2=B5=C2=A3%.+-/\\!(){}(),;=
_&|"#''^<>*','');
+
+return upper(sResult);
+
+end;
+$BODY$
+  LANGUAGE plpgsql ;
+
+COMMENT ON FUNCTION comptaproc.format_account(account_type) IS 'format t=
he accounting :
+- upper case
+- remove space and special char.
+';
+
+update tmp_pcmn  set pcm_val_parent  =3D '62' where pcm_val=3D'6202';
+
+update fiche_detail set ad_value =3D to_number(ad_value,'9.99')*100 wher=
e ad_id in  (21,22,20,31) and ad_value is not null and ad_value <> '';
+
+update menu_ref set me_code=3D'ACHISTO' WHERE me_code=3D'ACHIMP';
+update menu_ref set me_code=3D'VEHISTO' WHERE me_code=3D'VENIMP';
+update menu_ref set me_code=3D'FIHISTO' WHERE me_code=3D'FIMP';
+update menu_ref set me_code=3D'ODHISTO' WHERE me_code=3D'ODSIMP';



---
PhpCompta est un logiciel de comptabilit=C3=A9 libre en ligne (full web)
Projet opensource http://www.phpcompta.eu


