invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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 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
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 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: