order_line: Odoo itgen_odoo_order_line
read only per partition
- Catalogo:
Odoo - Schema:
sale - Etichetta: itgen_odoo_order_line
Linea dell'ordine di vendita
È 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 |
|---|---|---|---|---|---|
amazon_ |
varchar2 |
Amazon Item Ref | The Amazon-defined item reference. | ||
amazon_ |
varchar2 |
||||
amazon_ |
varchar2 |
||||
analytic_ |
varchar2 |
Analytic Distribution | |||
analytic_ |
varchar2 |
||||
analytic_ |
int32 |
Analytic Precision | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
customer_ |
numeric |
Tempi di consegna | Number of days between the order confirmation and the shipping of the products to the customer | ||
delivered_ |
numeric |
Delivered Subtotal | |||
delivered_ |
numeric |
Delivered Total Tax | |||
delivered_ |
numeric |
Delivered Total | |||
discount |
numeric |
Sconto (%) | |||
display_ |
varchar2 |
Nome visualizzato | |||
display_ |
boolean |
Display Qty Widget | |||
display_ |
varchar2 |
Tipo di display | |||
event_ |
varchar2 |
Choose an event and it will automatically create a registration for this event. | |||
event_ |
varchar2 |
Choose an event and it will automatically create a registration for this event. | |||
event_ |
boolean |
Event Ok | |||
event_ |
varchar2 |
Choose an event ticket and it will automatically create a registration for this event ticket. | |||
event_ |
varchar2 |
Choose an event ticket and it will automatically create a registration for this event ticket. | |||
forecast_ |
datetime |
Forecast Expected Date | |||
free_ |
numeric |
Free Qty Today | |||
fsm_ |
varchar2 |
||||
fsm_ |
varchar2 |
||||
has_ |
boolean |
Has Displayed Warning Upsell | |||
id |
int32 |
ID | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
Stato della fattura | |||
is_ |
boolean |
Is the product configurable? | |||
is_ |
boolean |
Is a Delivery | |||
is_ |
boolean |
Is a down payment | Down payments are made when creating invoices from a sales order.They are not copied when duplicating a sales order. | ||
is_ |
boolean |
Is expense | Is true if the sales order line comes from an expense or a vendor bills | ||
is_ |
boolean |
Is overdue | The products haven't been returned in time | ||
is_mto |
boolean |
Is Mto | |||
is_ |
boolean |
Can be Rented | Allow renting of this product. | ||
is_ |
boolean |
Is Rental | |||
is_ |
boolean |
Is a Service | |||
linked_ |
varchar2 |
||||
linked_ |
varchar2 |
||||
move_ |
varchar2 |
||||
name |
varchar2 |
Description | |||
name_ |
varchar2 |
Name Short | |||
option_ |
varchar2 |
||||
order_ |
varchar2 |
||||
order_ |
varchar2 |
||||
order_ |
varchar2 |
||||
order_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
pickedup_ |
varchar2 |
||||
planning_ |
numeric |
Planning Hours Planned | |||
planning_ |
numeric |
Planning Hours To Plan | |||
planning_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
price_ |
numeric |
Price Reduce Tax excl | |||
price_ |
numeric |
Price Reduce Tax incl | |||
price_ |
numeric |
Subtotal | |||
price_ |
numeric |
Total Tax | |||
price_ |
numeric |
Total | |||
price_ |
numeric |
Prezzo unitario | |||
pricelist_ |
varchar2 |
||||
pricelist_ |
varchar2 |
||||
pricing_ |
varchar2 |
||||
pricing_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Packaging Quantity | |||
product_ |
numeric |
Product Qty | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
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 |
Quantity | |||
product_ |
boolean |
Product Uom Readonly | |||
product_ |
boolean |
Can Edit Product | |||
project_ |
varchar2 |
||||
project_ |
varchar2 |
||||
purchase_ |
int32 |
Number of generated purchase items | |||
purchase_ |
varchar2 |
Purchase line generated by this Sales item on order confirmation, or when the quantity was increased. | |||
qty_ |
numeric |
Qty Available Today | |||
qty_ |
numeric |
Quantità di consegna | |||
qty_ |
varchar2 |
Method to update delivered qty | According to product configuration, the delivered quantity can be automatically computed by mechanism : - Manual: the quantity is set manually on the line - Analytic From expenses: the quantity is the quantity sum from posted expenses - Timesheet: the quantity is the sum of hours recorded on tasks linked to this sale line - Stock Moves: the quantity comes from confirmed pickings | ||
qty_ |
numeric |
Quantità fatturata | |||
qty_ |
numeric |
Returned | |||
qty_ |
numeric |
Qty To Deliver | |||
qty_ |
numeric |
Quantity To Invoice | |||
reached_ |
varchar2 |
||||
recompute_ |
boolean |
Delivery cost should be recomputed | |||
recurring_ |
numeric |
Monthly Recurring Revenue | |||
remaining_ |
numeric |
Remaining Hours on SO | |||
remaining_ |
boolean |
Remaining Hours Available | |||
reservation_ |
datetime |
Pickup date - padding time | |||
reserved_ |
varchar2 |
||||
return_ |
datetime |
Return | |||
returned_ |
varchar2 |
||||
route_ |
varchar2 |
||||
route_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
salesman_ |
varchar2 |
||||
salesman_ |
varchar2 |
||||
scheduled_ |
datetime |
Data programmata | |||
sequence |
int32 |
Sequence | |||
shop_ |
varchar2 |
Warning | |||
start_ |
datetime |
Data di inizio | |||
state |
varchar2 |
Stato dell'ordine | |||
task_ |
varchar2 |
||||
task_ |
varchar2 |
||||
tax_id |
varchar2 |
||||
temporal_ |
varchar2 |
Temporal Type | |||
timesheet_ |
varchar2 |
||||
tracking |
varchar2 |
Tracking | Ensure the traceability of a storable product in your warehouse. | ||
unavailable_ |
varchar2 |
||||
untaxed_ |
numeric |
Untaxed Invoiced Amount | |||
untaxed_ |
numeric |
Untaxed Amount To Invoice | |||
virtual_ |
numeric |
Virtual Available At Date | |||
warehouse_ |
varchar2 |
||||
warehouse_ |
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: