OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Compare Revisions

Regard whitespace Rev 83 → Rev 84

/trunk/OpenConcerto/.classpath
2,7 → 2,6
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
<classpathentry exported="true" kind="lib" path="lib/commons-collections-3.1.jar"/>
<classpathentry exported="true" kind="lib" path="lib/commons-dbutils-1.0.jar"/>
<classpathentry exported="true" kind="lib" path="lib/commons-jxpath-1.3.jar"/>
<classpathentry exported="true" kind="lib" path="lib/commons-logging-1.1.jar"/>
11,7 → 10,6
<classpathentry exported="true" kind="lib" path="lib/ganymed-ssh2-build250.jar"/>
<classpathentry exported="true" kind="lib" path="lib/iText-2.1.5.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jakarta-oro-2.0.8.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jaxen-1.1.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jcommon-1.0.16.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jdom-1.1.1.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jgrapht-0.7.3.jar"/>
21,7 → 19,6
<classpathentry exported="true" kind="lib" path="lib/resolver.jar"/>
<classpathentry exported="true" kind="lib" path="lib/RXTXcomm.jar"/>
<classpathentry exported="true" kind="lib" path="lib/poi-3.8-beta3-20110606.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jsch-0.1.44.jar"/>
<classpathentry kind="lib" path="lib/jcip-annotations.jar"/>
<classpathentry kind="lib" path="lib/fb-annotations-2.0.0.jar"/>
<classpathentry exported="true" kind="lib" path="lib/commons-dbcp-1.4.jar"/>
30,7 → 27,13
<classpathentry kind="lib" path="lib/h2-1.3.175.jar"/>
<classpathentry kind="lib" path="lib/icu4j-51_2-data-western_europe.jar"/>
<classpathentry kind="lib" path="lib/icu4j-51_2-module_format.jar"/>
<classpathentry kind="lib" path="lib/jOpenDocument-1.3.jar"/>
<classpathentry kind="lib" path="lib/xercesImpl-2.9.1.jar"/>
<classpathentry kind="lib" path="lib/commons-collections-3.2.1.jar"/>
<classpathentry kind="lib" path="lib/h2-1.3.175-triggerSource.jar"/>
<classpathentry kind="lib" path="lib/jaxen-1.1.6.jar"/>
<classpathentry kind="lib" path="lib/jdom-2.0.5.jar"/>
<classpathentry exported="true" kind="lib" path="lib/jOpenDocument-1.4rc2.jar"/>
<classpathentry kind="lib" path="lib/jsch-0.1.51.jar"/>
<classpathentry kind="lib" path="lib/msv-20090415.jar"/>
<classpathentry kind="output" path="bin"/>
</classpath>
/trunk/OpenConcerto/lib/commons-collections-3.1.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jaxen-1.1.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jsch-0.1.44.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jOpenDocument-1.3.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jOpenDocument-1.4rc2.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jOpenDocument-1.4rc2.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/lib/h2-1.3.175-triggerSource.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/h2-1.3.175-triggerSource.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/lib/commons-collections-3.2.1.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/commons-collections-3.2.1.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/lib/jdom-2.0.5.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jdom-2.0.5.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/lib/jaxen-1.1.6.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jaxen-1.1.6.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/lib/jsch-0.1.51.jar
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/lib/jsch-0.1.51.jar
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/Configuration/Template/Default/ListeDebiteur.odsp
New file
0,0 → 1,9
<odsp>
<spliteveryrow>
<sheet number="0">35</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
 
 
</odsp>
/trunk/OpenConcerto/Configuration/Template/Default/ReleveCheque.xml
1,5 → 1,4
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<element location="H1" type="Value" ValueName="DATE_DEPOT">
11,30 → 10,29
<element location="K56" type="Value" ValueName="TOTAL">
</element>
 
<table firstLine="4" endLine="42" endPageLine="47" lastColumn="L" base="Societe" table="CHEQUE_A_ENCAISSER">
<table firstLine="4" endLine="42" endPageLine="47" lastColumn="L" table="CHEQUE_A_ENCAISSER">
<element location="A" type="fill">
<field base="Societe" name="BANQUE"/>
<field name="BANQUE" />
</element>
 
<element location="B" type="fill">
<field base="Societe" name="DATE"/>
<field name="DATE" />
</element>
 
<element location="C" type="fill">
<field base="Societe" name="NUMERO"/>
<field name="NUMERO" />
</element>
 
<element location="E" type="fill">
<field base="Societe" name="NOM_CLIENT"/>
<field name="NOM_CLIENT" />
</element>
 
<element location="J" type="fill">
<field base="Societe" name="SOURCE"/>
<field name="SOURCE" />
</element>
 
<element location="K" type="fill">
<field base="Societe" name="MONTANT"/>
<field name="MONTANT" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/Devis.odsp
2,7 → 2,7
 
<spliteveryrow>
<sheet number="0">65</sheet>
<sheet number="0">66</sheet>
 
</spliteveryrow>
/trunk/OpenConcerto/Configuration/Template/Default/Avoir.xml
9,14 → 9,14
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
</field>
</element>
36,97 → 36,84
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
</element>
<element location="B13" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="DATE"/>
<field name="DATE" />
</element>
 
<element location="B16" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
<element location="H11" type="address.customer.invoice.full">
</element>
<element location="H13" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
</field>
</field>
</element>
 
 
<element location="L63" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="MONTANT_HT" type="devise"/>
<field name="MONTANT_HT" type="devise" />
</element>
<element location="L64" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="MONTANT_TVA" type="devise"/>
<field name="MONTANT_TVA" type="devise" />
</element>
<element location="L65" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="MONTANT_TTC" type="devise"/>
<field name="MONTANT_TTC" type="devise" />
</element>
 
<element location="B63" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="ID_MODE_REGLEMENT">
<field base="Societe" table="MODE_REGLEMENT" name="ID_TYPE_REGLEMENT">
<field base="Societe" table="TYPE_REGLEMENT" name="NOM" prefix="Paiement par " valuesExpected="Indéfini"/>
<field name="ID_MODE_REGLEMENT">
<field name="ID_TYPE_REGLEMENT">
<field name="NOM" prefix="Paiement par " valuesExpected="Indéfini" />
</field>
</field>
</element>
 
<element location="B64" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="ID_MODE_REGLEMENT">
<field base="Societe" table="MODE_REGLEMENT" name="AJOURS" prefix="A " suffix=" jours " valuesExpected="0"/>
<field base="Societe" table="MODE_REGLEMENT" name="LENJOUR" prefix="Le " valuesExpected="0" type="jour"/>
<field name="ID_MODE_REGLEMENT">
<field name="AJOURS" prefix="A " suffix=" jours " valuesExpected="0" />
<field name="LENJOUR" prefix="Le " valuesExpected="0" type="jour" />
</field>
</element>
 
<element location="B65" type="fill">
<field base="Societe" table="AVOIR_CLIENT" name="DATE" type="DateEcheance" prefix="Réglement de cette facture au plus tard le " valuesExpected=" "/>
<field name="DATE" type="DateEcheance" prefix="Réglement de cette facture au plus tard le " valuesExpected=" " />
</element>
<table endPageLine="65" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1" lastColumn="K" base="Societe" table="AVOIR_CLIENT_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="AVOIR_CLIENT_ELEMENT" name="NOM"/>
<table endPageLine="66" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1" lastColumn="K" base="Societe"
table="AVOIR_CLIENT_ELEMENT">
<element location="B" type="fill" cellSize="60">
<field name="NOM" />
</element>
 
<element location="I" type="fill" blankOnStyle="Normal">
<field base="Societe" table="AVOIR_CLIENT_ELEMENT" name="PV_HT" valuesExpected="0" type="devise"/>
<element location="I" type="fill">
<field name="PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
 
<element location="J" type="fill" blankOnStyle="Normal">
<field base="Societe" table="AVOIR_CLIENT_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
<element location="J" type="supplychain.element.qtyunit.short">
</element>
<element location="K" type="fill" blankOnStyle="Normal">
<field base="Societe" table="AVOIR_CLIENT_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0" />
<element location="K" type="fill">
<field name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0.000000">
<field table="TAXE" name="TAUX" op="/" number="100.0" />
</field>
</element>
 
<element location="L" type="fill" blankOnStyle="Normal">
<field base="Societe" table="AVOIR_CLIENT_ELEMENT" valuesExpected="0" name="T_PV_HT" type="devise"/>
<element location="L" type="fill">
<field name="T_PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/Journaux.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">70</sheet>
<sheet number="0">68</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/GrandLivre.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/ListeFacture.xml
1,38 → 1,35
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<table firstLine="6" endLine="34" endPageLine="34" lastColumn="P" base="Societe" table="SAISIE_VENTE_FACTURE">
<table firstLine="6" endLine="34" endPageLine="34" lastColumn="P" table="SAISIE_VENTE_FACTURE">
<element location="A" type="fill">
<field base="Societe" name="DATE"/>
<field name="DATE" />
</element>
<element location="B" type="fill">
<field base="Societe" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="D" type="fill">
<field base="Societe" name="NUMERO_AFFAIRE"/>
<field name="NUMERO_AFFAIRE" />
</element>
<element location="G" type="fill">
<field base="Societe" name="MONTANT_TTC"/>
<field name="MONTANT_TTC" />
</element>
<element location="H" type="fill">
<field base="Societe" name="MONTANT_HT"/>
<field name="MONTANT_HT" />
</element>
<element location="K" type="fill">
<field base="Societe" name="CLIENT"/>
<field name="CLIENT" />
</element>
<element location="L" type="fill">
<field base="Societe" name="NOM_AFFAIRE"/>
<field name="NOM_AFFAIRE" />
</element>
<element location="M" type="fill">
<field base="Societe" name="DATE_ECHEANCE"/>
<field name="DATE_ECHEANCE" />
</element>
<element location="N" type="fill">
<field base="Societe" name="TYPE_REGLEMENT"/>
<field name="TYPE_REGLEMENT" />
</element>
<element location="P" type="fill">
<field base="Societe" name="INFOS"/>
<field name="INFOS" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/VenteFactureSituation.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">65</sheet>
<sheet number="0">66</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/ListeDebiteur.xml
New file
0,0 → 1,29
<?xml version="1.0" encoding="UTF-8" ?>
<contentDocument>
<table firstLine="2" endLine="36" endPageLine="36" lastColumn="P" table="ECHEANCE_CLIENT">
<element location="A" type="fill">
<field name="NUMERO_FACTURE" />
</element>
<element location="B" type="fill">
<field name="REFERENCE" />
</element>
<element location="C" type="fill">
<field name="DATE" />
</element>
<element location="D" type="fill">
<field name="CODE_CLIENT" />
</element>
<element location="E" type="fill">
<field name="NOM_CLIENT" />
</element>
<element location="F" type="fill">
<field name="TELEPHONE" />
</element>
<element location="G" type="fill">
<field name="MODE_REGLEMENT" />
</element>
<element location="H" type="fill">
<field name="MONTANT" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/Avoir.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/BalanceAgee.xml
New file
0,0 → 1,38
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
 
<table0 firstLine="5" endLine="53" endPageLine="53" lastColumn="F" base="Societe" table="ECRITURE">
<element location="A" type="fill">
<field base="Societe" name="NUMERO"/>
</element>
 
<element location="B" type="fill">
<field base="Societe" name="NOM"/>
</element>
 
 
<element location="C" type="fill">
<field base="Societe" name="30"/>
</element>
 
<element location="D" type="fill">
<field base="Societe" name="60"/>
</element>
 
<element location="E" type="fill">
<field base="Societe" name="90"/>
</element>
 
<element location="F" type="fill">
<field base="Societe" name="+90"/>
</element>
<element location="G" type="fill">
<field base="Societe" name="TOTAL"/>
</element>
</table0>
 
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/JournauxAnalytique.odsp
New file
0,0 → 1,9
<odsp>
<spliteveryrow>
<sheet number="0">68</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
 
 
</odsp>
/trunk/OpenConcerto/Configuration/Template/Default/Commande.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
39,45 → 37,45
<element location="B16" type="fill">
<field base="Societe" table="COMMANDE" name="ID_COMMERCIAL">
<field base="Societe" table="COMMERCIAL" name="NOM"/>
<field name="ID_COMMERCIAL">
<field name="NOM" />
</field>
</element>
 
<element location="B13" type="fill">
<field base="Societe" table="COMMANDE" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="COMMANDE" name="DATE"/>
<field name="DATE" />
</element>
<element location="C16" type="fill">
<field base="Societe" table="COMMANDE" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="TYPE"/>
<field base="Societe" table="FOURNISSEUR" name="NOM"/>
<field name="ID_FOURNISSEUR">
<field name="TYPE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
<field name="ID_FOURNISSEUR">
<field name="ID_ADRESSE">
<field name="RUE" />
</field>
</field>
</element>
<element location="H13" type="fill">
<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE_COMMON" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
<field name="ID_FOURNISSEUR">
<field name="ID_ADRESSE">
<field name="VILLE" type="villeCP" />
<field name="VILLE" type="ville" />
<field name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX" />
</field>
</field>
</element>
84,51 → 82,50
 
 
<element location="L55" type="fill">
<field base="Societe" table="COMMANDE" name="T_HT" type="devise"/>
<field name="T_HT" type="devise" />
</element>
<element location="L56" type="fill">
<field base="Societe" table="COMMANDE" name="T_TVA" type="devise"/>
<field name="T_TVA" type="devise" />
</element>
<element location="L57" type="fill">
<field base="Societe" table="COMMANDE" name="T_TTC" type="devise"/>
<field name="T_TTC" type="devise" />
</element>
 
<table endPageLine="57" firstLine="22" endLine="52" lastColumn="L" base="Societe" table="COMMANDE_ELEMENT">
<table endPageLine="57" firstLine="22" endLine="52" lastColumn="L" table="COMMANDE_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="NOM"/>
<field name="NOM" />
</element>
<element location="G" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="PRIX_METRIQUE_HA_1" type="devise"/>
<field base="Societe" table="COMMANDE_ELEMENT" name="ID_MODE_VENTE_ARTICLE">
<field base="Societe" table="MODE_VENTE_ARTICLE" name="CODE" prefix="€/"/>
<field name="PRIX_METRIQUE_HA_1" type="devise" />
<field name="ID_MODE_VENTE_ARTICLE">
<field name="CODE" prefix="€/" />
</field>
</element>
 
<element location="H" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="PA_HT" type="devise"/>
<field name="PA_HT" type="devise" />
</element>
 
<element location="I" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="QTE"/>
<field name="QTE" />
</element>
<element location="J" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="ID_TAXE">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0"/>
<field name="ID_TAXE">
<field name="TAUX" op="/" number="100.0" />
</field>
</element>
<element location="K" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="T_POIDS"/>
<field name="T_POIDS" />
</element>
<element location="L" type="fill">
<field base="Societe" table="COMMANDE_ELEMENT" name="T_PA_HT" type="devise"/>
<field name="T_PA_HT" type="devise" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/AvoirF.xml
9,15 → 9,15
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" table="ADRESSE_COMMON" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
<field base="Common" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX" />
</field>
</element>
37,54 → 37,49
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
</element>
<element location="B13" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="NUMERO"/>
<field name="NUMERO" />
</element>
 
<element location="C13" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="DATE"/>
<field name="DATE" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="TYPE"/>
<field base="Societe" table="FOURNISSEUR" name="NOM"/>
<field name="ID_FOURNISSEUR">
<field name="TYPE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
<field name="ID_FOURNISSEUR">
<field name="ID_ADRESSE">
<field name="RUE" />
</field>
</field>
</element>
<element location="H13" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="ID_FOURNISSEUR">
<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
<field name="ID_FOURNISSEUR">
<field name="ID_ADRESSE">
<field name="VILLE" type="villeCP" />
<field name="VILLE" type="ville" />
<field name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX" />
</field>
</field>
</element>
 
 
<element location="L54" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="MONTANT_HT" type="devise"/>
<field name="MONTANT_HT" type="devise" />
</element>
<element location="L55" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="MONTANT_TVA" type="devise"/>
<field name="MONTANT_TVA" type="devise" />
</element>
<element location="L56" type="fill">
<field base="Societe" table="AVOIR_FOURNISSEUR" name="MONTANT_TTC" type="devise"/>
<field name="MONTANT_TTC" type="devise" />
</element>
 
 
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/VentilationAnalytique.xml
New file
0,0 → 1,47
<?xml version="1.0" encoding="UTF-8" ?>
<contentDocument>
<element0 location="E69" type="Value" ValueName="TOTAL_DEBIT">
</element0>
 
<element0 location="F69" type="Value" ValueName="TOTAL_CREDIT">
</element0>
 
<element0 location="G69" type="Value" ValueName="TOTAL_SOLDE">
</element0>
 
<element0 location="A1" type="Value" ValueName="TITRE_1">
</element0>
 
<element0 location="A2" type="Value" ValueName="TITRE_2">
</element0>
 
<table0 firstLine="4" endLine="68" endPageLine="69" lastColumn="G" table="ECRITURE" pageRef="F1">
<element location="A" type="fill">
<field name="DATE" />
</element>
 
<element location="B" type="fill">
<field name="CODE_JOURNAL" />
</element>
 
<element location="C" type="fill">
<field name="NUMERO_MOUVEMENT" />
</element>
 
<element location="D" type="fill" maxChar="39">
<field name="LIBELLE" />
</element>
 
<element location="E" type="fill">
<field name="DEBIT" />
</element>
 
<element location="F" type="fill">
<field name="CREDIT" />
</element>
 
<element location="G" type="fill">
<field name="SOLDE" />
</element>
</table0>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/ListeDebiteur.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/ListeDebiteur.ods
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/Configuration/Template/Default/VenteFacture.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
9,14 → 7,14
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
</field>
</element>
36,124 → 34,104
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
</element>
<element location="B13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE"/>
<field name="DATE" />
</element>
 
<element type="invoice_paid_amount" location="L65"/>
 
<element location="B16" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_COMMERCIAL">
<field base="Societe" table="COMMERCIAL" name="PRENOM" type="Initiale" suffix="."/>
<field base="Societe" table="COMMERCIAL" name="NOM"/>
<field name="ID_COMMERCIAL">
<field name="PRENOM" type="Initiale" suffix="." />
<field name="NOM" />
</field>
</element>
 
<element location="C16" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
<element location="H11" type="address.customer.invoice.full">
</element>
<element location="H13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
</field>
</field>
</element>
 
 
<element location="L62" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_HT" type="devise"/>
<field name="T_HT" type="devise" />
</element>
<element location="L65" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_TTC" type="devise"/>
<field name="T_TTC" type="devise" />
</element>
 
<element location="B63" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
 
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement souhaité" conditionField="COMPTANT" conditionExpValue="true" display="false"/>
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Facture acquitée par" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
 
<field base="Societe" table="MODE_REGLEMENT" name="ID_TYPE_REGLEMENT">
<field base="Societe" table="TYPE_REGLEMENT" name="NOM" valuesExpected="Indéfini"/>
<field name="ID_MODE_REGLEMENT">
<field name="NOM" prefix="Règlement souhaité" conditionField="COMPTANT" conditionExpValue="true" display="false" />
<field name="NOM" prefix="Facture acquitée par" conditionField="COMPTANT" conditionExpValue="false" display="false" />
<field name="ID_TYPE_REGLEMENT">
<field name="NOM" valuesExpected="Indéfini" />
</field>
<field base="Societe" table="MODE_REGLEMENT" name="NOM"/>
<field base="Societe" table="MODE_REGLEMENT" name="DATE_VIREMENT" prefix="Le " valuesExpected="" type="Date" datePattern="dd/MM/yy"/>
<field base="Societe" table="MODE_REGLEMENT" name="NUMERO" prefix="N° " valuesExpected=""/>
<field base="Societe" table="MODE_REGLEMENT" name="ETS" prefix="Banque " valuesExpected=""/>
<field name="NOM" />
<field name="DATE_VIREMENT" prefix="Le " valuesExpected="" type="Date" datePattern="dd/MM/yy" />
<field name="NUMERO" prefix="N° " valuesExpected="" />
<field name="ETS" prefix="Banque " valuesExpected="" />
</field>
</element>
 
<element location="B64" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE" type="DateEcheance" prefix="Règlement de cette facture au plus tard le " valuesExpected=" "/>
<field name="DATE" type="DateEcheance" prefix="Règlement de cette facture au plus tard le " valuesExpected=" " />
</element>
 
<element location="B64" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
 
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement à date de réception de facture" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
<field name="ID_MODE_REGLEMENT">
<field name="NOM" prefix="Règlement à date de réception de facture" conditionField="COMPTANT"
conditionExpValue="false" display="false" />
</field>
</element>
 
<table endPageLine="65" firstLine="63" endLine="65" lastColumn="I" base="Societe" table="TVA">
<element location="I" name="NOM" prefix="Total ">
</element>
 
<element location="L" type="Devise" name="MONTANT_TVA">
</element>
 
</table>
 
<table endPageLine="65" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1,Titre 2" lastColumn="K" base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="NOM"/>
<table endPageLine="66" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1,Titre 2" lastColumn="K" base="Societe"
table="SAISIE_VENTE_FACTURE_ELEMENT" pageRef="L16">
<element location="B" type="fill" cellSize="60">
<field name="NOM" />
</element>
 
<element location="I" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="PV_HT" valuesExpected="0" type="devise"/>
<field name="PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
 
<element location="J" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
 
<element location="J" type="supplychain.element.qtyunit.short">
</element>
<element location="K" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0"/>
<field name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0.000000">
<field name="TAUX" op="/" number="100.0" />
</field>
</element>
 
<element location="L" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" valuesExpected="0" name="T_PV_HT" type="devise"/>
<field name="T_PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/BalanceAgee.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/BalanceAgee.ods
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/Configuration/Template/Default/VentilationAnalytique.odsp
New file
0,0 → 1,9
<odsp>
<spliteveryrow>
<sheet number="0">68</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
 
 
</odsp>
/trunk/OpenConcerto/Configuration/Template/Default/JournauxAnalytique.xml
New file
0,0 → 1,47
<?xml version="1.0" encoding="UTF-8" ?>
<contentDocument>
<element0 location="E69" type="Value" ValueName="TOTAL_DEBIT">
</element0>
 
<element0 location="F69" type="Value" ValueName="TOTAL_CREDIT">
</element0>
 
<element0 location="G69" type="Value" ValueName="TOTAL_SOLDE">
</element0>
 
<element0 location="A1" type="Value" ValueName="TITRE_1">
</element0>
 
<element0 location="A2" type="Value" ValueName="TITRE_2">
</element0>
 
<table0 firstLine="4" endLine="68" endPageLine="69" lastColumn="G" table="ECRITURE" pageRef="F1">
<element location="A" type="fill">
<field name="DATE" />
</element>
 
<element location="B" type="fill">
<field name="NUMERO_COMPTE" />
</element>
 
<element location="C" type="fill">
<field name="NUMERO_MOUVEMENT" />
</element>
 
<element location="D" type="fill" maxChar="39">
<field name="LIBELLE" />
</element>
 
<element location="E" type="fill">
<field name="DEBIT" />
</element>
 
<element location="F" type="fill">
<field name="CREDIT" />
</element>
 
<element location="G" type="fill">
<field name="SOLDE" />
</element>
</table0>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/Journaux.xml
New file
0,0 → 1,47
<?xml version="1.0" encoding="UTF-8" ?>
<contentDocument>
<element0 location="E69" type="Value" ValueName="TOTAL_DEBIT">
</element0>
 
<element0 location="F69" type="Value" ValueName="TOTAL_CREDIT">
</element0>
 
<element0 location="G69" type="Value" ValueName="TOTAL_SOLDE">
</element0>
 
<element0 location="A1" type="Value" ValueName="TITRE_1">
</element0>
 
<element0 location="A2" type="Value" ValueName="TITRE_2">
</element0>
 
<table0 firstLine="4" endLine="68" endPageLine="69" lastColumn="G" table="ECRITURE" pageRef="F1">
<element location="A" type="fill">
<field name="DATE" />
</element>
 
<element location="B" type="fill">
<field name="NUMERO_COMPTE" />
</element>
 
<element location="C" type="fill">
<field name="NUMERO_MOUVEMENT" />
</element>
 
<element location="D" type="fill" maxChar="39">
<field name="LIBELLE" />
</element>
 
<element location="E" type="fill">
<field name="DEBIT" />
</element>
 
<element location="F" type="fill">
<field name="CREDIT" />
</element>
 
<element location="G" type="fill">
<field name="SOLDE" />
</element>
</table0>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/FicheClient.xml
1,82 → 1,73
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="C5" type="fill">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE" />
<field base="Societe" table="CLIENT" name="NOM" />
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</element>
 
<element location="C6" type="fill">
<field base="Societe" table="CLIENT" name="NUMERO_TVA" />
<field name="NUMERO_TVA" />
</element>
 
<element location="C7" type="fill">
<field base="Societe" table="CLIENT" name="SIRET" />
<field name="SIRET" />
</element>
 
 
<element location="B9" type="fill">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE" />
<field name="ID_ADRESSE">
<field name="RUE" />
</field>
</element>
 
<element location="B12" type="fill">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP" />
<field base="Societe" table="ADRESSE" name="VILLE" type="ville" />
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX" />
<field name="ID_ADRESSE">
<field name="VILLE" type="villeCP" />
<field name="VILLE" type="ville" />
<field name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX" />
</field>
</element>
 
 
<element location="C16" type="fill">
<field base="Societe" table="CLIENT" name="RESPONSABLE" />
<field name="RESPONSABLE" />
</element>
 
 
<element location="C17" type="fill">
<field base="Societe" table="CLIENT" name="TEL" />
<field name="TEL" />
</element>
 
<element location="C18" type="fill">
<field base="Societe" table="CLIENT" name="TEL_P" />
<field name="TEL_P" />
</element>
 
<element location="C19" type="fill">
<field base="Societe" table="CLIENT" name="FAX" />
<field name="FAX" />
</element>
 
<element location="C20" type="fill">
<field base="Societe" table="CLIENT" name="MAIL" />
<field name="MAIL" />
</element>
 
 
<table endPageLine="56" firstLine="26" endLine="37" lastColumn="K" base="Societe" table="CONTACT">
<table endPageLine="56" firstLine="26" endLine="37" lastColumn="K" table="CONTACT">
<element location="B" type="fill">
<field base="Societe" table="CONTACT" name="ID_TITRE_PERSONNEL">
<field base="Societe" table="TITRE_PERSONNEL" name="NOM"/>
<field name="ID_TITRE_PERSONNEL">
<field name="NOM" />
</field>
</element>
 
 
<element location="C" type="fill">
<field base="Societe" table="CONTACT" name="NOM"/>
<field name="NOM" />
</element>
 
<element location="D" type="fill">
<field base="Societe" table="CONTACT" name="PRENOM"/>
<field name="PRENOM" />
</element>
 
<element location="G" type="fill">
<field base="Societe" table="CONTACT" name="FONCTION"/>
<field name="FONCTION" />
</element>
 
<element location="I" type="fill">
<field base="Societe" table="CONTACT" name="TEL_DIRECT"/>
<field name="TEL_DIRECT" />
</element>
</table>
 
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/VentilationAnalytique.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/VentilationAnalytique.ods
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/Configuration/Template/Default/VenteFacture.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/EtatVentes.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<element0 location="A4" type="Value" ValueName="DATE">
</element0>
 
8,7 → 6,6
<element0 location="G54" type="Value" ValueName="TOTAL_PV_TTC">
</element0>
 
 
<table0 firstLine="7" endLine="51" endPageLine="54" lastColumn="E" base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT">
<element location="A" type="fill">
<field base="Societe" name="NOM"/>
50,14 → 47,11
<field base="Societe" name="QTE"/>
</element>
 
 
<element location="D" type="fill">
<field base="Societe" name="T_PV_TTC"/>
</element>
</table1>
 
 
<element2 location="A4" type="Value" ValueName="DATE">
</element2>
 
73,10 → 67,7
<element2 location="C17" type="Value" ValueName="TOTAL_GLOBAL">
</element2>
 
 
 
<table2 firstLine="8" endLine="13" endPageLine="54" lastColumn="E" base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT">
 
<element location="A" type="fill">
<field base="Societe" name="QTE"/>
</element>
85,10 → 76,8
<field base="Societe" name="NOM"/>
</element>
 
 
<element location="C" type="fill">
<field base="Societe" name="TOTAL"/>
</element>
</table2>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/CommandeClient.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
9,127 → 7,101
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" table="ADRESSE_COMMON" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
</field>
</element>
<element location="B7" type="replace" replacePattern="_">
<field base="Common" table="SOCIETE_COMMON" name="NUM_NII"/>
<field base="Common" name="NUM_NII" />
</element>
<element location="B8" type="replace" replacePattern="_">
<field base="Common" table="SOCIETE_COMMON" name="NUM_TEL"/>
<field base="Common" name="NUM_TEL" />
</element>
<element location="B9" type="replace" replacePattern="_">
<field base="Common" table="SOCIETE_COMMON" name="NUM_FAX"/>
<field base="Common" name="NUM_FAX" />
</element>
<element location="B10" type="replace" replacePattern="_">
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
<field base="Common" name="MAIL" />
</element>
<element location="B16" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="ID_COMMERCIAL">
<field base="Societe" table="COMMERCIAL" name="NOM"/>
<field name="ID_COMMERCIAL">
<field name="PRENOM" type="Initiale" suffix="." />
<field name="NOM" />
</field>
</element>
 
<element location="B13" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="DATE"/>
<field name="DATE" />
</element>
<element location="C16" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<element location="I10" type="fill">
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
</element>
<element location="I11" type="address.customer.full">
<element location="H13" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
</field>
</field>
</element>
 
 
<element location="L54" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="T_HT" type="devise"/>
<element location="L63" type="fill">
<field name="T_HT" type="Devise" />
</element>
<element location="L55" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="T_TVA" type="devise"/>
<element location="L64" type="fill">
<field name="T_TVA" type="Devise" />
</element>
<element location="L56" type="fill">
<field base="Societe" table="COMMANDE_CLIENT" name="T_TTC" type="devise"/>
<element location="L65" type="fill">
<field name="T_TTC" type="Devise" />
</element>
 
<table endPageLine="56" firstLine="21" endLine="51" lastColumn="L" base="Societe" table="COMMANDE_CLIENT_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="NOM"/>
<table endPageLine="66" firstLine="21" endLine="60" lastColumn="L" base="Societe" table="COMMANDE_CLIENT_ELEMENT"
blankLineBeforeStyle="Titre 1" pageRef="L17">
<element location="B" type="fill" cellSize="60">
<field name="NOM" />
</element>
<element location="G" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="QTE"/>
</element>
<element location="H" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="PRIX_METRIQUE_VT_1" type="devise"/>
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="ID_MODE_VENTE_ARTICLE">
<field base="Societe" table="MODE_VENTE_ARTICLE" name="CODE" prefix="€/"/>
<element location="I" type="fill">
<field name="PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
<element location="I" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="PV_HT" type="devise"/>
<element location="J" type="supplychain.element.qtyunit.short">
</element>
<element location="J" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="ID_TAXE">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0"/>
<element location="K" type="fill">
<field name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0.000000">
<field name="TAUX" op="/" number="100.0" />
</field>
</element>
<element location="K" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="T_POIDS"/>
</element>
<element location="L" type="fill">
<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="T_PV_HT" type="devise"/>
<field name="T_PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/VenteFactureSituation.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
36,55 → 34,39
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
</element>
<element location="B13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE"/>
<field name="DATE" />
</element>
 
<element type="invoice_paid_amount" location="L65"/>
 
<element location="B16" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_COMMERCIAL">
<field base="Societe" table="COMMERCIAL" name="PRENOM" type="Initiale" suffix="."/>
<field base="Societe" table="COMMERCIAL" name="NOM"/>
<field name="ID_COMMERCIAL">
<field name="PRENOM" type="Initiale" suffix="." />
<field name="NOM" />
</field>
</element>
 
<element location="C16" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
<element location="H11" type="address.customer.invoice.full">
</element>
<element location="H13" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
</field>
</field>
</element>
<element type="sales.account.label" location="B58" />
 
 
<element type="sales.account.label" location="B58"/>
<element type="sales.account.command.total" location="J58"/>
 
<element location="L58" type="sales.partial.value"/>
92,75 → 74,69
<element type="sales.account.total" location="L61"/>
 
<element location="L62" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_HT" type="devise"/>
<field name="T_HT" type="devise" />
</element>
<element location="L65" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_TTC" type="devise"/>
<field name="T_TTC" type="devise" />
</element>
 
<element location="B63" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
 
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement souhaité" conditionField="COMPTANT" conditionExpValue="true" display="false"/>
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Facture acquitée par" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
 
<field base="Societe" table="MODE_REGLEMENT" name="ID_TYPE_REGLEMENT">
<field base="Societe" table="TYPE_REGLEMENT" name="NOM" valuesExpected="Indéfini"/>
<field name="ID_MODE_REGLEMENT">
<field name="NOM" prefix="Règlement souhaité" conditionField="COMPTANT" conditionExpValue="true" display="false" />
<field name="NOM" prefix="Facture acquitée par" conditionField="COMPTANT" conditionExpValue="false" display="false" />
<field name="ID_TYPE_REGLEMENT">
<field name="NOM" valuesExpected="Indéfini" />
</field>
<field base="Societe" table="MODE_REGLEMENT" name="NOM"/>
<field base="Societe" table="MODE_REGLEMENT" name="DATE_VIREMENT" prefix="Le " valuesExpected="" type="Date" datePattern="dd/MM/yy"/>
<field base="Societe" table="MODE_REGLEMENT" name="NUMERO" prefix="N° " valuesExpected=""/>
<field base="Societe" table="MODE_REGLEMENT" name="ETS" prefix="Banque " valuesExpected=""/>
<field name="NOM" />
<field name="DATE_VIREMENT" prefix="Le " valuesExpected="" type="Date" datePattern="dd/MM/yy" />
<field name="NUMERO" prefix="N° " valuesExpected="" />
<field name="ETS" prefix="Banque " valuesExpected="" />
</field>
</element>
 
<element location="B64" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE" type="DateEcheance" prefix="Règlement de cette facture au plus tard le " valuesExpected=" "/>
<field name="DATE" type="DateEcheance" prefix="Règlement de cette facture au plus tard le " valuesExpected=" " />
</element>
 
<element location="B64" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
 
<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement à date de réception de facture" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
<field name="ID_MODE_REGLEMENT">
<field name="NOM" prefix="Règlement à date de réception de facture" conditionField="COMPTANT"
conditionExpValue="false" display="false" />
</field>
</element>
 
<table endPageLine="65" firstLine="63" endLine="65" lastColumn="I" base="Societe" table="TVA">
<element location="I" name="NOM" prefix="Total ">
</element>
 
<element location="L" type="Devise" name="MONTANT_TVA">
</element>
 
<table endPageLine="65" firstLine="63" endLine="65" lastColumn="I" table="TVA">
<element location="I" name="NOM" prefix="Total " />
<element location="L" type="Devise" name="MONTANT_TVA" />
</table>
 
<table endPageLine="65" firstLine="20" endLine="54" blankLineBeforeStyle="Titre 1,Titre 2" lastColumn="K" base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="NOM"/>
<table endPageLine="66" firstLine="20" endLine="54" blankLineBeforeStyle="Titre 1,Titre 2" lastColumn="K" base="Societe"
table="SAISIE_VENTE_FACTURE_ELEMENT">
<element location="B" type="fill" cellSize="60">
<field name="NOM" />
</element>
 
<element location="I" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="PV_HT" valuesExpected="0" type="devise"/>
</element>
<field name="PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
 
<element location="J" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
</element>
<element location="J" type="supplychain.element.qtyunit.short" />
 
<element location="K" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0"/>
<field name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0.000000">
<field name="TAUX" op="/" number="100.0" />
</field>
</element>
 
 
<element location="L" type="fill">
<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" valuesExpected="0" name="T_PV_HT" type="devise"/>
<field name="T_PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/JournauxAnalytique.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/JournauxAnalytique.ods
New file
Property changes:
Added: svn:mime-type
+application/octet-stream
\ No newline at end of property
/trunk/OpenConcerto/Configuration/Template/Default/Journaux.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/ListeVentes.xml
1,40 → 1,37
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<element location="A3" type="Value" ValueName="DATE">
</element>
 
 
<table firstLine="6" endLine="57" endPageLine="57" lastColumn="F" base="Societe" table="SAISIE_VENTE_FACTURE" groupSousTotalColumn="A">
<table firstLine="6" endLine="57" endPageLine="57" lastColumn="F" table="SAISIE_VENTE_FACTURE"
groupSousTotalColumn="A">
<element location="A" type="fill">
<field base="Societe" name="DATE"/>
<field name="DATE" />
</element>
 
<element location="B" type="fill">
<field base="Societe" name="NUMERO"/>
<field name="NUMERO" />
</element>
 
<element location="C" type="fill" controleMultiline="false">
<field base="Societe" name="CLIENT"/>
<field name="CLIENT" />
</element>
 
<element location="D" type="fill" controleMultiline="false">
<field base="Societe" name="TYPE_REGLEMENT"/>
<field base="Societe" name="DATE_REGLEMENT"/>
<field name="TYPE_REGLEMENT" />
<field name="DATE_REGLEMENT" />
</element>
 
<element location="E" type="fill" sousTotal="true" total="true">
<field base="Societe" name="MONTANT_HT"/>
<field name="MONTANT_HT" />
</element>
 
<element location="F" type="fill" sousTotal="true" total="true">
<field base="Societe" name="MONTANT_TVA"/>
<field name="MONTANT_TVA" />
</element>
<element location="G" type="fill" sousTotal="true" total="true">
<field base="Societe" name="MONTANT_TTC"/>
<field name="MONTANT_TTC" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/BonLivraison.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
9,14 → 7,14
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
</field>
</element>
36,68 → 34,48
<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
</element>
<element location="B13" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="DATE"/>
<field name="DATE" />
</element>
 
<element location="B16" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="NOM"/>
<field name="NOM" />
</element>
<element location="H10" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="H11" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
<element location="H11" type="address.customer.shipment.full">
</element>
<element location="H13" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
</field>
</field>
</element>
 
 
<element location="L63" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON" name="TOTAL_POIDS" valuesExpected="0.0"/>
<field name="TOTAL_POIDS" valuesExpected="0.0" />
</element>
<table endPageLine="65" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1" lastColumn="K" base="Societe" table="BON_DE_LIVRAISON_ELEMENT">
<element location="B" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON_ELEMENT" name="NOM"/>
<table endPageLine="65" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1" lastColumn="K" base="Societe"
table="BON_DE_LIVRAISON_ELEMENT" pageRef="L17">
<element location="B" type="fill" cellSize="82">
<field name="NOM" />
</element>
<element location="J" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON_ELEMENT" name="QTE" valuesExpected="0"/>
<field name="QTE" type="supplychain.element.qtyunit.short" valuesExpected="0" />
</element>
<element location="K" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON_ELEMENT" name="QTE_LIVREE" valuesExpected="0"/>
<field name="QTE_LIVREE" type="supplychain.element.qtyunit.deliver.short" valuesExpected="0" />
</element>
 
<element location="L" type="fill">
<field base="Societe" table="BON_DE_LIVRAISON_ELEMENT" name="T_POIDS_LIVREE" valuesExpected="0.0"/>
<field name="T_POIDS_LIVREE" valuesExpected="0.0" />
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/CommandeClient.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/FicheRelance.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<element location="A6" type="Value" ValueName="CLIENT">
</element>
 
22,6 → 20,4
 
<element location="F12" type="Value" ValueName="DATE_RELANCE">
</element>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/BonLivraison.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">62</sheet>
<sheet number="0">64</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/Devis.xml
1,7 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
 
<element location="B1" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
9,14 → 7,14
 
<element location="B2" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
<field base="Common" name="RUE" />
</field>
</element>
 
<element location="B3" type="fill">
<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
<field base="Common" name="VILLE" type="villeCP" />
<field base="Common" name="VILLE" type="ville" />
</field>
</element>
38,86 → 36,73
<element location="B16" type="fill">
<field base="Societe" table="DEVIS" name="ID_COMMERCIAL">
<field base="Societe" table="COMMERCIAL" name="PRENOM" type="Initiale" suffix="."/>
<field base="Societe" table="COMMERCIAL" name="NOM"/>
<field name="ID_COMMERCIAL">
<field name="PRENOM" type="Initiale" suffix="." />
<field name="NOM" />
</field>
</element>
 
<element location="B13" type="fill">
<field base="Societe" table="DEVIS" name="NUMERO"/>
<field name="NUMERO" />
</element>
<element location="C13" type="fill">
<field base="Societe" table="DEVIS" name="DATE"/>
<field name="DATE" />
</element>
<element location="C16" type="fill">
<field base="Societe" table="DEVIS" name="OBJET"/>
<field name="OBJET" />
</element>
<element location="I10" type="fill">
<field base="Societe" table="DEVIS" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
<field base="Societe" table="CLIENT" name="NOM"/>
<field name="ID_CLIENT">
<field name="FORME_JURIDIQUE" />
<field name="NOM" />
</field>
</element>
<element location="I11" type="fill">
<field base="Societe" table="DEVIS" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="RUE"/>
</field>
</field>
<element location="I11" type="address.customer.full">
</element>
<element location="I13" type="fill">
<field base="Societe" table="DEVIS" name="ID_CLIENT">
<field base="Societe" table="CLIENT" name="ID_ADRESSE">
<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
</field>
</field>
</element>
 
 
<element location="L63" type="fill">
<field base="Societe" table="DEVIS" name="T_HT" type="devise"/>
<field name="T_HT" type="devise" />
</element>
<element location="L64" type="fill">
<field base="Societe" table="DEVIS" name="T_TVA" type="devise"/>
<field name="T_TVA" type="devise" />
</element>
<element location="L65" type="fill">
<field base="Societe" table="DEVIS" name="T_TTC" type="devise"/>
<field name="T_TTC" type="devise" />
</element>
 
<table endPageLine="65" firstLine="21" endLine="60" lastColumn="L" base="Societe" table="DEVIS_ELEMENT" blankLineBeforeStyle="Titre 1">
<element location="B" type="fill">
<field base="Societe" table="DEVIS_ELEMENT" name="NOM"/>
<table endPageLine="66" firstLine="21" endLine="60" lastColumn="L" base="Societe" table="DEVIS_ELEMENT"
blankLineBeforeStyle="Titre 1" pageRef="L17">
<element location="B" type="fill" cellSize="60">
<field name="NOM" />
</element>
<element location="I" type="fill">
<field base="Societe" table="DEVIS_ELEMENT" name="PV_HT" type="devise" valuesExpected="0"/>
 
<field name="PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
<element location="J" type="fill">
<field base="Societe" table="DEVIS_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
<element location="J" type="supplychain.element.qtyunit.short">
</element>
 
<element location="K" type="fill">
<field base="Societe" table="DEVIS_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0" />
<field name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0.000000">
<field table="TAXE" name="TAUX" op="/" number="100.0" />
</field>
</element>
<element location="L" type="fill">
<field base="Societe" table="DEVIS_ELEMENT" name="T_PV_HT" type="devise" valuesExpected="0"/>
<field name="T_PV_HT" type="devise">
<exclude value="0.000000"/>
</field>
</element>
</table>
</contentDocument>
/trunk/OpenConcerto/Configuration/Template/Default/VenteFactureSituation.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/Avoir.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">65</sheet>
<sheet number="0">66</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/CommandeClient.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">56</sheet>
<sheet number="0">65</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/Balance.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">71</sheet>
<sheet number="0">72</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/BonLivraison.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/GrandLivre.xml
1,8 → 1,5
<?xml version="1.0" encoding="UTF-8" ?>
 
<contentDocument>
<element0 location="E69" type="Value" ValueName="TOTAL_DEBIT">
</element0>
 
21,33 → 18,33
<element0 location="F2" type="Value" ValueName="DATE_EDITION">
</element0>
 
<table0 firstLine="4" endLine="68" endPageLine="69" lastColumn="G" base="Societe" table="ECRITURE" pageRef="F1">
<table0 firstLine="4" endLine="68" endPageLine="69" lastColumn="G" table="ECRITURE" pageRef="F1">
<element location="A" type="fill" useOOFormat="false">
<field base="Societe" name="DATE"/>
<field name="DATE" />
</element>
 
<element location="B" type="fill" useOOFormat="false">
<field base="Societe" name="JOURNAL"/>
<field name="JOURNAL" />
</element>
 
 
<element location="C" type="fill" useOOFormat="false">
<field base="Societe" name="MOUVEMENT"/>
<field name="MOUVEMENT" />
</element>
 
<element location="D" type="fill" maxChar="65" useOOFormat="false">
<field base="Societe" name="LIBELLE"/>
<field name="LIBELLE" />
</element>
 
<element location="E" type="fill" useOOFormat="false">
<field base="Societe" name="DEBIT"/>
<field name="DEBIT" />
</element>
 
<element location="F" type="fill" useOOFormat="false">
<field base="Societe" name="CREDIT"/>
<field name="CREDIT" />
</element>
 
<element location="G" type="fill" useOOFormat="false">
<field base="Societe" name="SOLDE"/>
<field name="SOLDE" />
</element>
</table0>
 
/trunk/OpenConcerto/Configuration/Template/Default/Devis.ods
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/trunk/OpenConcerto/Configuration/Template/Default/VenteFacture.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">65</sheet>
<sheet number="0">66</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>
/trunk/OpenConcerto/Configuration/Template/Default/GrandLivre.odsp
1,6 → 1,6
<odsp>
<spliteveryrow>
<sheet number="0">71</sheet>
<sheet number="0">68</sheet>
</spliteveryrow>
<offset x="40" y ="20"/>
<resize percent="85"/>