<?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" table="ADRESSE_COMMON" name="RUE"/>
		</field>
	</element>

	<element location="B4" 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>
	</element>
	
	<element location="B5" type="fill">
		<field base="Common" table="SOCIETE_COMMON" name="RCS" prefix="RCS "/>
		<field base="Common" table="SOCIETE_COMMON" name="TYPE" prefix=" - " suffix=" au capital de "/>
		<field base="Common" table="SOCIETE_COMMON" name="CAPITAL" suffix="€"/>

	</element>

	<element location="B6" type="fill">
		<field base="Common" table="SOCIETE_COMMON" name="NUM_SIRET" prefix="N° SIREN : "/>		
	</element>

	<element location="B7" type="replace" replacePattern="_">
		<field base="Common" table="SOCIETE_COMMON" name="NUM_NII"/>
	</element>
	
	<element location="B8" type="replace" replacePattern="_">
		<field base="Common" table="SOCIETE_COMMON" name="NUM_TEL"/>
	</element>
	
	<element location="B9" type="replace" replacePattern="_">
		<field base="Common" table="SOCIETE_COMMON" name="NUM_FAX"/>
	</element>
	
	<element location="B10" type="replace" replacePattern="_">
		<field base="Common" table="SOCIETE_COMMON" name="MAIL"/>
	</element>
	
	
	<element location="B16" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="ID_COMMERCIAL">
			<field base="Societe" table="COMMERCIAL" name="PRENOM" type="Initiale" suffix="."/>
			<field base="Societe" table="COMMERCIAL" name="NOM"/>
		</field>
	</element>

	<element location="B13" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="NUMERO"/>
	</element>	
	
	<element location="C13" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="DATE"/>
	</element>	
	
	<element location="C16" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="NOM"/>
	</element>
	
	
	<element location="I10" 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"/>
		</field>
	</element>
	
	<element location="I11" 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="I13" 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>
		</field>
	</element>


	<element location="L63" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="T_HT" type="devise"/>
	</element>
	
	<element location="L64" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="T_TVA" type="devise"/>
	</element>
	
	<element location="L65" type="fill">
		<field base="Societe" table="COMMANDE_CLIENT" name="T_TTC" type="devise"/>
	</element>

	
	<table endPageLine="66" firstLine="21" endLine="60" lastColumn="L" base="Societe" table="COMMANDE_CLIENT_ELEMENT" blankLineBeforeStyle="Titre 1" pageRef="L16">
		<element location="B" type="fill" cellSize="59">
			<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="NOM"/>			
		</element>
		
		<element location="I" type="fill">
			<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="PV_HT" type="devise" valuesExpected="0"/>
		</element>
		
		<element location="J" type="fill">
			<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="QTE" conditionField="PV_HT" conditionExpValue="0"/>
		</element>

		<element location="K" type="fill">
			<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="ID_TAXE" conditionField="PV_HT" conditionExpValue="0">
				<field base="Societe" table="TAXE" name="TAUX" suffix="%" />
			</field>
		</element>	
		
		
		<element location="L" type="fill">
			<field base="Societe" table="COMMANDE_CLIENT_ELEMENT" name="T_PV_HT" type="devise" valuesExpected="0"/>
		</element>
			
	</table>
</contentDocument>