Canonical Type | ThirdParty | Objects Name | ThirdParty |
Description | Odoo Partner | ||
Capabilities | Push Created | Push Updated | Push Deleted |
Default Sync options when you first connect this server.
Imports | Pull Created | Pull Update | Pull Deleted |
Exports | Push Created | Push Updated | Push Deleted |
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 | |
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 |
Canonical Type | Order | Objects Name | Order |
Description | Odoo Order | ||
Capabilities | Push Created | Push Updated | Push Deleted |
Default Sync options when you first connect this server.
Imports | Pull Created | Pull Update | Pull Deleted |
Exports | Push Created | Push Updated | Push Deleted |
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 |
Canonical Type | Address | Objects Name | Address |
Description | Odoo Address | ||
Capabilities | Push Created | Push Updated | Push Deleted |
Default Sync options when you first connect this server.
Imports | Pull Created | Pull Update | Pull Deleted |
Exports | Push Created | Push Updated | Push Deleted |
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 | |
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 |
Canonical Type | Product | Objects Name | Product |
Description | Odoo Product | ||
Capabilities | Push Created | Push Updated | Push Deleted |
Default Sync options when you first connect this server.
Imports | Pull Created | Pull Update | Pull Deleted |
Exports | Push Created | Push Updated | Push Deleted |
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 |
Canonical Type | Invoice | Objects Name | Invoice |
Description | Odoo Invoice | ||
Capabilities | Push Created | Push Updated | Push Deleted |
Default Sync options when you first connect this server.
Imports | Pull Created | Pull Update | Pull Deleted |
Exports | Push Created | Push Updated | Push Deleted |
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 |