OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

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

Rev Author Line No. Line
144 ilm 1 
<?xml version="1.0" encoding="UTF-8" ?>
2 
<contentDocument>
3 
	<element location="B1" type="fill">
4 
		<field base="Common" table="SOCIETE_COMMON" name="TYPE" />
5 
		<field base="Common" table="SOCIETE_COMMON" name="NOM" />
6 
	</element>
7 
 
8 
	<element location="B2" type="fill">
9 
		<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
151 ilm 10 
			<field base="Common" name="RUE" />
144 ilm 11 
			<field base="Common" name="VILLE" type="villeCP" />
12 
			<field base="Common" name="VILLE" type="ville" />
13 
		</field>
14 
	</element>
15 
 
185 ilm 16 
	<element location="C7" type="fill">
144 ilm 17 
		<field base="Common" table="SOCIETE_COMMON" name="NUMERO_URSSAF" />
18 
	</element>
19 
 
185 ilm 20 
	<element location="F7" type="fill">
144 ilm 21 
		<field base="Common" table="SOCIETE_COMMON" name="NUM_SIRET" />
22 
	</element>
23 
 
24 
	<element location="J7" type="fill">
25 
		<field base="Common" table="SOCIETE_COMMON" name="NUM_APE" />
26 
	</element>
27 
 
28 
	<element location="B5" type="replace" replacePattern="_">
151 ilm 29 
		<field name="ID_SALARIE">
30 
			<field name="CODE" />
144 ilm 31 
		</field>
32 
	</element>
151 ilm 33 
 
34 
	<element location="E5" type="replace" replacePattern="_" cellSize="75">
35 
		<field name="ID_SALARIE">
36 
			<field name="ID_INFOS_SALARIE_PAYE">
37 
				<field name="ID_CONTRAT_SALARIE">
38 
					<field name="NATURE" cellSize="75" />
144 ilm 39 
				</field>
151 ilm 40 
			</field>
144 ilm 41 
		</field>
42 
	</element>
151 ilm 43 
 
44 
 
144 ilm 45 
	<element location="G2" type="fill">
151 ilm 46 
		<field name="DU" prefix="Paie du " type="date" datePattern="dd/MM/yy" />
47 
		<field name="AU" prefix=" au " type="date" datePattern="dd/MM/yy" />
144 ilm 48 
	</element>
151 ilm 49 
 
182 ilm 50 
	<element location="D58" type="fill">
151 ilm 51 
		<field name="DU" type="datePaye" />
144 ilm 52 
	</element>
53 
 
54 
	<element location="G9" type="fill">
151 ilm 55 
		<field name="ID_SALARIE">
56 
			<field name="PRENOM" />
57 
			<field name="NOM" />
58 
		</field>
144 ilm 59 
	</element>
60 
	<element location="G10" type="fill">
151 ilm 61 
		<field name="ID_SALARIE">
62 
			<field name="ID_ETAT_CIVIL">
63 
				<field name="ID_ADRESSE">
64 
					<field name="RUE" />
144 ilm 65 
				</field>
151 ilm 66 
			</field>
144 ilm 67 
		</field>
68 
	</element>
69 
	<element location="G12" type="fill">
151 ilm 70 
		<field name="ID_SALARIE">
71 
			<field name="ID_ETAT_CIVIL">
72 
				<field name="ID_ADRESSE">
73 
					<field name="CODE_POSTAL" />
74 
					<field name="VILLE" />
144 ilm 75 
				</field>
151 ilm 76 
			</field>
144 ilm 77 
		</field>
78 
	</element>
79 
 
80 
	<element location="D12" type="fill">
151 ilm 81 
		<field name="ID_VARIABLE_SALARIE">
82 
			<field name="CONGES_PRIS" />
83 
		</field>
144 ilm 84 
	</element>
85 
	<element location="E12" type="fill">
151 ilm 86 
		<field name="ID_CUMULS_CONGES">
87 
			<field name="RESTANT" />
88 
		</field>
144 ilm 89 
	</element>
90 
	<element location="F12" type="fill">
151 ilm 91 
		<field name="ID_CUMULS_CONGES">
182 ilm 92 
			<field name="ACQUIS" type="cumulConges" />
151 ilm 93 
		</field>
144 ilm 94 
	</element>
95 
	<element location="B6" type="replace" replacePattern="_">
151 ilm 96 
		<field name="ID_SALARIE">
97 
			<field name="ID_ETAT_CIVIL">
98 
				<field name="NUMERO_SS" />
99 
			</field>
144 ilm 100 
		</field>
101 
	</element>
151 ilm 102 
 
103 
	<element location="B3" type="fill">
104 
		<field name="ID_SALARIE">
105 
			<field name="ID_INFOS_SALARIE_PAYE">
106 
				<field name="ID_IDCC">
107 
					<field name="NOM" prefix="Convention collective : " cellSize="125" />
144 ilm 108 
				</field>
151 ilm 109 
			</field>
144 ilm 110 
		</field>
111 
	</element>
151 ilm 112 
 
144 ilm 113 
	<element location="B9" type="fill">
151 ilm 114 
		<field name="DETAILS_CONGES" />
144 ilm 115 
	</element>
151 ilm 116 
 
185 ilm 117 
	<element location="G52" type="fill">
151 ilm 118 
		<field name="COT_SAL" />
144 ilm 119 
	</element>
185 ilm 120 
	<element location="H52" type="fill">
151 ilm 121 
		<field name="COT_PAT" />
144 ilm 122 
	</element>
151 ilm 123 
 
124 
 
182 ilm 125 
	<element location="H54" type="fill">
126 
		<field name="NET_AVANT_PAS" />
144 ilm 127 
	</element>
151 ilm 128 
	<element location="I55" type="fill">
129 
		<field name="REDUCTION_GVT" />
144 ilm 130 
	</element>
151 ilm 131 
 
182 ilm 132 
	<element location="E57" type="fill">
133 
		<field name="NET_IMP" />
134 
	</element>
135 
	<element location="F57" type="fill">
136 
		<field name="ID_PAS">
137 
			<field name="TAUX_PAS" />
138 
		</field>
139 
	</element>
140 
	<element location="I57" type="fill">
141 
		<field name="TOTAL_PAS" />
142 
	</element>
143 
 
144 
 
145 
 
146 
 
147 
	<element location="I58" type="fill">
148 
		<field name="NET_A_PAYER" />
149 
	</element>
150 
 
151 
	<element location="D62" type="fill">
151 ilm 152 
		<field name="SAL_BRUT" />
144 ilm 153 
	</element>
182 ilm 154 
	<element location="E62" type="fill">
151 ilm 155 
		<field name="COT_SAL" />
144 ilm 156 
	</element>
182 ilm 157 
	<element location="F62" type="fill">
151 ilm 158 
		<field name="COT_PAT" />
144 ilm 159 
	</element>
151 ilm 160 
 
182 ilm 161 
	<element location="G62" type="fill">
151 ilm 162 
		<field name="AVANTAGE_NATURE" />
144 ilm 163 
	</element>
151 ilm 164 
 
182 ilm 165 
	<element location="H62" type="fill">
151 ilm 166 
		<field name="NET_IMP" />
144 ilm 167 
	</element>
151 ilm 168 
 
182 ilm 169 
	<element location="I62" type="fill">
151 ilm 170 
		<field name="ALLEGEMENT_COTISATION" />
144 ilm 171 
	</element>
151 ilm 172 
 
182 ilm 173 
	<element location="D63" type="fill">
151 ilm 174 
		<field name="SAL_BRUT" type="cumulPaye" />
175 
	</element>
182 ilm 176 
	<element location="E63" type="fill">
151 ilm 177 
		<field name="COT_SAL" type="cumulPaye" />
178 
	</element>
182 ilm 179 
	<element location="F63" type="fill">
151 ilm 180 
		<field name="COT_PAT" type="cumulPaye" />
181 
	</element>
182 ilm 182 
	<element location="G63" type="fill">
151 ilm 183 
		<field name="AVANTAGE_NATURE" type="cumulPaye" />
184 
	</element>
185 
 
182 ilm 186 
	<element location="H63" type="fill">
151 ilm 187 
		<field name="NET_IMP" type="cumulPaye" />
188 
	</element>
189 
 
182 ilm 190 
	<element location="I63" type="fill">
151 ilm 191 
		<field name="ALLEGEMENT_COTISATION" type="cumulPaye" />
192 
	</element>
193 
 
182 ilm 194 
	<element location="J16" type="fill">
195 
		<field name="ID_SALARIE">
196 
			<field name="CODE" />
197 
		</field>
198 
	</element>
199 
	<element location="J18" type="fill">
200 
		<field name="ID_SALARIE">
201 
			<field name="ID_INFOS_SALARIE_PAYE">
202 
				<field name="DATE_ARRIVE">
203 
				</field>
204 
			</field>
205 
		</field>
206 
	</element>
207 
	<element location="J21" type="fichepaye.smic" />
208 
	<element location="J23" type="fichepaye.plafond" />
209 
 
210 
	<element location="J28" type="fill">
211 
		 <field name="ID_VARIABLE_SALARIE">
212 
			<field name="HEURE_TRAV" />
213 
			</field>
214 
	</element>
215 
 
216 
	<element location="J30" type="fichepaye.heure.sup.total">
217 
	</element>
218 
 
219 
 
220 
	<element location="J32" type="fichepaye.heure.total">
221 
	</element>
222 
 
223 
	<element location="J35" type="fill">
224 
		 <field name="ID_VARIABLE_SALARIE">
225 
			<field name="HEURE_TRAV_CUMUL_VAL" />
226 
			</field>
227 
	</element>
228 
 
229 
	<element location="J37" type="fichepaye.heure.sup.cumul.total">
230 
	</element>
231 
 
232 
	<element location="J39" type="fichepaye.heure.cumul.total">
233 
	</element>
234 
 
235 
 
236 
	<table endPageLine="65" firstLine="15" endLine="51" lastColumn="J" base="Societe" table="FICHE_PAYE_ELEMENT"
144 ilm 237 
		blankLineBeforeStyle="Titre 1,Titre 2" fieldWhere="IMPRESSION" orderBy="POSITION">
238 
		<element location="B" type="fill" cellSize="52">
239 
			<field name="NOM" />
240 
		</element>
182 ilm 241 
		<element location="D" type="fill">
144 ilm 242 
			<field name="NB_BASE" />
243 
		</element>
182 ilm 244 
		<element location="E" type="fill">
245 
			<field name="TAUX_SAL">
246 
				<exclude value="0.00" />
247 
				<exclude value="0.00%" />
248 
				<exclude value="0.000000" />
249 
			</field>
250 
		</element>
144 ilm 251 
		<element location="F" type="fill">
182 ilm 252 
			<field name="MONTANT_SAL_AJ">
253 
				<exclude value="0.00" />
254 
				<exclude value="0.00%" />
255 
				<exclude value="0.000000" />
256 
			</field>
144 ilm 257 
		</element>
258 
		<element location="G" type="fill">
182 ilm 259 
			<field name="MONTANT_SAL_DED">
260 
				<exclude value="0.00" />
261 
				<exclude value="0.00%" />
262 
				<exclude value="0.000000" />
263 
			</field>
144 ilm 264 
		</element>
265 
		<element location="H" type="fill">
182 ilm 266 
			<field name="TAUX_PAT">
267 
				<exclude value="0.00" />
268 
				<exclude value="0.00%" />
269 
				<exclude value="0.000000" />
270 
			</field>
144 ilm 271 
		</element>
182 ilm 272 
		<element location="I" type="fill">
273 
			<field name="MONTANT_PAT">
274 
				<exclude value="0.00" />
275 
				<exclude value="0.00%" />
276 
				<exclude value="0.000000" />
277 
			</field>
144 ilm 278 
		</element>
151 ilm 279 
 
280 
 
144 ilm 281 
	</table>
282 
</contentDocument>