---
title: "order_line (Odoo)"
description: "itgen_odoo_order_line"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.purchase.order_line
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.purchase.order_line
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  |  |
| `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 | [x] |  |  |
| `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 | [x] |  |  |
| `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:

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

