quant: Odoo itgen_odoo_quant
read only per partition
- Catálogo:
Odoo - Esquema:
stock - Etiqueta: itgen_odoo_quant
Quants
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla quant. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |
Cantidad disponible | 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 |
Creado en | |||
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 |
Nombre para mostrar | |||
dummy_ |
varchar2 |
Dummy | |||
id |
int32 |
ID | |||
in_ |
datetime |
Incoming Date | |||
inventory_ |
datetime |
Fecha Programada | 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 |
En stock | |||
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 |
Cantidad reservada | 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 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: