---
title: "order (Odoo)"
description: "itgen_odoo_order"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/odoo/Odoo.sale.order
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.sale.order
updated: 2026-11-18T01:06:37Z
license: https://documentation.invantive.eu/it/
---

# order: Odoo itgen_odoo_order

`read only` `per partition`

- Catalogo: `Odoo`
- Schema: `sale`
- Etichetta: itgen_odoo_order

Ordine di vendita

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `order`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `access_token` | `varchar2` | Security Token | [ ] |  |  |
| `access_url` | `varchar2` | Portal Access URL | [ ] |  | Customer Portal URL |
| `access_warning` | `varchar2` | Access warning | [ ] |  |  |
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `amazon_channel` | `varchar2` | Fulfillment Channel | [ ] |  |  |
| `amazon_order_ref` | `varchar2` | Amazon Reference | [ ] |  | The Amazon-defined order reference. |
| `amount_delivery` | `numeric` | Delivery Amount | [ ] |  | The amount without tax. |
| `amount_tax` | `numeric` | Taxes | [ ] |  |  |
| `amount_total` | `numeric` | Total | [ ] |  |  |
| `amount_undiscounted` | `numeric` | Amount Before Discount | [ ] |  |  |
| `amount_unpaid` | `numeric` | Unpaid Amount | [ ] |  | The amount due from the sale order. |
| `amount_untaxed` | `numeric` | Untaxed Amount | [ ] |  |  |
| `analytic_account_id` | `varchar2` |  | [ ] |  |  |
| `analytic_account_id_label` | `varchar2` |  | [ ] |  |  |
| `archived_product_count` | `int32` | Archived Product | [ ] |  |  |
| `archived_product_ids` | `varchar2` |  | [ ] |  |  |
| `attendee_count` | `int32` | Attendee Count | [ ] |  |  |
| `authorized_transaction_ids` | `varchar2` |  | [ ] |  |  |
| `campaign_id` | `varchar2` |  | [ ] |  | This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
| `campaign_id_label` | `varchar2` |  | [ ] |  | This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
| `carrier_id` | `varchar2` |  | [ ] |  | Fill this field if you plan to invoice the shipping based on picking. |
| `carrier_id_label` | `varchar2` |  | [ ] |  | 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` | `varchar2` | Referenza del cliente | [ ] |  |  |
| `close_reason_id` | `varchar2` |  | [ ] |  |  |
| `close_reason_id_label` | `varchar2` |  | [ ] |  |  |
| `commercial_partner_id` | `varchar2` |  | [ ] |  |  |
| `commercial_partner_id_label` | `varchar2` |  | [ ] |  |  |
| `commitment_date` | `datetime` | Data di consegna | [ ] |  | 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` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `country_code` | `varchar2` | Country code | [ ] |  | The ISO country code in two chars.You can use this field for quick search. |
| `country_id` | `varchar2` |  | [ ] |  |  |
| `country_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Data di creazione | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `currency_rate` | `numeric` | Tasso di cambio della valuta | [ ] |  |  |
| `date_order` | `datetime` | Data dell'ordine | [x] |  | Creation date of draft/sent orders, Confirmation date of confirmed orders. |
| `delivery_count` | `int32` | Delivery Orders | [ ] |  |  |
| `delivery_message` | `varchar2` | Delivery Message | [ ] |  |  |
| `delivery_rating_success` | `boolean` | Delivery Rating Success | [ ] |  |  |
| `delivery_set` | `boolean` | Delivery Set | [ ] |  |  |
| `delivery_status` | `varchar2` | Stato della spedizione | [ ] |  |  |
| `display_name` | `varchar2` | Nome visualizzato | [ ] |  |  |
| `effective_date` | `datetime` | Data di validità | [ ] |  | Completion date of the first delivery order. |
| `end_date` | `datetime` | Data di fine | [ ] |  | 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` | `varchar2` |  | [ ] |  |  |
| `fedex_access_point_address` | `varchar2` | 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` | `varchar2` |  | [ ] |  | 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_label` | `varchar2` |  | [ ] |  | 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` | `varchar2` | Health | [ ] |  | Show the health status |
| `history_count` | `int32` | History Count | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `incoterm` | `varchar2` |  | [ ] |  | International Commercial Terms are a series of predefined commercial terms used in international transactions. |
| `incoterm_label` | `varchar2` |  | [ ] |  | International Commercial Terms are a series of predefined commercial terms used in international transactions. |
| `incoterm_location` | `varchar2` | Incoterm Location | [ ] |  |  |
| `industry_id` | `varchar2` |  | [ ] |  |  |
| `industry_id_label` | `varchar2` |  | [ ] |  |  |
| `internal_note` | `varchar2` | Nota interna | [ ] |  |  |
| `invoice_count` | `int32` | Invoice Count | [ ] |  |  |
| `invoice_ids` | `varchar2` |  | [ ] |  |  |
| `invoice_status` | `varchar2` | Stato della fattura | [ ] |  |  |
| `is_abandoned_cart` | `boolean` | Abandoned Cart | [ ] |  |  |
| `is_all_service` | `boolean` | Service Product | [ ] |  |  |
| `is_batch` | `boolean` | È un batch | [ ] |  |  |
| `is_expired` | `boolean` | È scaduto | [ ] |  |  |
| `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` | `varchar2` | JSON data for the popover widget | [ ] |  |  |
| `kpi_1month_mrr_delta` | `numeric` | KPI 1 Month MRR Delta | [ ] |  |  |
| `kpi_1month_mrr_percentage` | `numeric` | KPI 1 Month MRR Percentage | [ ] |  |  |
| `kpi_3months_mrr_delta` | `numeric` | KPI 3 months MRR Delta | [ ] |  |  |
| `kpi_3months_mrr_percentage` | `numeric` | KPI 3 Months MRR Percentage | [ ] |  |  |
| `last_invoice_date` | `datetime` | Last invoice date | [ ] |  |  |
| `medium_id` | `varchar2` |  | [ ] |  | This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
| `medium_id_label` | `varchar2` |  | [ ] |  | This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
| `message_attachment_count` | `int32` | Numero di allegati | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Numero di azioni | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `milestone_count` | `int32` | Milestone Count | [ ] |  |  |
| `mrp_production_count` | `int32` | Count of MO generated | [ ] |  |  |
| `mrp_production_ids` | `varchar2` |  | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Riferimento dell'ordine | [x] |  |  |
| `next_action_date` | `datetime` | Azione successiva | [ ] |  |  |
| `next_invoice_date` | `datetime` | Date of Next Invoice | [ ] |  | The next invoice will be created on this date then the period will be extended. |
| `note` | `varchar2` | Terms and conditions | [ ] |  |  |
| `only_services` | `boolean` | Only Services | [ ] |  |  |
| `opportunity_id` | `varchar2` |  | [ ] |  |  |
| `opportunity_id_label` | `varchar2` |  | [ ] |  |  |
| `order_line` | `varchar2` |  | [ ] |  |  |
| `order_log_ids` | `varchar2` |  | [ ] |  |  |
| `origin` | `varchar2` | Source Document | [ ] |  | Reference of the document that generated this sales order request |
| `origin_order_id` | `varchar2` |  | [ ] |  |  |
| `origin_order_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_credit_warning` | `varchar2` | Partner Credit Warning | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_invoice_id` | `varchar2` |  | [ ] |  |  |
| `partner_invoice_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_shipping_id` | `varchar2` |  | [ ] |  |  |
| `partner_shipping_id_label` | `varchar2` |  | [ ] |  |  |
| `partner_ups_carrier_account` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `payment_term_id_label` | `varchar2` |  | [ ] |  |  |
| `payment_token_id` | `varchar2` |  | [ ] |  | If not set, the automatic payment will fail. |
| `payment_token_id_label` | `varchar2` |  | [ ] |  | 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` | `varchar2` |  | [ ] |  |  |
| `picking_policy` | `varchar2` | Shipping Policy | [x] |  | 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` | `varchar2` |  | [ ] |  |  |
| `planning_first_sale_line_id_label` | `varchar2` |  | [ ] |  |  |
| `planning_hours_planned` | `numeric` | Planning Hours Planned | [ ] |  |  |
| `planning_hours_to_plan` | `numeric` | Planning Hours To Plan | [ ] |  |  |
| `planning_initial_date` | `datetime` | Planning Initial Date | [ ] |  |  |
| `pos_order_count` | `int32` | Pos Order Count | [ ] |  |  |
| `pos_order_line_ids` | `varchar2` |  | [ ] |  |  |
| `pricelist_id` | `varchar2` |  | [ ] |  | If you change the pricelist, only newly added lines will be affected. |
| `pricelist_id_label` | `varchar2` |  | [ ] |  | If you change the pricelist, only newly added lines will be affected. |
| `procurement_group_id` | `varchar2` |  | [ ] |  |  |
| `procurement_group_id_label` | `varchar2` |  | [ ] |  |  |
| `project_count` | `int32` | Number of Projects | [ ] |  |  |
| `project_id` | `varchar2` |  | [ ] |  | Select a non billable project on which tasks can be created. |
| `project_id_label` | `varchar2` |  | [ ] |  | Select a non billable project on which tasks can be created. |
| `project_ids` | `varchar2` |  | [ ] |  | Projects used in this sales order. |
| `purchase_order_count` | `int32` | Number of Purchase Order Generated | [ ] |  |  |
| `rating_avg` | `numeric` | Valutazione media | [ ] |  |  |
| `rating_avg_text` | `varchar2` | Rating Avg Text | [ ] |  |  |
| `rating_count` | `int32` | Rating count | [ ] |  |  |
| `rating_ids` | `varchar2` |  | [ ] |  |  |
| `rating_last_feedback` | `varchar2` | Rating Last Feedback | [ ] |  |  |
| `rating_last_image` | `varbinary` | Rating Last Image | [ ] |  |  |
| `rating_last_text` | `varchar2` | Rating Text | [ ] |  |  |
| `rating_last_value` | `numeric` | Rating Last Value | [ ] |  |  |
| `rating_percentage_satisfaction` | `numeric` | Rating Satisfaction | [ ] |  |  |
| `recompute_delivery_price` | `boolean` | Delivery cost should be recomputed | [ ] |  |  |
| `recurrence_id` | `varchar2` |  | [ ] |  |  |
| `recurrence_id_label` | `varchar2` |  | [ ] |  |  |
| `recurring_details` | `varchar2` | Recurring Details | [ ] |  |  |
| `recurring_live` | `boolean` | Alive | [ ] |  |  |
| `recurring_monthly` | `numeric` | Monthly Recurring Revenue | [ ] |  |  |
| `reference` | `varchar2` | Payment Ref. | [ ] |  | The payment communication of this sale order. |
| `renew_state` | `varchar2` | Renew State | [ ] |  |  |
| `rental_status` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `sale_order_template_id` | `varchar2` |  | [ ] |  |  |
| `sale_order_template_id_label` | `varchar2` |  | [ ] |  |  |
| `shipping_weight` | `numeric` | Shipping Weight | [ ] |  |  |
| `shop_warning` | `varchar2` | 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` | `varbinary` | Signature | [ ] |  |  |
| `signed_by` | `varchar2` | Signed By | [ ] |  |  |
| `signed_on` | `datetime` | Signed On | [ ] |  |  |
| `source_id` | `varchar2` |  | [ ] |  | This is the source of the link, e.g. Search Engine, another domain, or name of email list |
| `source_id_label` | `varchar2` |  | [ ] |  | This is the source of the link, e.g. Search Engine, another domain, or name of email list |
| `stage_category` | `varchar2` | Category | [ ] |  |  |
| `stage_id` | `varchar2` |  | [ ] |  |  |
| `stage_id_label` | `varchar2` |  | [ ] |  |  |
| `starred` | `boolean` | Show Subscription on dashboard | [ ] |  | Whether this subscription should be displayed on the dashboard or not |
| `starred_user_ids` | `varchar2` |  | [ ] |  |  |
| `start_date` | `datetime` | Data di inizio | [ ] |  | The start date indicate when the subscription periods begin. |
| `state` | `varchar2` | Status | [ ] |  |  |
| `subscription_child_ids` | `varchar2` |  | [ ] |  |  |
| `subscription_id` | `varchar2` |  | [ ] |  |  |
| `subscription_id_label` | `varchar2` |  | [ ] |  |  |
| `subscription_management` | `varchar2` | Subscription Management | [ ] |  | Creation: The Sales Order created the subscription Upsell: The Sales Order added lines to the subscription Renewal: The Sales Order replaced the subscription's content with its own |
| `tag_ids` | `varchar2` |  | [ ] |  |  |
| `task_id` | `varchar2` |  | [ ] |  | Task from which this quotation have been created |
| `task_id_label` | `varchar2` |  | [ ] |  | Task from which this quotation have been created |
| `tasks_count` | `int32` | Tasks | [ ] |  |  |
| `tasks_ids` | `varchar2` |  | [ ] |  |  |
| `tax_country_id` | `varchar2` |  | [ ] |  |  |
| `tax_country_id_label` | `varchar2` |  | [ ] |  |  |
| `tax_totals` | `varbinary` | Tax Totals | [ ] |  |  |
| `team_id` | `varchar2` |  | [ ] |  |  |
| `team_id_label` | `varchar2` |  | [ ] |  |  |
| `team_user_id` | `varchar2` |  | [ ] |  |  |
| `team_user_id_label` | `varchar2` |  | [ ] |  |  |
| `terms_type` | `varchar2` | Terms & Conditions format | [ ] |  |  |
| `timesheet_count` | `numeric` | Timesheet activities | [ ] |  |  |
| `timesheet_encode_uom_id` | `varchar2` |  | [ ] |  |  |
| `timesheet_encode_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `timesheet_ids` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` |  | [ ] |  |  |
| `type_name` | `varchar2` | Nome del tipo | [ ] |  |  |
| `ups_bill_my_account` | `boolean` | Bill My Account | [ ] |  | If checked, ecommerce users will be prompted their UPS account number and delivery fees will be charged on it. |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `validity_date` | `datetime` | Expiration | [ ] |  |  |
| `visible_project` | `boolean` | Display project | [ ] |  |  |
| `warehouse_id` | `varchar2` |  | [ ] |  |  |
| `warehouse_id_label` | `varchar2` |  | [ ] |  |  |
| `website_id` | `varchar2` |  | [ ] |  | Website through which this order was placed for eCommerce orders. |
| `website_id_label` | `varchar2` |  | [ ] |  | Website through which this order was placed for eCommerce orders. |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `website_order_line` | `varchar2` |  | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

- [Odoo](/it/release-notes/drivers?driver=odoo)
