| 73 |
ilm |
1 |
<?xml version="1.0" encoding="UTF-8" ?>
|
|
|
2 |
<fieldmapping>
|
| 144 |
ilm |
3 |
<table id="customerrelationship.customer" name="CLIENT">
|
|
|
4 |
<field id="customerrelationship.identifier" name="CODE" />
|
|
|
5 |
<field id="customerrelationship.date" name="DATE" />
|
|
|
6 |
<field id="customerrelationship.group" name="GROUP" />
|
|
|
7 |
<field id="customerrelationship.country" name="ID_PAYS" />
|
|
|
8 |
<field id="customerrelationship.phone" name="PHONE" />
|
|
|
9 |
</table>
|
| 180 |
ilm |
10 |
<table id="customerrelationship.customer.agency" name="AGENCE">
|
|
|
11 |
<field id="customerrelationship.customer.agency.designation" name="DESIGNATION" />
|
|
|
12 |
<field id="customerrelationship.customer.agency.phone1" name="TEL_1" />
|
|
|
13 |
<field id="customerrelationship.customer.agency.email" name="EMAIL" />
|
|
|
14 |
<field id="customerrelationship.customer.agency.fax" name="FAX" />
|
|
|
15 |
<field id="customerrelationship.customer.agency.customer" name="ID_CLIENT" />
|
|
|
16 |
<field id="customerrelationship.customer.agency.address" name="ID_ADRESSE" />
|
|
|
17 |
</table>
|
| 73 |
ilm |
18 |
<table id="sales.invoice" name="SAISIE_VENTE_FACTURE">
|
| 80 |
ilm |
19 |
<field id="sales.invoice.number" name="NUMERO" />
|
|
|
20 |
<field id="sales.invoice.date" name="DATE" />
|
|
|
21 |
<field id="sales.invoice.label" name="NOM" />
|
|
|
22 |
<field id="sales.invoice.customer" name="ID_CLIENT" />
|
|
|
23 |
<field id="sales.invoice.saleman" name="ID_COMMERCIAL" />
|
|
|
24 |
<field id="sales.invoice.address.alternative" name="ID_ADRESSE" />
|
|
|
25 |
<field id="sales.invoice.info.general" name="INFOS" />
|
|
|
26 |
<field id="sales.invoice.total.ht" name="T_HT" />
|
|
|
27 |
<field id="sales.invoice.total.service" name="T_SERVICE" />
|
|
|
28 |
<field id="sales.invoice.total.supply" name="T_HA" />
|
|
|
29 |
<field id="sales.invoice.total.devise" name="T_DEVISE" />
|
|
|
30 |
<field id="sales.invoice.total.weight" name="T_POIDS" />
|
|
|
31 |
<field id="sales.invoice.total.ttc" name="T_TTC" />
|
|
|
32 |
<field id="sales.invoice.total.vat" name="T_TVA" />
|
| 73 |
ilm |
33 |
</table>
|
|
|
34 |
<table id="sales.quote" name="DEVIS">
|
| 80 |
ilm |
35 |
<field id="sales.quote.number" name="NUMERO" />
|
|
|
36 |
<field id="sales.quote.date" name="DATE" />
|
|
|
37 |
<field id="sales.quote.label" name="OBJET" />
|
|
|
38 |
<field id="sales.quote.customer" name="ID_CLIENT" />
|
|
|
39 |
<field id="sales.quote.saleman" name="ID_COMMERCIAL" />
|
|
|
40 |
<field id="sales.quote.address.alternative" name="ID_ADRESSE" />
|
|
|
41 |
<field id="sales.quote.info.general" name="INFOS" />
|
| 90 |
ilm |
42 |
<field id="sales.quote.state" name="ID_ETAT_DEVIS" />
|
|
|
43 |
<field id="sales.quote.validity" name="DATE_VALIDITE" />
|
|
|
44 |
<field id="sales.quote.customer.contact" name="ID_CONTACT" />
|
|
|
45 |
<field id="sales.quote.customer.tarif" name="ID_TARIF" />
|
|
|
46 |
<field id="sales.quote.customer.discount" name="MONTANT_REMISE,POURCENT_REMISE" />
|
| 73 |
ilm |
47 |
</table>
|
| 83 |
ilm |
48 |
<table id="sales.quote.item" name="DEVIS_ELEMENT">
|
| 90 |
ilm |
49 |
<field id="sales.quote.item.quote" name="ID_DEVIS" />
|
|
|
50 |
<field id="sales.quote.item.style" name="ID_STYLE" />
|
|
|
51 |
<field id="sales.quote.item.code" name="CODE" />
|
|
|
52 |
<field id="sales.quote.item.label" name="NOM" />
|
|
|
53 |
<field id="sales.quote.item.description" name="DESCRIPTIF" />
|
|
|
54 |
<field id="sales.quote.item.purchase.unit.price" name="PA_HT" />
|
|
|
55 |
<field id="sales.quote.item.sales.unit.price" name="PV_HT" />
|
|
|
56 |
<field id="sales.quote.item.quantity" name="QTE" />
|
| 83 |
ilm |
57 |
</table>
|
| 80 |
ilm |
58 |
<table id="sales.product" name="ARTICLE">
|
|
|
59 |
<field id="sales.product.code" name="CODE" />
|
|
|
60 |
<field id="sales.product.label" name="NOM" />
|
|
|
61 |
<field id="sales.product.description.text" name="DESCRIPTIF" />
|
|
|
62 |
<field id="sales.product.barcode" name="CODE_BARRE" />
|
|
|
63 |
<field id="sales.product.purchase.price" name="PA_HT" />
|
|
|
64 |
<field id="sales.product.purchase.quantity" name="QTE_ACHAT" />
|
|
|
65 |
<field id="sales.product.sales.price" name="PV_HT" />
|
|
|
66 |
<field id="sales.product.sales.price.total" name="PV_TTC" />
|
| 93 |
ilm |
67 |
<field id="sales.product.sales.unit" name="ID_UNITE_VENTE" />
|
| 80 |
ilm |
68 |
<field id="sales.product.weight" name="POIDS" />
|
|
|
69 |
<field id="sales.product.unit1" name="ID_METRIQUE_1" />
|
|
|
70 |
<field id="sales.product.unit2" name="ID_METRIQUE_2" />
|
|
|
71 |
<field id="sales.product.unit3" name="ID_METRIQUE_3" />
|
|
|
72 |
<field id="sales.product.purchase.unit.price1" name="PRIX_METRIQUE_HA_1" />
|
|
|
73 |
<field id="sales.product.purchase.unit.price2" name="PRIX_METRIQUE_HA_2" />
|
|
|
74 |
<field id="sales.product.purchase.unit.price3" name="PRIX_METRIQUE_HA_3" />
|
|
|
75 |
<field id="sales.product.tax" name="ID_TAXE" />
|
|
|
76 |
<field id="sales.product.service" name="SERVICE" />
|
|
|
77 |
<field id="sales.product.autocreate" name="CREATION_AUTO" />
|
|
|
78 |
<field id="sales.product.inventory" name="ID_STOCK" />
|
|
|
79 |
<field id="sales.product.manufacturing.country" name="ID_PAYS" />
|
|
|
80 |
<field id="sales.product.unit" name="ID_UNITE_VENTE" />
|
|
|
81 |
<field id="sales.product.sales.account" name="ID_COMPTE_PCE" />
|
|
|
82 |
<field id="sales.product.purchase.account" name="ID_COMPTE_PCE_ACHAT" />
|
|
|
83 |
<field id="sales.product.deprecated" name="OBSOLETE" />
|
| 83 |
ilm |
84 |
<field id="sales.product.category" name="ID_FAMILLE_ARTICLE" />
|
| 80 |
ilm |
85 |
<field id="sales.product.info" name="INFOS" />
|
|
|
86 |
<field id="sales.product.price1" name="PRIX_METRIQUE_VT_1" />
|
|
|
87 |
<field id="sales.product.price2" name="PRIX_METRIQUE_VT_2" />
|
|
|
88 |
<field id="sales.product.price3" name="PRIX_METRIQUE_VT_3" />
|
|
|
89 |
<field id="sales.product.length" name="VALEUR_METRIQUE_1" />
|
|
|
90 |
<field id="sales.product.width" name="VALEUR_METRIQUE_2" />
|
|
|
91 |
<field id="sales.product.weight2" name="VALEUR_METRIQUE_3" />
|
|
|
92 |
<field id="sales.product.stockable" name="GESTION_STOCK" />
|
|
|
93 |
<field id="sales.product.quantity.min" name="QTE_MIN" />
|
|
|
94 |
<field id="sales.product.currency" name="ID_DEVISE" />
|
|
|
95 |
<field id="sales.product.supplier" name="ID_FOURNISSEUR" />
|
|
|
96 |
<field id="sales.product.aa" name="PV_U_DEVISE" />
|
|
|
97 |
<field id="sales.product.bb" name="ID_DEVISE_HA" />
|
|
|
98 |
<field id="sales.product.cc" name="PA_DEVISE" />
|
|
|
99 |
<field id="sales.product.customs.code" name="CODE_DOUANIER" />
|
|
|
100 |
<field id="sales.product.ecotax" name="ECOTAXE" />
|
|
|
101 |
<field id="sales.product.margin.min" name="MARGE_HT_MIN" />
|
|
|
102 |
<field id="sales.product.purchase.shipment" name="PORT_ACHAT" />
|
|
|
103 |
<field id="sales.product.sales.shipment" name="PORT_VENTE" />
|
|
|
104 |
<field id="sales.product.quantity.max" name="QTE_MAX" />
|
|
|
105 |
<field id="sales.product.needserial" name="GESTION_NUMERO_SERIE" />
|
|
|
106 |
<field id="sales.product.bom.merge" name="GROUPE_NOMENCLATURE" />
|
|
|
107 |
<field id="sales.product.purchase.frombom" name="AUTO_PRIX_ACHAT_NOMENCLATURE" />
|
|
|
108 |
<field id="sales.product.comment" name="COMMENTAIRE" />
|
|
|
109 |
</table>
|
| 73 |
ilm |
110 |
</fieldmapping>
|
