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