Objets

Détails de tous les Objets Disponibles

Definition


Canonical Type ThirdParty Objects Name ThirdParty
Description Odoo Partner
Capabilities Push Created Push Updated 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

Nom Identifiant Tags Format Description du Champs
Last Modified on __last_update  DATETIME Last Modified on
Active active  BOOL Active
Next Activity Deadline activity_date_deadline  DATE Next Activity Deadline
Activity State activity_state  VARCHAR Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
Next Activity Summary activity_summary  VARCHAR Next Activity Summary
Additional info additional_info  VARCHAR Additional info
Bank bank_account_count  INT Bank
Barcode barcode  VARCHAR Use a barcode to identify this contact from the Point of Sale.
City city  VARCHAR City
Color Index color  INT Color Index
Notes comment  VARCHAR Notes
Company Name Entity commercial_company_name  VARCHAR Company Name Entity
Company Name company_name  VARCHAR Company Name
Company Type company_type  VARCHAR Company Type
Complete Address contact_address  VARCHAR Complete Address
Contracts Count contracts_count  INT Contracts Count
Created on create_date  DATETIME Created on
Total Receivable credit  DOUBLE Total amount this customer owes you.
Credit Limit credit_limit  DOUBLE Credit Limit
Is a Customer customer  BOOL Check this box if this contact is a customer. It can be selected in sales orders.
Date date  DATE Date
Total Payable debit  DOUBLE Total amount you have to pay to this vendor.
Payable Limit debit_limit  DOUBLE Payable Limit
Display Name display_name  VARCHAR Display Name
Email email  EMAIL Email
Formatted Email email_formatted  VARCHAR Format email address "Name "
Employee employee  BOOL Check this box if this contact is an Employee.
Job Position function  VARCHAR Job Position
Has Unreconciled Entries has_unreconciled_entries  BOOL The partner has at least one unreconciled debit and credit since last time the invoices & payments matching was performed.
IM Status im_status  VARCHAR IM Status
Invoice invoice_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Invoice invoice_warn_msg  VARCHAR Message for Invoice
Blacklist is_blacklisted  BOOL If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
Is a Company is_company  BOOL Check if the contact is a company, otherwise it is a person
Journal Items journal_item_count  INT Journal Items
Language lang  VARCHAR All the emails and documents sent to this contact will be translated in this language.
Latest Invoices & Payments Matching Date last_time_entries_checked  DATETIME Last time the invoices & payments matching was performed for this partner. It is set either if there's not at least an unreconciled debit and an unreconciled credit or if you click the "Done" button.
Attachment Count message_attachment_count  INT Attachment Count
Bounce message_bounce  INT Counter of the number of bounced emails for this contact
Message Delivery error message_has_error  BOOL If checked, some messages have a delivery error.
Number of error message_has_error_counter  INT Number of messages with delivery error
Is Follower message_is_follower  BOOL Is Follower
Action Needed message_needaction  BOOL If checked, new messages require your attention.
Number of Actions message_needaction_counter  INT Number of messages which requires an action
Unread Messages message_unread  BOOL If checked new messages require your attention.
Unread Messages Counter message_unread_counter  INT Number of unread messages
Mobile mobile  VARCHAR Mobile
Name name  VARCHAR Name
Parent name parent_name  VARCHAR Parent name
Company database ID partner_gid  INT Company database ID
Share Partner partner_share  BOOL Either customer (not a user), either shared user. Indicated the current partner is a customer without access or with a limited access created for sharing data.
Count Payment Token payment_token_count  INT Count Payment Token
Phone phone  PHONE Phone
Stock Picking picking_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Stock Picking picking_warn_msg  VARCHAR Message for Stock Picking
Purchase Order Count purchase_order_count  INT Purchase Order Count
Purchase Order purchase_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Purchase Order purchase_warn_msg  VARCHAR Message for Purchase Order
Internal Reference ref  VARCHAR Internal Reference
Sale Order Count sale_order_count  INT Sale Order Count
Sales Warnings sale_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Sales Order sale_warn_msg  VARCHAR Message for Sales Order
Signup Expiration signup_expiration  DATETIME Signup Expiration
Signup Token signup_token  VARCHAR Signup Token
Signup Token Type signup_type  VARCHAR Signup Token Type
Signup URL signup_url  VARCHAR Signup URL
Signup Token is Valid signup_valid  BOOL Signup Token is Valid
Street street  VARCHAR Street
Street2 street2  VARCHAR Street2
Is a Vendor supplier  BOOL Check this box if this contact is a vendor. It can be selected in purchase orders.
# Vendor Bills supplier_invoice_count  INT # Vendor Bills
Total Invoiced total_invoiced  DOUBLE Total Invoiced
Degree of trust you have in this debtor trust  VARCHAR Degree of trust you have in this debtor
Address Type type  VARCHAR Used by Sales and Purchase Apps to select the relevant address depending on the context.
Timezone tz  VARCHAR The partner's timezone, used to output proper date and time values inside printed reports. It is important to set a value for this field. You should use the same timezone that is otherwise used to pick and render date and time values: your computer's timezone.
Timezone offset tz_offset  VARCHAR Timezone offset
Tax ID vat  VARCHAR The Tax Identification Number. Complete it if the contact is subjected to government taxes. Used in some legal statements.
Website website  URL Website
Last Updated on write_date  DATETIME Last Updated on
Zip zip  VARCHAR Zip
Image image  IMG This field holds the image used as avatar for this contact, limited to 1024x1024px
Country Code country_code  ISO COUNTRY Country Code
Country Name country_name  VARCHAR Country Name
State Code state_id  ISO STATE State Code
Legal Name legal  VARCHAR Legal Name
Last Name last  VARCHAR Last Name
First Name first  VARCHAR First Name
Parent parent_id  ThirdParty Parent

Definition


Canonical Type Order Objects Name Order
Description Odoo Order
Capabilities Push Created Push Updated 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

Nom Identifiant Tags Format Description du Champs
Legal Name __shipping__name  VARCHAR Legal Name
Contact Name __shipping__contact  VARCHAR Contact Name
Street __shipping__street  VARCHAR Street
Zip Code __shipping__zip  VARCHAR Zip Code
City Name __shipping__city  VARCHAR City Name
State Name __shipping__state_name  VARCHAR State Name
State Code __shipping__state_id  ISO STATE State Code
Country __shipping__country_name  VARCHAR Country
Country Code __shipping__country_code  ISO COUNTRY Country Code
Phone __shipping__phone  VARCHAR Phone
Mobile __shipping__mobile  VARCHAR Mobile
Last Modified on __last_update  DATETIME Last Modified on
Security Token access_token  VARCHAR Security Token
Portal Access URL access_url  VARCHAR Customer Portal URL
Access warning access_warning  VARCHAR Access warning
Next Activity Deadline activity_date_deadline  DATE Next Activity Deadline
Activity State activity_state  VARCHAR Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
Next Activity Summary activity_summary  VARCHAR Next Activity Summary
Taxes amount_tax  DOUBLE Taxes
Total amount_total  DOUBLE Total
Amount Before Discount amount_undiscounted  DOUBLE Amount Before Discount
Untaxed Amount amount_untaxed  DOUBLE Untaxed Amount
Cart Quantity cart_quantity  INT Cart Quantity
Cart recovery email already sent cart_recovery_email_sent  BOOL Cart recovery email already sent
Customer Reference client_order_ref  VARCHAR Customer Reference
Commitment Date commitment_date  DATETIME This is the delivery date promised to the customer. If set, the delivery order will be scheduled based on this date rather than product lead times.
Confirmation Date confirmation_date  DATETIME Date on which the sales order is confirmed.
Creation Date create_date  DATETIME Date on which sales order is created.
Currency Rate currency_rate  DOUBLE The rate of the currency to the currency of rate 1 applicable at the date of the order
Delivery Orders delivery_count  INT Delivery Orders
Display Name display_name  VARCHAR Display Name
Effective Date effective_date  DATE Completion date of the first delivery order.
Expected Date expected_date  DATETIME Delivery date you can promise to the customer, computed from product lead times and from the shipping policy of the order.
Invoice Count invoice_count  INT Invoice Count
Invoice Status invoice_status  VARCHAR Invoice Status
Abandoned Cart is_abandoned_cart  BOOL Abandoned Cart
Is expired is_expired  BOOL Is expired
Attachment Count message_attachment_count  INT Attachment Count
Message Delivery error message_has_error  BOOL If checked, some messages have a delivery error.
Number of error message_has_error_counter  INT Number of messages with delivery error
Is Follower message_is_follower  BOOL Is Follower
Action Needed message_needaction  BOOL If checked, new messages require your attention.
Number of Actions message_needaction_counter  INT Number of messages which requires an action
Unread Messages message_unread  BOOL If checked new messages require your attention.
Unread Messages Counter message_unread_counter  INT Number of unread messages
Order Reference name  VARCHAR Order Reference
Terms and conditions note  VARCHAR Terms and conditions
Only Services only_services  BOOL Only Services
Source Document origin  VARCHAR Reference of the document that generated this sales order request.
Shipping Policy picking_policy  VARCHAR If you deliver all products at once, the delivery order will be scheduled based on the greatest product lead time. Otherwise, it will be based on the shortest.
Number of Purchase Order purchase_order_count  INT Number of Purchase Order
Payment Ref. reference  VARCHAR The payment communication of this sale order.
Remaining Validity Days remaining_validity_days  INT Remaining Validity Days
Online Payment require_payment  BOOL Request an online payment to the customer in order to confirm orders automatically.
Online Signature require_signature  BOOL Request a online signature to the customer in order to confirm orders automatically.
Signed by signed_by  VARCHAR Name of the person that signed the SO.
Type Name type_name  VARCHAR Type Name
Validity validity_date  DATE Validity date of the quotation, after this date, the customer won't be able to validate the quotation online.
Warning warning_stock  VARCHAR Warning
Last Updated on write_date  DATETIME Last Updated on
Signature signature  IMG Signature received through the portal.
Tax amount by group amount_by_group  IMG type: [(name, amount, base, formated amount, formated base)]
Product SKU default_code@delivery  >   VARCHAR Product SKU
Ordered Qty product_uom_qty@delivery  >   INT Ordered Qty
Delivered Qty qty_delivered@delivery  >   INT Delivered Qty
Product ID product_id@lines  >   Product Product ID
Product Desc. name@lines  >   VARCHAR Product Desc.
Ordered Qty product_uom_qty@lines  >   INT Ordered Qty
Delivered Qty qty_delivered_manual@lines  >   INT Delivered Qty
Invoiced Qty qty_invoiced@lines  >   INT Invoiced Qty
Unit Price price_unit@lines  >   PRICE Unit Price
Discount discount@lines  >   DOUBLE Discount
Tax Name tax_name@lines  >   VARCHAR Tax Name
Taxes tax_names@lines  >    Taxes
Product Ref. product_ref@lines  >   VARCHAR Product Ref.
Customer LeadTime lead_time@lines  >   DOUBLE Customer LeadTime
Line Status state@lines  >   VARCHAR Line Status
Customer partner_id  ThirdParty Customer
Invoice Address partner_invoice_id  Address Invoice Address
Shipping Address partner_shipping_id  Address Shipping Address
Order Date date_order  DATE Order Date
Salesperson Name user_id  VARCHAR Salesperson Name
Salesperson Email user_email  VARCHAR Salesperson Email
Sales team Name team_id  VARCHAR Sales team Name
Order Status state  VARCHAR Order Status
Is canceled isCanceled  BOOL Is canceled
Is Validated isValidated  BOOL Is Validated
Is Processing isProcessing  BOOL Is Processing
Is Closed isClosed  BOOL Is Closed

Definition


Canonical Type Address Objects Name Address
Description Odoo Address
Capabilities Push Created Push Updated 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

Nom Identifiant Tags Format Description du Champs
Last Name last  VARCHAR Last Name
First Name first  VARCHAR First Name
Last Modified on __last_update  DATETIME Last Modified on
Active active  BOOL Active
Next Activity Deadline activity_date_deadline  DATE Next Activity Deadline
Activity State activity_state  VARCHAR Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
Next Activity Summary activity_summary  VARCHAR Next Activity Summary
Additional info additional_info  VARCHAR Additional info
Bank bank_account_count  INT Bank
Barcode barcode  VARCHAR Use a barcode to identify this contact from the Point of Sale.
Color Index color  INT Color Index
Notes comment  VARCHAR Notes
Company Name Entity commercial_company_name  VARCHAR Company Name Entity
Company Type company_type  VARCHAR Company Type
Complete Address contact_address  VARCHAR Complete Address
Contracts Count contracts_count  INT Contracts Count
Created on create_date  DATETIME Created on
Total Receivable credit  DOUBLE Total amount this customer owes you.
Is a Customer customer  BOOL Check this box if this contact is a customer. It can be selected in sales orders.
Date date  DATE Date
Total Payable debit  DOUBLE Total amount you have to pay to this vendor.
Payable Limit debit_limit  DOUBLE Payable Limit
Display Name display_name  VARCHAR Display Name
Email email  EMAIL Email
Formatted Email email_formatted  VARCHAR Format email address "Name "
Employee employee  BOOL Check this box if this contact is an Employee.
Job Position function  VARCHAR Job Position
Has Unreconciled Entries has_unreconciled_entries  BOOL The partner has at least one unreconciled debit and credit since last time the invoices & payments matching was performed.
IM Status im_status  VARCHAR IM Status
Invoice invoice_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Invoice invoice_warn_msg  VARCHAR Message for Invoice
Blacklist is_blacklisted  BOOL If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
Is a Company is_company  BOOL Check if the contact is a company, otherwise it is a person
Journal Items journal_item_count  INT Journal Items
Language lang  VARCHAR All the emails and documents sent to this contact will be translated in this language.
Latest Invoices & Payments Matching Date last_time_entries_checked  DATETIME Last time the invoices & payments matching was performed for this partner. It is set either if there's not at least an unreconciled debit and an unreconciled credit or if you click the "Done" button.
Attachment Count message_attachment_count  INT Attachment Count
Bounce message_bounce  INT Counter of the number of bounced emails for this contact
Message Delivery error message_has_error  BOOL If checked, some messages have a delivery error.
Number of error message_has_error_counter  INT Number of messages with delivery error
Is Follower message_is_follower  BOOL Is Follower
Action Needed message_needaction  BOOL If checked, new messages require your attention.
Number of Actions message_needaction_counter  INT Number of messages which requires an action
Unread Messages message_unread  BOOL If checked new messages require your attention.
Unread Messages Counter message_unread_counter  INT Number of unread messages
Mobile mobile  PHONE Mobile
Name name  VARCHAR Name
Parent name parent_name  VARCHAR Parent name
Company database ID partner_gid  INT Company database ID
Share Partner partner_share  BOOL Either customer (not a user), either shared user. Indicated the current partner is a customer without access or with a limited access created for sharing data.
Count Payment Token payment_token_count  INT Count Payment Token
Phone phone  PHONE Phone
Stock Picking picking_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Stock Picking picking_warn_msg  VARCHAR Message for Stock Picking
Purchase Order Count purchase_order_count  INT Purchase Order Count
Purchase Order purchase_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Purchase Order purchase_warn_msg  VARCHAR Message for Purchase Order
Internal Reference ref  VARCHAR Internal Reference
Sale Order Count sale_order_count  INT Sale Order Count
Sales Warnings sale_warn  VARCHAR Selecting the "Warning" option will notify user with the message, Selecting "Blocking Message" will throw an exception with the message and block the flow. The Message has to be written in the next field.
Message for Sales Order sale_warn_msg  VARCHAR Message for Sales Order
Signup Expiration signup_expiration  DATETIME Signup Expiration
Signup Token signup_token  VARCHAR Signup Token
Signup Token Type signup_type  VARCHAR Signup Token Type
Signup URL signup_url  VARCHAR Signup URL
Signup Token is Valid signup_valid  BOOL Signup Token is Valid
Is a Vendor supplier  BOOL Check this box if this contact is a vendor. It can be selected in purchase orders.
# Vendor Bills supplier_invoice_count  INT # Vendor Bills
Total Invoiced total_invoiced  DOUBLE Total Invoiced
Degree of trust you have in this debtor trust  VARCHAR Degree of trust you have in this debtor
Address Type type  VARCHAR Used by Sales and Purchase Apps to select the relevant address depending on the context.
Timezone tz  VARCHAR The partner's timezone, used to output proper date and time values inside printed reports. It is important to set a value for this field. You should use the same timezone that is otherwise used to pick and render date and time values: your computer's timezone.
Timezone offset tz_offset  VARCHAR Timezone offset
Website website  URL Website
Last Updated on write_date  DATETIME Last Updated on
Image image  IMG This field holds the image used as avatar for this contact, limited to 1024x1024px
Street street  VARCHAR Street
ZIP Code zip  VARCHAR ZIP Code
City Name city  VARCHAR City Name
Country Code country_code  ISO COUNTRY Country Code
Country Name country_name  VARCHAR Country Name
State Code state_id  ISO STATE State Code
Parent parent_id  ThirdParty Parent

Definition


Canonical Type Product Objects Name Product
Description Odoo Product
Capabilities Push Created Push Updated 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

Nom Identifiant Tags Format Description du Champs
Attr Code code@attributes  >   VARCHAR Attr Code
Attr Name name@attributes  >   VARCHAR Attr Name
Attr Value value_fr_FR@attributes  >   VARCHAR [French / Français] Attr Value
Attr Value value@attributes  >   VARCHAR [English] Attr Value
Extra Price price_extra@attributes  >   DOUBLE Extra Price
Last Modified on __last_update  DATETIME Last Modified on
Active active  BOOL If unchecked, it will allow you to hide the product without removing it.
Next Activity Deadline activity_date_deadline  DATE Next Activity Deadline
Activity State activity_state  VARCHAR Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
Next Activity Summary activity_summary  VARCHAR Next Activity Summary
Availability Threshold available_threshold  DOUBLE Availability Threshold
Barcode barcode  VARCHAR International Article Number used for product identification.
Cart Qty cart_qty  INT Cart Qty
Reference code  VARCHAR Reference
Color Index color  INT Color Index
Created on create_date  DATETIME Created on
Custom Message custom_message_fr_FR  VARCHAR Custom Message [French / Français]
Custom Message custom_message  VARCHAR Custom Message [English]
Internal Reference default_code  VARCHAR Internal Reference
Description description_fr_FR  VARCHAR Description [French / Français]
Description description  VARCHAR Description [English]
Description on Picking description_picking_fr_FR  VARCHAR Description on Picking [French / Français]
Description on Picking description_picking  VARCHAR Description on Picking [English]
Description on Receptions description_pickingin_fr_FR  VARCHAR Description on Receptions [French / Français]
Description on Receptions description_pickingin  VARCHAR Description on Receptions [English]
Description on Delivery Orders description_pickingout_fr_FR  VARCHAR Description on Delivery Orders [French / Français]
Description on Delivery Orders description_pickingout  VARCHAR Description on Delivery Orders [English]
Purchase Description description_purchase_fr_FR  VARCHAR Purchase Description [French / Français]
Purchase Description description_purchase  VARCHAR Purchase Description [English]
Sale Description description_sale_fr_FR  VARCHAR Sale Description [French / Français]
Sale Description description_sale  VARCHAR Sale Description [English]
Display Name display_name  VARCHAR Display Name
Re-Invoice Policy expense_policy  VARCHAR Expenses and vendor bills can be re-invoiced to a customer.With this option, a validated expense can be re-invoice to a customer at its cost or sales price.
Hide Expense Policy hide_expense_policy  BOOL Hide Expense Policy
Incoming incoming_qty  DOUBLE Quantity of planned incoming products. In a context with a single Stock Location, this includes goods arriving to this Location, or any of its children. In a context with a single Warehouse, this includes goods arriving to the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods arriving to any Stock Location with 'internal' type.
Inventory Availability inventory_availability  VARCHAR Adds an inventory availability status on the web product page.
Invoicing Policy invoice_policy  VARCHAR Ordered Quantity: Invoice quantities ordered by the customer. Delivered Quantity: Invoice quantities delivered to the customer.
Is Product Variant is_product_variant  BOOL Is Product Variant
Is published is_published  BOOL Is published
SEO optimized is_seo_optimized  BOOL SEO optimized
Attachment Count message_attachment_count  INT Attachment Count
Message Delivery error message_has_error  BOOL If checked, some messages have a delivery error.
Number of error message_has_error_counter  INT Number of messages with delivery error
Is Follower message_is_follower  BOOL Is Follower
Action Needed message_needaction  BOOL If checked, new messages require your attention.
Number of Actions message_needaction_counter  INT Number of messages which requires an action
Unread Messages message_unread  BOOL If checked new messages require your attention.
Name name_fr_FR  VARCHAR Name [French / Français]
Name name  VARCHAR Name [English]
Reordering Rules nbr_reordering_rules  INT Reordering Rules
Outgoing outgoing_qty  DOUBLE Quantity of planned outgoing products. In a context with a single Stock Location, this includes goods leaving this Location, or any of its children. In a context with a single Warehouse, this includes goods leaving the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods leaving any Stock Location with 'internal' type.
Customer Ref partner_ref  VARCHAR Customer Ref
# Product Variants product_variant_count  INT # Product Variants
Costing Method property_cost_method  VARCHAR Standard Price: The products are valued at their standard cost defined on the product. Average Cost (AVCO): The products are valued at weighted average cost. First In First Out (FIFO): The products are valued supposing those that enter the company first will also leave it first.
Inventory Valuation property_valuation  VARCHAR Manual: The accounting entries to value the inventory are not posted automatically. Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company.
Message for Purchase Order Line purchase_line_warn_msg  VARCHAR Message for Purchase Order Line
Control Policy purchase_method  VARCHAR On ordered quantities: Control bills based on ordered quantities. On received quantities: Control bills based on received quantities.
Can be Purchased purchase_ok  BOOL Can be Purchased
Purchased purchased_product_qty  DOUBLE Purchased
Quantity qty_at_date  DOUBLE Quantity
Quantity On Hand qty_available  DOUBLE Current quantity of products. In a context with a single Stock Location, this includes goods stored at this Location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. stored in the Stock Location of the Warehouse of this Shop, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
Rating count rating_count  INT Rating count
Rating Last Value rating_last_value  DOUBLE Rating Last Value
Can be Rent rental  BOOL Can be Rent
Reordering Max Qty reordering_max_qty  DOUBLE Reordering Max Qty
Reordering Min Qty reordering_min_qty  DOUBLE Reordering Min Qty
Customer Lead Time sale_delay  DOUBLE Delivery lead time, in days. It's the number of days, promised to the customer, between the confirmation of the sales order and the delivery.
Message for Sales Order Line sale_line_warn_msg  VARCHAR Message for Sales Order Line
Can be Sold sale_ok  BOOL Can be Sold
Sold sales_count  DOUBLE Sold
Sequence sequence  INT Gives the sequence order when displaying a product list
Track Service service_type  VARCHAR Manually set quantities on order: Invoice based on the manually entered quantity, without creating an analytic account. Timesheets on contract: Invoice based on the tracked hours on the related timesheet. Create a task and track hours: Create a task on the sales order validation and track the work hours.
Value stock_value  DOUBLE Value
Product Type type  VARCHAR A storable product is a product for which you manage stock. The Inventory app has to be installed. A consumable product is a product for which stock is not managed. A service is a non-material product you provide.
Unit of Measure Name uom_name_fr_FR  VARCHAR Unit of Measure Name [French / Français]
Unit of Measure Name uom_name  VARCHAR Unit of Measure Name [English]
Forecast Quantity virtual_available  DOUBLE Forecast quantity (computed as Quantity On Hand - Outgoing + Incoming) In a context with a single Stock Location, this includes goods stored in this location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.
Volume volume  DOUBLE The volume in m3.
Website meta description website_meta_description_fr_FR  VARCHAR Website meta description [French / Français]
Website meta description website_meta_description  VARCHAR Website meta description [English]
Website meta keywords website_meta_keywords_fr_FR  VARCHAR Website meta keywords [French / Français]
Website meta keywords website_meta_keywords  VARCHAR Website meta keywords [English]
Website opengraph image website_meta_og_img  VARCHAR Website opengraph image
Website meta title website_meta_title_fr_FR  VARCHAR Website meta title [French / Français]
Website meta title website_meta_title  VARCHAR Website meta title [English]
Website price website_price  DOUBLE Website price
Website price difference website_price_difference  BOOL Website price difference
Website public price website_public_price  DOUBLE Website public price
Visible on current website website_published  BOOL Visible on current website
Website Sequence website_sequence  INT Determine the display order in the Website E-commerce
Size X website_size_x  INT Size X
Size Y website_size_y  INT Size Y
Website URL website_url  URL The full URL to access the document through the website.
Weight weight  DOUBLE Weight of the product, packaging not included. The unit of measure can be changed in the general settings
Weight unit of measure label weight_uom_name_fr_FR  VARCHAR Weight unit of measure label [French / Français]
Weight unit of measure label weight_uom_name  VARCHAR Weight unit of measure label [English]
Last Updated on write_date  DATETIME Last Updated on
Image image@Images  >   IMG Image
Position position@Images  >   INT Position
Is Visible visible@Images  >   BOOL Is Visible
Is Cover cover@Images  >   BOOL Is Cover
Base Price (tax excl.) list_price  PRICE Base Price for this Product & Variants.
Variant Extra Price variant_price_extra  PRICE Variant Extra Price
Buy Price standard_price  PRICE Buy Price
Categorie Id categ_id  VARCHAR Categorie Id
Categorie categ  VARCHAR Categorie
Routes Ids route_ids  VARCHAR Routes Ids
Routes routes  VARCHAR Routes
Categorie Id public_categ_ids  VARCHAR Categorie Id
Public Categorie public_categ  VARCHAR Public Categorie
Alternate Products Names alternative_products  VARCHAR Alternate Products Names
Accessory Products Names accessory_products  VARCHAR Accessory Products Names
Supplier Name supplier_name  VARCHAR Supplier Name
Supplier Price (Float) supplier_price_dbl  DOUBLE Supplier Price (Float)
Supplier Price supplier_price  PRICE Supplier Price
Supplier SKU supplier_sku  VARCHAR Supplier SKU
Supplier MOQ supplier_min_qty  INT Supplier MOQ
Supplier Currency supplier_currency  ISO CURRENCY Supplier Currency
Template ID variant_template  VARCHAR Template ID
Variant ID id@variants  >   Product Variant ID
Variant SKU sku@variants  >   VARCHAR Variant SKU

Definition


Canonical Type Invoice Objects Name Invoice
Description Odoo Invoice
Capabilities Push Created Push Updated 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

Nom Identifiant Tags Format Description du Champs
Legal Name __shipping__name  VARCHAR Legal Name
Contact Name __shipping__contact  VARCHAR Contact Name
Street __shipping__street  VARCHAR Street
Zip Code __shipping__zip  VARCHAR Zip Code
City Name __shipping__city  VARCHAR City Name
State Name __shipping__state_name  VARCHAR State Name
State Code __shipping__state_id  ISO STATE State Code
Country __shipping__country_name  VARCHAR Country
Country Code __shipping__country_code  ISO COUNTRY Country Code
Phone __shipping__phone  VARCHAR Phone
Mobile __shipping__mobile  VARCHAR Mobile
Last Modified on __last_update  DATETIME Last Modified on
Security Token access_token  VARCHAR Security Token
Portal Access URL access_url  VARCHAR Customer Portal URL
Access warning access_warning  VARCHAR Access warning
Next Activity Deadline activity_date_deadline  DATE Next Activity Deadline
Activity State activity_state  VARCHAR Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
Tax amount_tax  DOUBLE Tax
Tax in Invoice Currency amount_tax_signed  DOUBLE Tax in Invoice Currency
Total amount_total  DOUBLE Total
Total in Company Currency amount_total_company_signed  DOUBLE Total amount in the currency of the company, negative for credit notes.
Total in Invoice Currency amount_total_signed  DOUBLE Total amount in the currency of the invoice, negative for credit notes.
Untaxed Amount amount_untaxed  DOUBLE Untaxed Amount
Untaxed Amount in Invoice Currency amount_untaxed_invoice_signed  DOUBLE Untaxed Amount in Invoice Currency
Untaxed Amount in Company Currency amount_untaxed_signed  DOUBLE Untaxed Amount in Company Currency
Additional Information comment  VARCHAR Additional Information
Created on create_date  DATETIME Created on
Accounting Date date  DATE Keep empty to use the invoice date.
Due Date date_due  DATE If you use payment terms, the due date will be computed automatically at the generation of accounting entries. The Payment terms may compute several due dates, for example 50% now and 50% in one month, but if you want to force a due date, make sure that the payment term is not set on the invoice. If you keep the Payment terms and the due date empty, it means direct payment.
Display Name display_name  VARCHAR Display Name
Has Outstanding has_outstanding  BOOL Has Outstanding
Invoice Icon invoice_icon  VARCHAR Invoice Icon
Attachment Count message_attachment_count  INT Attachment Count
Message Delivery error message_has_error  BOOL If checked, some messages have a delivery error.
Number of error message_has_error_counter  INT Number of messages with delivery error
Is Follower message_is_follower  BOOL Is Follower
Action Needed message_needaction  BOOL If checked, new messages require your attention.
Number of Actions message_needaction_counter  INT Number of messages which requires an action
Reference/Description name  VARCHAR The name that will be used on account move lines
Number number  VARCHAR Number
Source Document origin  VARCHAR Reference of the document that produced this invoice.
Outstanding Credits Debits Widget outstanding_credits_debits_widget  VARCHAR Outstanding Credits Debits Widget
Payments Widget payments_widget  VARCHAR Payments Widget
Paid/Reconciled reconciled  BOOL It indicates that the invoice has been paid and the journal entry of the invoice has been reconciled with one or several journal entries of payment.
Payment Ref. reference  VARCHAR The payment communication that will be automatically populated once the invoice validation. You can also write a free communication.
Amount Due residual  DOUBLE Remaining amount due.
Amount Due in Company Currency residual_company_signed  DOUBLE Remaining amount due in the currency of the company.
Amount Due in Invoice Currency residual_signed  DOUBLE Remaining amount due in the currency of the invoice.
Sent sent  BOOL It indicates that the invoice has been sent.
Next Number sequence_number_next  VARCHAR Next Number
Next Number Prefix sequence_number_next_prefix  VARCHAR Next Number Prefix
Source Email source_email  VARCHAR Source Email
Type type  VARCHAR Type
Vendor Display Name vendor_display_name  VARCHAR Vendor Display Name
Last Updated on write_date  DATETIME Last Updated on
Tax amount by group amount_by_group  IMG type: [(name, amount, base, formated amount, formated base)]
Customer partner_id  ThirdParty Customer
Shipping Address partner_shipping_id  Address Shipping Address
Invoice Date date_invoice  DATE Invoice Date
Product ID product_id@lines  >   Product Product ID
Product Desc. name@lines  >   VARCHAR Product Desc.
Invoiced Qty quantity@lines  >   INT Invoiced Qty
Unit Price price_unit@lines  >   PRICE Unit Price
Discount discount@lines  >   DOUBLE Discount
Tax Name tax_name@lines  >   VARCHAR Tax Name
Taxes tax_names@lines  >    Taxes
Product Ref. product_ref@lines  >   VARCHAR Product Ref.
Method journal_code@payments  >   VARCHAR Method
Journal journal_name@payments  >   VARCHAR Journal
Journal Type journal_type@payments  >   VARCHAR Journal Type
Type payment_type@payments  >   VARCHAR Type
Status state@payments  >   VARCHAR Status
Date payment_date@payments  >   DATE Date
Number name@payments  >   VARCHAR Number
Amount amount@payments  >   DOUBLE Amount
Salesperson Name user_id  VARCHAR Salesperson Name
Salesperson Email user_email  VARCHAR Salesperson Email
Sales team Name team_id  VARCHAR Sales team Name
Invoice Status state  VARCHAR Invoice Status
Is Draft isDraft  BOOL Is Draft
Is canceled isCanceled  BOOL Is canceled
Is Validated isValidated  BOOL Is Validated
Is Paid isPaid  BOOL Is Paid