invantive documentation
Invantive Support ForumsLog In / Sign Up

order_line: Odoo itgen_odoo_order_line

read only per partition

  • Catalog: Odoo
  • Schema: purchase
  • Label: itgen_odoo_order_line

Purchase Order Line

Can only retrieve data.

Table Columns

The columns of the table order_line are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
analytic_distribution varchar2 Analytic Distribution
analytic_precision int32 Analytic Precision
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_approve datetime Confirmation Date
date_order datetime Order Date 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 Display Name
display_type varchar2 Display Type 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 Unit Price
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 Product Type 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 Total Quantity
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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: