<?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="J50" 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="G51" type="fill">
		<field name="COT_SAL" />
		</element>
		<element location="H51" type="fill">
		<field name="COT_PAT" />
		</element> -->
	<element location="H53" type="fill">
		<field name="NET_SOCIAL" />
	</element>

	<element location="H55" type="fill">
		<field name="NET_AVANT_PAS" />
	</element>
	<element location="I56" type="fill">
		<field name="REDUCTION_GVT" />
	</element>

	<element location="E59" type="fill">
		<field name="NET_IMP" />
	</element>
	<element location="E60" type="fill">
		<field name="NET_IMP" />
	</element>
	<element location="F60" type="fill">
		<field name="ID_PAS">
			<field name="TAUX_PAS" />
		</field>
	</element>
	<element location="H60" type="fill">
		<field name="TOTAL_PAS" />
	</element>
	<element location="H61" type="fill">
		<field name="HEURE_SUP_EXO_NET" />
	</element>



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

	<!-- <element location="D61" type="fill">
		<field name="SAL_BRUT" />
		</element>
		<element location="E61" type="fill">
		<field name="COT_SAL" />
		</element>
		<element location="F61" type="fill">
		<field name="COT_PAT" />
		</element> -->

	<element location="H65" type="fichepaye.total.employeur">
	</element>

	<!-- <element location="H61" type="fill">
		<field name="NET_IMP" />
	</element> -->

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

	<element location="J38" type="fill">
		<field name="SAL_BRUT" type="cumulPaye" />
	</element>
	<element location="J40" type="fill">
		<field name="COT_SAL" type="cumulPaye" />
	</element>
	<element location="J42" type="fill">
		<field name="COT_PAT" type="cumulPaye" />
	</element>
	<element location="J44" type="fichepaye.total.employeur.cumul">
	</element>

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

	<element location="J46" type="fill">
		<field name="ALLEGEMENT_COTISATION" type="cumulPaye" />
	</element>
	
	<element location="J61" type="fill">
		<field name="HEURE_SUP_EXO_NET" type="cumulPaye" />
	</element>
	<element location="J60" type="fill">
		<field name="TOTAL_PAS" type="cumulPaye" />
	</element>

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

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

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


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

	<element location="J31" type="fill">
		<field name="ID_VARIABLE_SALARIE">
			<field name="HEURE_TRAV_CUMUL_VAL" />
		</field>
	</element>

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

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


	<table endPageLine="64" firstLine="15" endLine="50" lastColumn="H" 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>