invantive documentation
Forum di supporto InvantiveAccedi / Registrati

order_line: Odoo itgen_odoo_order_line

read only per partition

  • Catalogo: Odoo
  • Schema: sale
  • Etichetta: itgen_odoo_order_line

Linea dell'ordine di vendita

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella order_line. 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
amazon_item_ref varchar2 Amazon Item Ref The Amazon-defined item reference.
amazon_offer_id varchar2
amazon_offer_id_label varchar2
analytic_distribution varchar2 Analytic Distribution
analytic_line_ids varchar2
analytic_precision int32 Analytic Precision
company_id varchar2
company_id_label varchar2
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
customer_lead numeric Tempi di consegna Number of days between the order confirmation and the shipping of the products to the customer
delivered_price_subtotal numeric Delivered Subtotal
delivered_price_tax numeric Delivered Total Tax
delivered_price_total numeric Delivered Total
discount numeric Sconto (%)
display_name varchar2 Nome visualizzato
display_qty_widget boolean Display Qty Widget
display_type varchar2 Tipo di display
event_id varchar2 Choose an event and it will automatically create a registration for this event.
event_id_label varchar2 Choose an event and it will automatically create a registration for this event.
event_ok boolean Event Ok
event_ticket_id varchar2 Choose an event ticket and it will automatically create a registration for this event ticket.
event_ticket_id_label varchar2 Choose an event ticket and it will automatically create a registration for this event ticket.
forecast_expected_date datetime Forecast Expected Date
free_qty_today numeric Free Qty Today
fsm_lot_id varchar2
fsm_lot_id_label varchar2
has_displayed_warning_upsell boolean Has Displayed Warning Upsell
id int32 ID
invoice_lines varchar2
invoice_status varchar2 Stato della fattura
is_configurable_product boolean Is the product configurable?
is_delivery boolean Is a Delivery
is_downpayment boolean Is a down payment Down payments are made when creating invoices from a sales order.They are not copied when duplicating a sales order.
is_expense boolean Is expense Is true if the sales order line comes from an expense or a vendor bills
is_late boolean Is overdue The products haven't been returned in time
is_mto boolean Is Mto
is_product_rentable boolean Can be Rented Allow renting of this product.
is_rental boolean Is Rental
is_service boolean Is a Service
linked_line_id varchar2
linked_line_id_label varchar2
move_ids varchar2
name varchar2 Description
name_short varchar2 Name Short
option_line_ids varchar2
order_id varchar2
order_id_label varchar2
order_partner_id varchar2
order_partner_id_label varchar2
parent_line_id varchar2
parent_line_id_label varchar2
pickedup_lot_ids varchar2
planning_hours_planned numeric Planning Hours Planned
planning_hours_to_plan numeric Planning Hours To Plan
planning_slot_ids varchar2
pos_order_line_ids varchar2
price_reduce_taxexcl numeric Price Reduce Tax excl
price_reduce_taxinc numeric Price Reduce Tax incl
price_subtotal numeric Subtotal
price_tax numeric Total Tax
price_total numeric Total
price_unit numeric Prezzo unitario
pricelist_item_id varchar2
pricelist_item_id_label varchar2
pricing_id varchar2
pricing_id_label varchar2
product_custom_attribute_value_ids varchar2
product_id varchar2
product_id_label varchar2
product_no_variant_attribute_value_ids varchar2
product_packaging_id varchar2
product_packaging_id_label varchar2
product_packaging_qty numeric Packaging Quantity
product_qty numeric Product Qty
product_template_attribute_value_ids varchar2
product_template_id varchar2
product_template_id_label varchar2
product_type varchar2 Tipo di prodotto 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.
product_uom varchar2
product_uom_category_id varchar2 Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios.
product_uom_category_id_label varchar2 Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios.
product_uom_label varchar2
product_uom_qty numeric Quantity
product_uom_readonly boolean Product Uom Readonly
product_updatable boolean Can Edit Product
project_id varchar2
project_id_label varchar2
purchase_line_count int32 Number of generated purchase items
purchase_line_ids varchar2 Purchase line generated by this Sales item on order confirmation, or when the quantity was increased.
qty_available_today numeric Qty Available Today
qty_delivered numeric Quantità di consegna
qty_delivered_method varchar2 Method to update delivered qty According to product configuration, the delivered quantity can be automatically computed by mechanism : - Manual: the quantity is set manually on the line - Analytic From expenses: the quantity is the quantity sum from posted expenses - Timesheet: the quantity is the sum of hours recorded on tasks linked to this sale line - Stock Moves: the quantity comes from confirmed pickings
qty_invoiced numeric Quantità fatturata
qty_returned numeric Returned
qty_to_deliver numeric Qty To Deliver
qty_to_invoice numeric Quantity To Invoice
reached_milestones_ids varchar2
recompute_delivery_price boolean Delivery cost should be recomputed
recurring_monthly numeric Monthly Recurring Revenue
remaining_hours numeric Remaining Hours on SO
remaining_hours_available boolean Remaining Hours Available
reservation_begin datetime Pickup date - padding time
reserved_lot_ids varchar2
return_date datetime Return
returned_lot_ids varchar2
route_id varchar2
route_id_label varchar2
sale_order_option_ids varchar2
salesman_id varchar2
salesman_id_label varchar2
scheduled_date datetime Data programmata
sequence int32 Sequence
shop_warning varchar2 Warning
start_date datetime Data di inizio
state varchar2 Stato dell'ordine
task_id varchar2
task_id_label varchar2
tax_id varchar2
temporal_type varchar2 Temporal Type
timesheet_ids varchar2
tracking varchar2 Tracking Ensure the traceability of a storable product in your warehouse.
unavailable_lot_ids varchar2
untaxed_amount_invoiced numeric Untaxed Invoiced Amount
untaxed_amount_to_invoice numeric Untaxed Amount To Invoice
virtual_available_at_date numeric Virtual Available At Date
warehouse_id varchar2
warehouse_id_label 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: