quant: Odoo itgen_odoo_quant
read only per partition
- Catalogo:
Odoo - Schema:
stock - Etichetta: itgen_odoo_quant
Quants
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella quant. 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 |
|---|---|---|---|---|---|
accounting_ |
datetime |
Accounting Date | Date at which the accounting entries will be created in case of automated inventory valuation.If empty, the inventory date will be used. | ||
available_ |
numeric |
Quantità disponibile | On hand quantity which hasn't been reserved on a transfer, in the default unit of measure of the product | ||
company_ |
varchar2 |
Let this field empty if this location is shared between companies | |||
company_ |
varchar2 |
Let this field empty if this location is shared between companies | |||
cost_ |
varchar2 |
Costing Method | Standard Price: The products are valued at their standard cost defined on the product.Average Cost (AVCO): The products are valued at weighted average cost.First In First Out (FIFO): The products are valued supposing those that enter the company first will also leave it first. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
cyclic_ |
int32 |
Inventory Frequency (Days) | When different than 0, inventory count date for products stored at this location will be automatically set at the defined frequency. | ||
display_ |
varchar2 |
Nome visualizzato | |||
dummy_ |
varchar2 |
Dummy | |||
id |
int32 |
ID | |||
in_ |
datetime |
Incoming Date | |||
inventory_ |
datetime |
Data programmata | Next date the On Hand Quantity should be counted. | ||
inventory_ |
numeric |
Difference | Indicates the gap between the product's theoretical quantity and its counted quantity. | ||
inventory_ |
numeric |
Counted Quantity | The product's counted quantity. | ||
inventory_ |
numeric |
Inventoried Quantity | |||
inventory_ |
boolean |
Inventory Quantity Set | |||
is_ |
boolean |
Quantity has been moved since last count | |||
last_ |
datetime |
Last Count Date | Last time the Quantity was Updated | ||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
lot_id |
varchar2 |
||||
lot_ |
varchar2 |
||||
on_ |
boolean |
Disponibile | |||
owner_ |
varchar2 |
This is the owner of the quant | |||
owner_ |
varchar2 |
This is the owner of the quant | |||
package_ |
varchar2 |
The package containing this quant | |||
package_ |
varchar2 |
The package containing this quant | |||
priority |
varchar2 |
Favorite | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
product_ |
varchar2 |
Default unit of measure used for all stock operations. | |||
quantity |
numeric |
Quantity | Quantity of products in this quant, in the default unit of measure of the product | ||
reserved_ |
numeric |
Quantità riservata | Quantity of reserved products in this quant, in the default unit of measure of the product | ||
sn_ |
boolean |
Duplicated Serial Number | If the same SN is in another Quant | ||
storage_ |
varchar2 |
||||
storage_ |
varchar2 |
||||
tracking |
varchar2 |
Tracking | Ensure the traceability of a storable product in your warehouse. | ||
user_ |
varchar2 |
User assigned to do product count. | |||
user_ |
varchar2 |
User assigned to do product count. | |||
value |
numeric |
Value | |||
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: