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_ |
varchar2 |
Analytic Distribution | |||
analytic_ |
int32 |
Analytic Precision | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Confirmation Date | |||
date_ |
datetime |
Order Date | Depicts the date within which the Quotation should be confirmed and converted into a purchase order. | ||
date_ |
datetime |
Expected Arrival | Delivery date expected from vendor. This date respectively defaults to vendor pricelist lead time then today's date. | ||
display_ |
varchar2 |
Display Name | |||
display_ |
varchar2 |
Display Type | Technical field for UX purpose. | ||
forecasted_ |
boolean |
Forecasted Issue | |||
id |
int32 |
ID | |||
invoice_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
name |
varchar2 |
Description | |||
order_ |
varchar2 |
||||
order_ |
varchar2 |
||||
orderpoint_ |
varchar2 |
||||
orderpoint_ |
varchar2 |
||||
partner_ |
varchar2 |
You can find a vendor by its Name, TIN, Email or Internal Reference. | |||
partner_ |
varchar2 |
You can find a vendor by its Name, TIN, Email or Internal Reference. | |||
price_ |
numeric |
Subtotal | |||
price_ |
numeric |
Tax | |||
price_ |
numeric |
Total | |||
price_ |
numeric |
Unit Price | |||
product_ |
varchar2 |
Custom Description | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Packaging Quantity | |||
product_ |
numeric |
Quantity | |||
product_ |
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_ |
varchar2 |
||||
product_ |
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_ |
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_ |
varchar2 |
||||
product_ |
numeric |
Total Quantity | |||
propagate_ |
boolean |
Propagate cancellation | |||
qty_ |
numeric |
Billed Qty | |||
qty_ |
numeric |
Received Qty | |||
qty_ |
numeric |
Manual Received Qty | |||
qty_ |
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_ |
numeric |
To Invoice Quantity | |||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sequence |
int32 |
Sequence | |||
state |
varchar2 |
Status | |||
taxes_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: