Definition
Canonical Type |
ThirdParty |
Objects Name |
Tiers |
Description |
Dolibarr Company Object |
Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
Name |
Identifier |
Flags |
Data Format |
Field Description |
Date de dernière modification |
date_modification |
|
DATE
|
Date de dernière modification |
Date création |
date_creation |
|
DATE
|
Date création |
Phpunit_Varchar |
options_phpunit_varchar |
|
VARCHAR
|
Phpunit_Varchar |
Phpunit_Text |
options_phpunit_text |
|
TEXT
|
Phpunit_Text |
Phpunit_Int |
options_phpunit_int |
|
INT
|
Phpunit_Int |
Phpunit_Price |
options_phpunit_price |
|
PRICE
|
Phpunit_Price |
Phpunit_Mail |
options_phpunit_mail |
|
EMAIL
|
Phpunit_Mail |
Phpunit_Phone |
options_phpunit_phone |
|
PHONE
|
Phpunit_Phone |
Phpunit_Url |
options_phpunit_url |
|
URL
|
Phpunit_Url |
Phpunit_Date |
options_phpunit_date |
|
DATE
|
Phpunit_Date |
Nom/Enseigne/Raison sociale |
name |
|
VARCHAR
|
Nom/Enseigne/Raison sociale |
Prénom |
firstname |
|
VARCHAR
|
Prénom |
Nom |
lastname |
|
VARCHAR
|
Nom |
Code client |
code_client |
|
VARCHAR
|
Code client unique pour chaque client |
Téléphone |
phone |
|
PHONE
|
Téléphone |
Email |
email |
|
EMAIL
|
Email |
URL publique |
url |
|
URL
|
URL publique |
Id. prof. 1 |
idprof1 |
|
VARCHAR
|
Id. prof. 1 |
Id. prof. 2 |
idprof2 |
|
VARCHAR
|
Id. prof. 2 |
Id. prof. 3 |
idprof3 |
|
VARCHAR
|
Id. prof. 3 |
Id. prof. 4 |
idprof4 |
|
VARCHAR
|
Id. prof. 4 |
Id. prof. 5 |
idprof5 |
|
VARCHAR
|
Id. prof. 5 |
Id prof. 6 |
idprof6 |
|
VARCHAR
|
Id prof. 6 |
Numéro de TVA |
tva_intra |
|
VARCHAR
|
Numéro de TVA |
Adresse |
address |
|
VARCHAR
|
Adresse |
Code postal |
zip |
|
VARCHAR
|
Code postal |
Ville |
town |
|
VARCHAR
|
Ville |
Pays |
country |
|
VARCHAR
|
Pays |
Code pays |
country_code |
|
ISO COUNTRY
|
Code pays |
Département / Canton |
state |
|
VARCHAR
|
Département / Canton |
State Code |
state_code |
|
ISO STATE
|
State Code |
Actif |
status |
|
BOOL
|
Actif |
Prospect |
prospect |
|
BOOL
|
Prospect |
Client |
client |
|
BOOL
|
Client |
Fournisseur |
fournisseur |
|
BOOL
|
Fournisseur |
Assujetti à la TVA |
tva_assuj |
|
BOOL
|
Assujetti à la TVA |
Definition
Canonical Type |
Product |
Objects Name |
Produits |
Description |
Dolibarr Product Object |
Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
Name |
Identifier |
Flags |
Data Format |
Field Description |
Date de dernière modification |
date_modification |
|
DATE
|
Date de dernière modification |
Date création |
date_creation |
|
DATE
|
Date création |
Phpunit_Varchar |
options_phpunit_varchar |
|
VARCHAR
|
Phpunit_Varchar |
Phpunit_Text |
options_phpunit_text |
|
TEXT
|
Phpunit_Text |
Phpunit_Int |
options_phpunit_int |
|
INT
|
Phpunit_Int |
Phpunit_Price |
options_phpunit_price |
|
PRICE
|
Phpunit_Price |
Phpunit_Mail |
options_phpunit_mail |
|
EMAIL
|
Phpunit_Mail |
Phpunit_Phone |
options_phpunit_phone |
|
PHONE
|
Phpunit_Phone |
Phpunit_Url |
options_phpunit_url |
|
URL
|
Phpunit_Url |
Phpunit_Date |
options_phpunit_date |
|
DATE
|
Phpunit_Date |
Fichier image |
image@images |
|
>
IMG
|
Fichier image |
Cover Image |
cover@images |
|
>
BOOL
|
Cover Image |
Visible Image |
visible@images |
|
>
BOOL
|
Visible Image |
Position |
position@images |
|
>
INT
|
Position |
Réf. produit |
ref |
|
VARCHAR
|
Réf. produit |
Libellé produit |
label |
|
VARCHAR
|
Libellé produit |
Description |
description |
|
VARCHAR
|
Description |
Libellé produit |
label_da_DK |
|
VARCHAR
|
Libellé produit |
Description |
description_da_DK |
|
VARCHAR
|
Description |
Libellé produit |
label_de_DE |
|
VARCHAR
|
Libellé produit |
Description |
description_de_DE |
|
VARCHAR
|
Description |
Note |
note |
|
TEXT
|
Note |
Poids |
weight |
|
DOUBLE
|
Poids (Kg) |
Longueur |
length |
|
DOUBLE
|
Longueur (m) |
Largeur |
width |
|
DOUBLE
|
Largeur (m) |
Hauteur |
height |
|
DOUBLE
|
Heigth (m) |
Surface |
surface |
|
DOUBLE
|
Surface (m²) |
Volume |
volume |
|
DOUBLE
|
Volume (m³) |
Valeur du code-barres |
barcode |
|
VARCHAR
|
Valeur du code-barres () |
Prix de vente (EUR) |
price |
|
PRICE
|
Prix de vente (EUR) |
CostPrice (EUR) |
cost_price |
|
PRICE
|
Ce prix (net de taxe) peut être utilisé pour stocker le montant moyen du coût de ce produit pour votre entreprise. Il peut être calculé par exemple à partir du prix d'achat moyen majoré des coûts moyens de production et de distribution. |
Entrepôt par défaut |
fk_default_warehouse |
|
VARCHAR
|
Entrepôt par défaut |
Stock réel |
stock_reel |
|
INT
|
Stock réel |
Limite stock pour alerte |
seuil_stock_alerte |
|
INT
|
Limite stock pour alerte |
Stock insuffisant |
stock_alert_flag |
|
BOOL
|
Stock insuffisant |
Stock désiré optimal |
desiredstock |
|
INT
|
Stock désiré optimal |
Valorisation achat (PMP) |
pmp |
|
DOUBLE
|
Valorisation achat (PMP) |
État (Achat) |
status_buy |
|
BOOL
|
État (Achat) |
État (Vente) |
status |
|
BOOL
|
État (Vente) |
Definition
Canonical Type |
Order |
Objects Name |
Commandes |
Description |
Dolibarr Customers Order Object |
Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
Name |
Identifier |
Flags |
Data Format |
Field Description |
Date de dernière modification |
date_modification |
|
DATE
|
Date de dernière modification |
Date création |
date_creation |
|
DATE
|
Date création |
Description |
desc@lines |
|
>
VARCHAR
|
Description |
Produit |
fk_product@lines |
|
>
Product
|
Produit |
Quantité |
qty@lines |
|
>
INT
|
Quantité |
Remise |
remise_percent@lines |
|
>
DOUBLE
|
Remise |
Prix |
price@lines |
|
>
PRICE
|
Prix |
Taux TVA |
vat_src_code@lines |
|
>
VARCHAR
|
Taux TVA |
Phpunit_Varchar |
options_phpunit_varchar |
|
VARCHAR
|
Phpunit_Varchar |
Phpunit_Text |
options_phpunit_text |
|
TEXT
|
Phpunit_Text |
Phpunit_Int |
options_phpunit_int |
|
INT
|
Phpunit_Int |
Phpunit_Price |
options_phpunit_price |
|
PRICE
|
Phpunit_Price |
Phpunit_Mail |
options_phpunit_mail |
|
EMAIL
|
Phpunit_Mail |
Phpunit_Phone |
options_phpunit_phone |
|
PHONE
|
Phpunit_Phone |
Phpunit_Url |
options_phpunit_url |
|
URL
|
Phpunit_Url |
Phpunit_Date |
options_phpunit_date |
|
DATE
|
Phpunit_Date |
Fichier image |
image@images |
|
>
IMG
|
Fichier image |
Cover Image |
cover@images |
|
>
BOOL
|
Cover Image |
Visible Image |
visible@images |
|
>
BOOL
|
Visible Image |
Position |
position@images |
|
>
INT
|
Position |
Société |
socid |
|
ThirdParty
|
Société |
Contact client facturation commande |
BILLING |
|
Address
|
Contact client facturation commande |
Contact client livraison commande |
SHIPPING |
|
Address
|
Contact client livraison commande |
Date de commande |
date |
|
DATE
|
Date de commande |
Réf. commande |
ref |
|
VARCHAR
|
Réf. commande |
Réf. commande client |
ref_client |
|
VARCHAR
|
Réf. commande client |
InternalRef |
ref_int |
|
VARCHAR
|
InternalRef |
RefExt |
ref_ext |
|
VARCHAR
|
RefExt |
DeliveryDate |
date_livraison |
|
DATE
|
DeliveryDate |
Total HT (EUR) |
total_ht |
|
DOUBLE
|
Total HT (EUR) |
Total TTC (EUR) |
total_ttc |
|
DOUBLE
|
Total TTC (EUR) |
Commande : Brouillon |
isdraft |
|
BOOL
|
Commande : Brouillon |
Commande : Annulé |
iscanceled |
|
BOOL
|
Commande : Annulé |
Commande : Validé |
isvalidated |
|
BOOL
|
Commande : Validé |
Commande : Clôturé |
isclosed |
|
BOOL
|
Commande : Clôturé |
Commande : Payé |
billed |
|
BOOL
|
Commande : Payé |
État |
status |
|
VARCHAR
|
État |
Definition
Canonical Type |
Invoice |
Objects Name |
Factures clients |
Description |
Dolibarr Customers Invoice Object |
Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
Name |
Identifier |
Flags |
Data Format |
Field Description |
Date de dernière modification |
date_modification |
|
DATE
|
Date de dernière modification |
Date création |
date_creation |
|
DATE
|
Date création |
Description |
desc@lines |
|
>
VARCHAR
|
Description |
Produit |
fk_product@lines |
|
>
Product
|
Produit |
Quantité |
qty@lines |
|
>
INT
|
Quantité |
Remise |
remise_percent@lines |
|
>
DOUBLE
|
Remise |
Prix |
price@lines |
|
>
PRICE
|
Prix |
Taux TVA |
vat_src_code@lines |
|
>
VARCHAR
|
Taux TVA |
Phpunit_Varchar |
options_phpunit_varchar |
|
VARCHAR
|
Phpunit_Varchar |
Phpunit_Text |
options_phpunit_text |
|
TEXT
|
Phpunit_Text |
Phpunit_Int |
options_phpunit_int |
|
INT
|
Phpunit_Int |
Phpunit_Price |
options_phpunit_price |
|
PRICE
|
Phpunit_Price |
Phpunit_Mail |
options_phpunit_mail |
|
EMAIL
|
Phpunit_Mail |
Phpunit_Phone |
options_phpunit_phone |
|
PHONE
|
Phpunit_Phone |
Phpunit_Url |
options_phpunit_url |
|
URL
|
Phpunit_Url |
Phpunit_Date |
options_phpunit_date |
|
DATE
|
Phpunit_Date |
Société |
socid |
|
ThirdParty
|
Société |
Contact client facturation commande |
BILLING |
|
Address
|
Contact client facturation commande |
Contact client livraison commande |
SHIPPING |
|
Address
|
Contact client livraison commande |
Date de commande |
date |
|
DATE
|
Date de commande |
Réf. facture |
ref |
|
VARCHAR
|
Réf. facture |
Réf. client |
ref_client |
|
VARCHAR
|
Réf. client |
Réf. client Interne |
ref_int |
|
VARCHAR
|
Réf. client Interne |
Réf. externe |
ref_ext |
|
VARCHAR
|
Réf. externe |
Date limite règlement |
date_lim_reglement |
|
DATE
|
Date limite règlement |
Total HT (EUR) |
total_ht |
|
DOUBLE
|
Total HT (EUR) |
Total TTC (EUR) |
total_ttc |
|
DOUBLE
|
Total TTC (EUR) |
Facture : Brouillon |
isDraft |
|
BOOL
|
Facture : Brouillon |
Facture : Annulé |
isCanceled |
|
BOOL
|
Facture : Annulé |
Facture : Validé |
isValidated |
|
BOOL
|
Facture : Validé |
Facture : Payé |
isPaid |
|
BOOL
|
Facture : Payé |
Mode de règlement |
mode@payments |
|
>
VARCHAR
|
Mode de règlement |
Date |
date@payments |
|
>
DATE
|
Date |
Numéro |
number@payments |
|
>
VARCHAR
|
Numéro |
Montant règlement |
amount@payments |
|
>
DOUBLE
|
Montant règlement |
État |
status |
|
VARCHAR
|
État |
Definition
Canonical Type |
Address |
Objects Name |
Adresse |
Description |
Dolibarr Contact Object |
Capabilities |
Allow Push Created
|
Allow Push Updated
|
Allow Push Deleted
|
Default Configuration
Default Sync options when you first connect this server.
Imports |
Pull Created
|
Pull Update
|
Pull Deleted
|
Exports |
Push Created
|
Push Updated
|
Push Deleted
|
Available Fields
Name |
Identifier |
Flags |
Data Format |
Field Description |
Date de dernière modification |
date_modification |
|
DATE
|
Date de dernière modification |
Date création |
date_creation |
|
DATE
|
Date création |
Phpunit_Varchar |
options_phpunit_varchar |
|
VARCHAR
|
Phpunit_Varchar |
Phpunit_Text |
options_phpunit_text |
|
TEXT
|
Phpunit_Text |
Phpunit_Int |
options_phpunit_int |
|
INT
|
Phpunit_Int |
Phpunit_Price |
options_phpunit_price |
|
PRICE
|
Phpunit_Price |
Phpunit_Mail |
options_phpunit_mail |
|
EMAIL
|
Phpunit_Mail |
Phpunit_Phone |
options_phpunit_phone |
|
PHONE
|
Phpunit_Phone |
Phpunit_Url |
options_phpunit_url |
|
URL
|
Phpunit_Url |
Phpunit_Date |
options_phpunit_date |
|
DATE
|
Phpunit_Date |
Prénom |
firstname |
|
VARCHAR
|
Prénom |
Nom |
lastname |
|
VARCHAR
|
Nom |
Poste/fonction |
poste |
|
VARCHAR
|
The job title of the person (for example, Financial Manager). |
Société |
socid |
|
ThirdParty
|
Société |
Code client |
ref_ext |
|
VARCHAR
|
Code client unique pour chaque client |
Adresse |
address |
|
VARCHAR
|
Adresse |
Code postal |
zip |
|
VARCHAR
|
Code postal |
Ville |
town |
|
VARCHAR
|
Ville |
Pays |
country |
|
VARCHAR
|
Pays |
Code pays |
country_code |
|
ISO COUNTRY
|
Code pays |
Département / Canton |
state |
|
VARCHAR
|
Département / Canton |
State Code |
state_code |
|
ISO STATE
|
State Code |
Tél pro. |
phone_pro |
|
PHONE
|
Tél pro. |
Tél perso. |
phone_perso |
|
PHONE
|
Tél perso. |
Tél portable |
phone_mobile |
|
PHONE
|
Tél portable |
Email |
email |
|
EMAIL
|
Email |
Actif |
statut |
|
BOOL
|
Actif |