invantive documentation
Forum di supporto InvantiveAccedi / Registrati

order_line: Odoo itgen_odoo_order_line

read only per partition

  • Catalogo: Odoo
  • Schema: purchase
  • Etichetta: itgen_odoo_order_line

Linea dell'ordine di acquisto

È 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
analytic_distribution varchar2 Analytic Distribution
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
date_approve datetime Confirmation Date
date_order datetime Data dell'ordine Depicts the date within which the Quotation should be confirmed and converted into a purchase order.
date_planned datetime Expected Arrival Delivery date expected from vendor.This date respectively defaults to vendor pricelist lead time then today's date.
display_name varchar2 Nome visualizzato
display_type varchar2 Tipo di display Technical field for UX purpose.
forecasted_issue boolean Forecasted Issue
id int32 ID
invoice_lines varchar2
move_dest_ids varchar2
move_ids varchar2
name varchar2 Description
order_id varchar2
order_id_label varchar2
orderpoint_id varchar2
orderpoint_id_label varchar2
partner_id varchar2 You can find a vendor by its Name, TIN, Email or Internal Reference.
partner_id_label varchar2 You can find a vendor by its Name, TIN, Email or Internal Reference.
price_subtotal numeric Subtotal
price_tax numeric Tax
price_total numeric Total
price_unit numeric Prezzo unitario
product_description_variants varchar2 Custom Description
product_id varchar2
product_id_label varchar2
product_packaging_id varchar2
product_packaging_id_label varchar2
product_packaging_qty numeric Packaging Quantity
product_qty numeric Quantity
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 Quantità totale
propagate_cancel boolean Propagate cancellation
qty_invoiced numeric Billed Qty
qty_received numeric Received Qty
qty_received_manual numeric Manual Received Qty
qty_received_method varchar2 Received Qty Method According to product configuration, the received quantity can be automatically computed by mechanism : - Manual: the quantity is set manually on the line - Stock Moves: the quantity comes from confirmed pickings
qty_to_invoice numeric To Invoice Quantity
sale_line_id varchar2
sale_line_id_label varchar2
sale_order_id varchar2
sale_order_id_label varchar2
sequence int32 Sequence
state varchar2 Status
taxes_id 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: