OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 182 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<?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" />
        </element>

        <element location="B2" type="fill">
                <field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
                        <field base="Common" name="RUE" />
                        <field base="Common" name="VILLE" type="villeCP" />
                        <field base="Common" name="VILLE" type="ville" />
                </field>
        </element>

        <element location="C7" type="fill">
                <field base="Common" table="SOCIETE_COMMON" name="NUMERO_URSSAF" />
        </element>

        <element location="F7" type="fill">
                <field base="Common" table="SOCIETE_COMMON" name="NUM_SIRET" />
        </element>

        <element location="J7" type="fill">
                <field base="Common" table="SOCIETE_COMMON" name="NUM_APE" />
        </element>

        <element location="B5" type="replace" replacePattern="_">
                <field name="ID_SALARIE">
                        <field name="CODE" />
                </field>
        </element>

        <element location="E5" type="replace" replacePattern="_" cellSize="75">
                <field name="ID_SALARIE">
                        <field name="ID_INFOS_SALARIE_PAYE">
                                <field name="ID_CONTRAT_SALARIE">
                                        <field name="NATURE" cellSize="75" />
                                </field>
                        </field>
                </field>
        </element>


        <element location="G2" type="fill">
                <field name="DU" prefix="Paie du " type="date" datePattern="dd/MM/yy" />
                <field name="AU" prefix=" au " type="date" datePattern="dd/MM/yy" />
        </element>

        <element location="D58" type="fill">
                <field name="DU" type="datePaye" />
        </element>

        <element location="G9" type="fill">
                <field name="ID_SALARIE">
                        <field name="PRENOM" />
                        <field name="NOM" />
                </field>
        </element>
        <element location="G10" type="fill">
                <field name="ID_SALARIE">
                        <field name="ID_ETAT_CIVIL">
                                <field name="ID_ADRESSE">
                                        <field name="RUE" />
                                </field>
                        </field>
                </field>
        </element>
        <element location="G12" type="fill">
                <field name="ID_SALARIE">
                        <field name="ID_ETAT_CIVIL">
                                <field name="ID_ADRESSE">
                                        <field name="CODE_POSTAL" />
                                        <field name="VILLE" />
                                </field>
                        </field>
                </field>
        </element>

        <element location="D12" type="fill">
                <field name="ID_VARIABLE_SALARIE">
                        <field name="CONGES_PRIS" />
                </field>
        </element>
        <element location="E12" type="fill">
                <field name="ID_CUMULS_CONGES">
                        <field name="RESTANT" />
                </field>
        </element>
        <element location="F12" type="fill">
                <field name="ID_CUMULS_CONGES">
                        <field name="ACQUIS" type="cumulConges" />
                </field>
        </element>
        <element location="B6" type="replace" replacePattern="_">
                <field name="ID_SALARIE">
                        <field name="ID_ETAT_CIVIL">
                                <field name="NUMERO_SS" />
                        </field>
                </field>
        </element>

        <element location="B3" type="fill">
                <field name="ID_SALARIE">
                        <field name="ID_INFOS_SALARIE_PAYE">
                                <field name="ID_IDCC">
                                        <field name="NOM" prefix="Convention collective : " cellSize="125" />
                                </field>
                        </field>
                </field>
        </element>

        <element location="B9" type="fill">
                <field name="DETAILS_CONGES" />
        </element>

        <element location="G52" type="fill">
                <field name="COT_SAL" />
        </element>
        <element location="H52" type="fill">
                <field name="COT_PAT" />
        </element>


        <element location="H54" type="fill">
                <field name="NET_AVANT_PAS" />
        </element>
        <element location="I55" type="fill">
                <field name="REDUCTION_GVT" />
        </element>

        <element location="E57" type="fill">
                <field name="NET_IMP" />
        </element>
        <element location="F57" type="fill">
                <field name="ID_PAS">
                        <field name="TAUX_PAS" />
                </field>
        </element>
        <element location="I57" type="fill">
                <field name="TOTAL_PAS" />
        </element>




        <element location="I58" type="fill">
                <field name="NET_A_PAYER" />
        </element>

        <element location="D62" type="fill">
                <field name="SAL_BRUT" />
        </element>
        <element location="E62" type="fill">
                <field name="COT_SAL" />
        </element>
        <element location="F62" type="fill">
                <field name="COT_PAT" />
        </element>

        <element location="G62" type="fill">
                <field name="AVANTAGE_NATURE" />
        </element>

        <element location="H62" type="fill">
                <field name="NET_IMP" />
        </element>

        <element location="I62" type="fill">
                <field name="ALLEGEMENT_COTISATION" />
        </element>

        <element location="D63" type="fill">
                <field name="SAL_BRUT" type="cumulPaye" />
        </element>
        <element location="E63" type="fill">
                <field name="COT_SAL" type="cumulPaye" />
        </element>
        <element location="F63" type="fill">
                <field name="COT_PAT" type="cumulPaye" />
        </element>
        <element location="G63" type="fill">
                <field name="AVANTAGE_NATURE" type="cumulPaye" />
        </element>

        <element location="H63" type="fill">
                <field name="NET_IMP" type="cumulPaye" />
        </element>

        <element location="I63" type="fill">
                <field name="ALLEGEMENT_COTISATION" type="cumulPaye" />
        </element>

        <element location="J16" type="fill">
                <field name="ID_SALARIE">
                        <field name="CODE" />
                </field>
        </element>
        <element location="J18" type="fill">
                <field name="ID_SALARIE">
                        <field name="ID_INFOS_SALARIE_PAYE">
                                <field name="DATE_ARRIVE">
                                </field>
                        </field>
                </field>
        </element>
        <element location="J21" type="fichepaye.smic" />
        <element location="J23" type="fichepaye.plafond" />

        <element location="J28" type="fill">
                 <field name="ID_VARIABLE_SALARIE">
                        <field name="HEURE_TRAV" />
                        </field> 
        </element>

        <element location="J30" type="fichepaye.heure.sup.total">                
        </element>
        
        
        <element location="J32" type="fichepaye.heure.total">           
        </element>

        <element location="J35" type="fill">
                 <field name="ID_VARIABLE_SALARIE">
                        <field name="HEURE_TRAV_CUMUL_VAL" />
                        </field> 
        </element>
        
        <element location="J37" type="fichepaye.heure.sup.cumul.total">         
        </element>

        <element location="J39" type="fichepaye.heure.cumul.total">             
        </element>


        <table endPageLine="65" firstLine="15" endLine="51" lastColumn="J" base="Societe" table="FICHE_PAYE_ELEMENT"
                blankLineBeforeStyle="Titre 1,Titre 2" fieldWhere="IMPRESSION" orderBy="POSITION">
                <element location="B" type="fill" cellSize="52">
                        <field name="NOM" />
                </element>
                <element location="D" type="fill">
                        <field name="NB_BASE" />
                </element>
                <element location="E" type="fill">
                        <field name="TAUX_SAL">
                                <exclude value="0.00" />
                                <exclude value="0.00%" />
                                <exclude value="0.000000" />
                        </field>
                </element>
                <element location="F" type="fill">
                        <field name="MONTANT_SAL_AJ">
                                <exclude value="0.00" />
                                <exclude value="0.00%" />
                                <exclude value="0.000000" />
                        </field>
                </element>
                <element location="G" type="fill">
                        <field name="MONTANT_SAL_DED">
                                <exclude value="0.00" />
                                <exclude value="0.00%" />
                                <exclude value="0.000000" />
                        </field>
                </element>
                <element location="H" type="fill">
                        <field name="TAUX_PAT">
                                <exclude value="0.00" />
                                <exclude value="0.00%" />
                                <exclude value="0.000000" />
                        </field>
                </element>
                <element location="I" type="fill">
                        <field name="MONTANT_PAT">
                                <exclude value="0.00" />
                                <exclude value="0.00%" />
                                <exclude value="0.000000" />
                        </field>
                </element>


        </table>
</contentDocument>