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_ |
varchar2 |
Analytic Distribution | |||
analytic_ |
int32 |
Analytic Precision | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Confirmation Date | |||
date_ |
datetime |
Data dell'ordine | 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 |
Nome visualizzato | |||
display_ |
varchar2 |
Tipo di display | 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 |
Prezzo unitario | |||
product_ |
varchar2 |
Custom Description | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Packaging Quantity | |||
product_ |
numeric |
Quantity | |||
product_ |
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_ |
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 |
Quantità totale | |||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: