quant: Odoo itgen_odoo_quant
read only per partition
- Catalog:
Odoo - Schema:
stock - Label: itgen_odoo_quant
Quants
Can only retrieve data.
Table Columns
The columns of the table quant are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Available Quantity | 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 |
Created on | |||
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 |
Display Name | |||
dummy_ |
varchar2 |
Dummy | |||
id |
int32 |
ID | |||
in_ |
datetime |
Incoming Date | |||
inventory_ |
datetime |
Scheduled Date | 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 |
On Hand | |||
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 |
Reserved Quantity | 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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: