OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 21 | Rev 65 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 ilm 1
<?xml version="1.0" encoding="UTF-8" ?>
2
 
3
<contentDocument>
4
 
5
	<element location="B1" type="fill">
6
		<field base="Common" table="SOCIETE_COMMON" name="TYPE"/>
7
		<field base="Common" table="SOCIETE_COMMON" name="NOM"/>
8
	</element>
9
 
10
	<element location="B2" type="fill">
11
		<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
12
			<field base="Common" table="ADRESSE_COMMON" name="RUE"/>
13
		</field>
14
	</element>
15
 
16
	<element location="B3" type="fill">
17
		<field base="Common" table="SOCIETE_COMMON" name="ID_ADRESSE_COMMON">
18
			<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
19
			<field base="Common" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
20
		</field>
21
	</element>
22
 
23
	<element location="B7" type="replace" replacePattern="_">
24
		<field base="Common" table="SOCIETE_COMMON" name="NUM_NII"/>
25
	</element>
26
 
27
	<element location="B8" type="replace" replacePattern="_">
28
		<field base="Common" table="SOCIETE_COMMON" name="NUM_TEL"/>
29
	</element>
30
 
31
	<element location="B9" type="replace" replacePattern="_">
32
		<field base="Common" table="SOCIETE_COMMON" name="NUM_FAX"/>
33
	</element>
34
 
35
	<element location="B10" type="replace" replacePattern="_">
36
		<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
37
	</element>
38
 
39
 
40
	<element location="B13" type="fill">
41
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NUMERO"/>
42
	</element>
43
 
44
	<element location="C13" type="fill">
45
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE"/>
46
	</element>
47
 
48
	<element location="B16" type="fill">
49
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_COMMERCIAL">
50
			<field base="Societe" table="COMMERCIAL" name="PRENOM" type="Initiale" suffix="."/>
51
			<field base="Societe" table="COMMERCIAL" name="NOM"/>
52
		</field>
53
	</element>
54
 
55
 
56
	<element location="C16" type="fill">
57
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="NOM"/>
58
	</element>
59
 
60
 
61
	<element location="H10" type="fill">
62
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
63
			<field base="Societe" table="CLIENT" name="FORME_JURIDIQUE"/>
64
			<field base="Societe" table="CLIENT" name="NOM"/>
65
		</field>
66
	</element>
67
 
68
	<element location="H11" type="fill">
69
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
70
			<field base="Societe" table="CLIENT" name="ID_ADRESSE">
71
				<field base="Societe" table="ADRESSE" name="RUE"/>
72
			</field>
73
		</field>
74
	</element>
75
 
76
	<element location="H13" type="fill">
77
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_CLIENT">
78
			<field base="Societe" table="CLIENT" name="ID_ADRESSE">
79
				<field base="Societe" table="ADRESSE" name="VILLE" type="villeCP"/>
80
				<field base="Societe" table="ADRESSE" name="VILLE" type="ville"/>
81
				<field base="Societe" table="ADRESSE" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
82
			</field>
83
		</field>
84
	</element>
85
 
86
 
87
	<element location="L62" type="fill">
88
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_HT" type="devise"/>
89
	</element>
90
 
91
	<element location="L65" type="fill">
92
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="T_TTC" type="devise"/>
93
	</element>
94
 
95
	<element location="B63" type="fill">
96
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
97
 
25 ilm 98
			<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement souhaité" conditionField="COMPTANT" conditionExpValue="true" display="false"/>
99
			<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Facture acquitée par" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
13 ilm 100
 
101
			<field base="Societe" table="MODE_REGLEMENT" name="ID_TYPE_REGLEMENT">
102
				<field base="Societe" table="TYPE_REGLEMENT" name="NOM"  valuesExpected="Indéfini"/>
103
			</field>
104
 
105
 
106
			<field base="Societe" table="MODE_REGLEMENT" name="NOM"/>
107
			<field base="Societe" table="MODE_REGLEMENT" name="DATE_VIREMENT" prefix="Le " valuesExpected="" type="Date" datePattern="dd/MM/yy"/>
108
			<field base="Societe" table="MODE_REGLEMENT" name="NUMERO" prefix="N° " valuesExpected=""/>
109
			<field base="Societe" table="MODE_REGLEMENT" name="ETS" prefix="Banque " valuesExpected=""/>
110
		</field>
111
	</element>
25 ilm 112
 
13 ilm 113
 
114
	<element location="B64" type="fill">
25 ilm 115
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="DATE" type="DateEcheance" prefix="Règlement de cette facture au plus tard le " valuesExpected=" "/>
116
	</element>
117
 
118
	<element location="B64" type="fill">
13 ilm 119
		<field base="Societe" table="SAISIE_VENTE_FACTURE" name="ID_MODE_REGLEMENT">
120
 
121
			<field base="Societe" table="MODE_REGLEMENT" name="NOM" prefix="Règlement à date de réception de facture" conditionField="COMPTANT" conditionExpValue="false" display="false"/>
122
		</field>
123
	</element>
124
 
125
 
126
	<table endPageLine="65" firstLine="63" endLine="65" lastColumn="I" base="Societe" table="TVA">
127
		<element location="I" name="NOM" prefix="Total ">
128
		</element>
129
 
130
		<element location="L" type="Devise" name="MONTANT_TVA">
131
		</element>
132
 
133
	</table>
134
 
135
	<table endPageLine="65" firstLine="20" endLine="60" blankLineBeforeStyle="Titre 1,Titre 2" lastColumn="K" base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT">
136
		<element location="B" type="fill">
137
			<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="NOM"/>
138
		</element>
139
 
140
		<element location="I" type="fill">
141
			<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="PV_HT" valuesExpected="0" type="devise"/>
142
		</element>
143
 
144
		<element location="J" type="fill">
145
			<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
146
		</element>
147
 
148
		<element location="K" type="fill">
149
			<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
21 ilm 150
				<field base="Societe" table="TAXE" name="TAUX" op="/" number="100.0"/>
13 ilm 151
			</field>
152
		</element>
153
 
154
		<element location="L" type="fill">
155
			<field base="Societe" table="SAISIE_VENTE_FACTURE_ELEMENT" valuesExpected="0" name="T_PV_HT" type="devise"/>
156
		</element>
157
 
158
	</table>
159
</contentDocument>