Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: sale > Tables

order

Sales Order

Catalog: Odoo

Schema: sale

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table order are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

access_token

string

Security Token

 

access_url

string

Portal Access URL

Customer Portal URL

access_warning

string

Access warning

 

activity_calendar_event_id_label

string

 

 

activity_calendar_event_id

string

 

 

activity_date_deadline

datetime

Next Activity Deadline

 

activity_exception_decoration

string

Activity Exception Decoration

Type of the exception activity on record.

activity_exception_icon

string

Icon

Icon to indicate an exception activity.

activity_ids

string

 

 

activity_state

string

Activity State

Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.

activity_summary

string

Next Activity Summary

 

activity_type_icon

string

Activity Type Icon

Font awesome icon e.g. fa-tasks

activity_type_id_label

string

 

 

activity_type_id

string

 

 

activity_user_id_label

string

 

 

activity_user_id

string

 

 

amazon_channel

string

Fulfillment Channel

 

amazon_order_ref

string

Amazon Reference

The Amazon-defined order reference.

amount_delivery

decimal

Delivery Amount

The amount without tax.

amount_tax

decimal

Taxes

 

amount_total

decimal

Total

 

amount_undiscounted

decimal

Amount Before Discount

 

amount_unpaid

decimal

Unpaid Amount

The amount due from the sale order.

amount_untaxed

decimal

Untaxed Amount

 

analytic_account_id_label

string

 

 

analytic_account_id

string

 

 

archived_product_count

int32

Archived Product

 

archived_product_ids

string

 

 

attendee_count

int32

Attendee Count

 

authorized_transaction_ids

string

 

 

campaign_id_label

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

campaign_id

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

carrier_id_label

string

 

Fill this field if you plan to invoice the shipping based on picking.

carrier_id

string

 

Fill this field if you plan to invoice the shipping based on picking.

cart_quantity

int32

Cart Quantity

 

cart_recovery_email_sent

boolean

Cart recovery email already sent

 

client_order_ref

string

Customer Reference

 

close_reason_id_label

string

 

 

close_reason_id

string

 

 

commercial_partner_id_label

string

 

 

commercial_partner_id

string

 

 

commitment_date

datetime

Delivery Date

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.

company_id_label

string

 

 

company_id

string

 

 

country_code

string

Country code

The ISO country code in two chars. You can use this field for quick search.

country_id_label

string

 

 

country_id

string

 

 

create_date

datetime

Creation Date

 

create_uid_label

string

 

 

create_uid

string

 

 

currency_id_label

string

 

 

currency_id

string

 

 

currency_rate

decimal

Currency Rate

 

date_order

datetime

Order Date

Creation date of draft/sent orders,Confirmation date of confirmed orders.

delivery_count

int32

Delivery Orders

 

delivery_message

string

Delivery Message

 

delivery_rating_success

boolean

Delivery Rating Success

 

delivery_set

boolean

Delivery Set

 

delivery_status

string

Delivery Status

 

display_name

string

Display Name

 

effective_date

datetime

Effective Date

Completion date of the first delivery order.

end_date

datetime

End Date

If set in advance, the subscription will be set to renew 1 month before the date and will be closed on the date set in this field.

expected_date

datetime

Expected Date

Delivery date you can promise to the customer, computed from the minimum lead time of the order lines in case of Service products. In case of shipping, the shipping policy of the order will be taken into account to either use the minimum or maximum lead time of the order lines.

expense_count

int32

# of Expenses

 

expense_ids

string

 

 

fedex_access_point_address

string

Fedex Address

 

first_contract_date

datetime

First Contract Date

The first contract date is the start date of the first contract of the sequence. It is common across a subscription and its renewals.

fiscal_position_id_label

string

 

Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices.The default value comes from the customer.

fiscal_position_id

string

 

Fiscal positions are used to adapt taxes and accounts for particular customers or sales orders/invoices.The default value comes from the customer.

has_late_lines

boolean

Has Late Lines

 

has_message

boolean

Has Message

 

has_pickable_lines

boolean

Has Pickable Lines

 

has_recurring_line

boolean

Has Recurring Line

 

has_rented_products

boolean

Has Rented Products

 

has_returnable_lines

boolean

Has Returnable Lines

 

health

string

Health

Show the health status

history_count

int32

History Count

 

id

int32

ID

 

incoterm_label

string

 

International Commercial Terms are a series of predefined commercial terms used in international transactions.

incoterm_location

string

Incoterm Location

 

incoterm

string

 

International Commercial Terms are a series of predefined commercial terms used in international transactions.

industry_id_label

string

 

 

industry_id

string

 

 

internal_note

string

Internal Note

 

invoice_count

int32

Invoice Count

 

invoice_ids

string

 

 

invoice_status

string

Invoice Status

 

is_abandoned_cart

boolean

Abandoned Cart

 

is_all_service

boolean

Service Product

 

is_batch

boolean

Is Batch

 

is_expired

boolean

Is Expired

 

is_invoice_cron

boolean

Is a Subscription invoiced in cron

 

is_product_milestone

boolean

Is Product Milestone

 

is_rental_order

boolean

Created In App Rental

 

is_subscription

boolean

Recurring

 

is_upselling

boolean

Is Upselling

 

json_popover

string

JSON data for the popover widget

 

kpi_1month_mrr_delta

decimal

KPI 1 Month MRR Delta

 

kpi_1month_mrr_percentage

decimal

KPI 1 Month MRR Percentage

 

kpi_3months_mrr_delta

decimal

KPI 3 months MRR Delta

 

kpi_3months_mrr_percentage

decimal

KPI 3 Months MRR Percentage

 

last_invoice_date

datetime

Last invoice date

 

medium_id_label

string

 

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

medium_id

string

 

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

message_attachment_count

int32

Attachment Count

 

message_follower_ids

string

 

 

message_has_error_counter

int32

Number of errors

Number of messages with delivery error

message_has_error

boolean

Message Delivery error

If checked, some messages have a delivery error.

message_has_sms_error

boolean

SMS Delivery error

If checked, some messages have a delivery error.

message_ids

string

 

 

message_is_follower

boolean

Is Follower

 

message_main_attachment_id_label

string

 

 

message_main_attachment_id

string

 

 

message_needaction_counter

int32

Number of Actions

Number of messages which requires an action

message_needaction

boolean

Action Needed

If checked, new messages require your attention.

message_partner_ids

string

 

 

milestone_count

int32

Milestone Count

 

mrp_production_count

int32

Count of MO generated

 

mrp_production_ids

string

 

 

my_activity_date_deadline

datetime

My Activity Deadline

 

name

string

Order Reference

 

next_action_date

datetime

Next Action

 

next_invoice_date

datetime

Date of Next Invoice

The next invoice will be created on this date then the period will be extended.

note

string

Terms and conditions

 

only_services

boolean

Only Services

 

opportunity_id_label

string

 

 

opportunity_id

string

 

 

order_line

string

 

 

order_log_ids

string

 

 

origin_order_id_label

string

 

 

origin_order_id

string

 

 

origin

string

Source Document

Reference of the document that generated this sales order request

partner_credit_warning

string

Partner Credit Warning

 

partner_id_label

string

 

 

partner_id

string

 

 

partner_invoice_id_label

string

 

 

partner_invoice_id

string

 

 

partner_shipping_id_label

string

 

 

partner_shipping_id

string

 

 

partner_ups_carrier_account

string

UPS account number

 

payment_exception

boolean

Contract in exception

Automatic payment with token failed. The payment provider configuration and token should be checked

payment_term_id_label

string

 

 

payment_term_id

string

 

 

payment_token_id_label

string

 

If not set, the automatic payment will fail.

payment_token_id

string

 

If not set, the automatic payment will fail.

percentage_satisfaction

int32

% Happy

Calculate the ratio between the number of the best ('great') ratings and the total number of ratings

picking_ids

string

 

 

picking_policy

string

Shipping Policy

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.

planning_first_sale_line_id_label

string

 

 

planning_first_sale_line_id

string

 

 

planning_hours_planned

decimal

Planning Hours Planned

 

planning_hours_to_plan

decimal

Planning Hours To Plan

 

planning_initial_date

datetime

Planning Initial Date

 

pos_order_count

int32

Pos Order Count

 

pos_order_line_ids

string

 

 

pricelist_id_label

string

 

If you change the pricelist, only newly added lines will be affected.

pricelist_id

string

 

If you change the pricelist, only newly added lines will be affected.

procurement_group_id_label

string

 

 

procurement_group_id

string

 

 

project_count

int32

Number of Projects

 

project_id_label

string

 

Select a non billable project on which tasks can be created.

project_id

string

 

Select a non billable project on which tasks can be created.

project_ids

string

 

Projects used in this sales order.

purchase_order_count

int32

Number of Purchase Order Generated

 

rating_avg_text

string

Rating Avg Text

 

rating_avg

decimal

Average Rating

 

rating_count

int32

Rating count

 

rating_ids

string

 

 

rating_last_feedback

string

Rating Last Feedback

 

rating_last_image

byte[]

Rating Last Image

 

rating_last_text

string

Rating Text

 

rating_last_value

decimal

Rating Last Value

 

rating_percentage_satisfaction

decimal

Rating Satisfaction

 

recompute_delivery_price

boolean

Delivery cost should be recomputed

 

recurrence_id_label

string

 

 

recurrence_id

string

 

 

recurring_details

string

Recurring Details

 

recurring_live

boolean

Alive

 

recurring_monthly

decimal

Monthly Recurring Revenue

 

reference

string

Payment Ref.

The payment communication of this sale order.

renew_state

string

Renew State

 

rental_status

string

Rental Status

 

require_payment

boolean

Online Payment

 

require_signature

boolean

Online Signature

Request a online signature and/or payment to the customer in order to confirm orders automatically.

sale_order_option_ids

string

 

 

sale_order_template_id_label

string

 

 

sale_order_template_id

string

 

 

shipping_weight

decimal

Shipping Weight

 

shop_warning

string

Warning

 

show_json_popover

boolean

Has late picking

 

show_rec_invoice_button

boolean

Show Rec Invoice Button

 

show_update_fpos

boolean

Has Fiscal Position Changed

 

show_update_pricelist

boolean

Has Pricelist Changed

 

signature

byte[]

Signature

 

signed_by

string

Signed By

 

signed_on

datetime

Signed On

 

source_id_label

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

source_id

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

stage_category

string

Category

 

stage_id_label

string

 

 

stage_id

string

 

 

starred_user_ids

string

 

 

starred

boolean

Show Subscription on dashboard

Whether this subscription should be displayed on the dashboard or not

start_date

datetime

Start Date

The start date indicate when the subscription periods begin.

state

string

Status

 

subscription_child_ids

string

 

 

subscription_id_label

string

 

 

subscription_id

string

 

 

subscription_management

string

Subscription Management

Creation: The Sales Order created the subscriptionUpsell: The Sales Order added lines to the subscriptionRenewal: The Sales Order replaced the subscription's content with its own

tag_ids

string

 

 

task_id_label

string

 

Task from which this quotation have been created

task_id

string

 

Task from which this quotation have been created

tasks_count

int32

Tasks

 

tasks_ids

string

 

 

tax_country_id_label

string

 

 

tax_country_id

string

 

 

tax_totals

byte[]

Tax Totals

 

team_id_label

string

 

 

team_id

string

 

 

team_user_id_label

string

 

 

team_user_id

string

 

 

terms_type

string

Terms & Conditions format

 

timesheet_count

decimal

Timesheet activities

 

timesheet_encode_uom_id_label

string

 

 

timesheet_encode_uom_id

string

 

 

timesheet_ids

string

 

 

timesheet_total_duration

int32

Timesheet Total Duration

Total recorded duration, expressed in the encoding UoM, and rounded to the unit

to_renew

boolean

To Renew

 

transaction_ids

string

 

 

type_name

string

Type Name

 

ups_bill_my_account

boolean

Bill My Account

If checked, ecommerce users will be prompted their UPS account numberand delivery fees will be charged on it.

user_id_label

string

 

 

user_id

string

 

 

validity_date

datetime

Expiration

 

visible_project

boolean

Display project

 

warehouse_id_label

string

 

 

warehouse_id

string

 

 

website_id_label

string

 

Website through which this order was placed for eCommerce orders.

website_id

string

 

Website through which this order was placed for eCommerce orders.

website_message_ids

string

 

Website communication history

website_order_line

string

 

 

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer