lot: Odoo itgen_odoo_lot
read only per partition
- Catalogo:
Odoo - Schema:
stock - Etichetta: itgen_odoo_lot
Lot/Serial
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella lot. 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 |
|---|---|---|---|---|---|
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
delivery_ |
int32 |
Delivery order count | |||
delivery_ |
varchar2 |
||||
display_ |
boolean |
Display Complete | |||
display_ |
varchar2 |
Nome visualizzato | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
message_ |
int32 |
Numero di allegati | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Lot/Serial Number | Unique Lot/Serial Number | ||
note |
varchar2 |
Description | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Quantity | |||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
purchase_ |
int32 |
Purchase order count | |||
purchase_ |
varchar2 |
||||
quality_ |
int32 |
Quality Check Qty | |||
quant_ |
varchar2 |
||||
ref |
varchar2 |
Riferimento interno | Internal reference number in case it differs from the manufacturer's lot/serial number | ||
repair_ |
int32 |
Repair order count | |||
repair_ |
varchar2 |
||||
sale_ |
int32 |
Sale order count | |||
sale_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
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: