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