<?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="B3" 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 base="Common" table="ADRESSE_COMMON" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
		</field>
	</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" name="ID_COMMERCIAL">
			<field base="Societe" table="COMMERCIAL" name="NOM"/>
		</field>
	</element>

	<element location="B13" type="fill">
		<field base="Societe" table="COMMANDE" name="NUMERO"/>
	</element>	
	
	<element location="C13" type="fill">
		<field base="Societe" table="COMMANDE" name="DATE"/>
	</element>	
	
	<element location="C16" type="fill">
		<field base="Societe" table="COMMANDE" name="NOM"/>
	</element>
	
	
	<element location="H10" type="fill">
		<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
			<field base="Societe" table="FOURNISSEUR" name="TYPE"/>
			<field base="Societe" table="FOURNISSEUR" name="NOM"/>
		</field>
	</element>
	
	<element location="H11" type="fill">
		<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
			<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
				<field base="Societe" table="ADRESSE" name="RUE"/>
			</field>
		</field>
	</element>
	
	<element location="H13" type="fill">
		<field base="Societe" table="COMMANDE" name="ID_FOURNISSEUR">
			<field base="Societe" table="FOURNISSEUR" name="ID_ADRESSE">
				<field base="Societe" table="ADRESSE_COMMON" name="VILLE" type="villeCP"/>
				<field base="Societe" table="ADRESSE_COMMON" name="VILLE" type="ville"/>
				<field base="Societe" table="ADRESSE_COMMON" name="CEDEX" prefix="CEDEX " conditionField="HAS_CEDEX"/>
			</field>
		</field>
	</element>


	<element location="L55" type="fill">
		<field base="Societe" table="COMMANDE" name="T_HT" type="devise"/>
	</element>
	
	<element location="L56" type="fill">
		<field base="Societe" table="COMMANDE" name="T_TVA" type="devise"/>
	</element>
	
	<element location="L57" type="fill">
		<field base="Societe" table="COMMANDE" name="T_TTC" type="devise"/>
	</element>

	
	<table endPageLine="57" firstLine="22" endLine="52" lastColumn="L" base="Societe" table="COMMANDE_ELEMENT">
		<element location="B" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="NOM"/>
		</element>		
		
		<element location="G" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="PRIX_METRIQUE_HA_1" type="devise"/>
			<field base="Societe" table="COMMANDE_ELEMENT" name="ID_MODE_VENTE_ARTICLE">
				<field base="Societe" table="MODE_VENTE_ARTICLE" name="CODE" prefix="€/"/>
			</field>
		</element>

		<element location="H" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="PA_HT" type="devise"/>
		</element>

		<element location="I" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="QTE"/>
		</element>
		
		<element location="J" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="ID_TAXE">
				<field base="Societe" table="TAXE" name="TAUX" suffix="%"/>
			</field>
		</element>	
		
		<element location="K" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="T_POIDS"/>
		</element>
		
		<element location="L" type="fill">
			<field base="Societe" table="COMMANDE_ELEMENT" name="T_PA_HT" type="devise"/>
		</element>
			
	</table>
</contentDocument>