category: Odoo itgen_odoo_category
read only per partition
- Catalog:
Odoo - Schema:
product - Label: itgen_odoo_category
Product Category
Can only retrieve data.
Table Columns
The columns of the table category 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 |
|---|---|---|---|---|---|
child_ |
varchar2 |
||||
complete_ |
varchar2 |
Complete Name | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
id |
int32 |
ID | |||
name |
varchar2 |
Name | |||
packaging_ |
varchar2 |
Reserve Packagings | Reserve Only Full Packagings: will not reserve partial packagings. If customer orders 2 pallets of 1000 units each and you only have 1600 in stock, then only 1000 will be reserved Reserve Partial Packagings: allow reserving partial packagings. If customer orders 2 pallets of 1000 units each and you only have 1600 in stock, then 1600 will be reserved | ||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
||||
parent_ |
varchar2 |
Parent Path | |||
product_ |
int32 |
# Products | The number of products under this category (Does not consider the children categories) | ||
property_ |
varchar2 |
This account will be used to value price difference between purchase price and accounting cost. | |||
property_ |
varchar2 |
This account will be used to value price difference between purchase price and accounting cost. | |||
property_ |
varchar2 |
The expense is accounted for when a vendor bill is validated, except in anglo-saxon accounting with perpetual inventory valuation in which case the expense (Cost of Goods Sold account) is recognized at the customer invoice validation. | |||
property_ |
varchar2 |
The expense is accounted for when a vendor bill is validated, except in anglo-saxon accounting with perpetual inventory valuation in which case the expense (Cost of Goods Sold account) is recognized at the customer invoice validation. | |||
property_ |
varchar2 |
This account will be used when validating a customer invoice. | |||
property_ |
varchar2 |
This account will be used when validating a customer invoice. | |||
property_ |
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. | ||
property_ |
varchar2 |
Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation account set on the source location. This is the default value for all products in this category. It can also directly be set on each product. | |||
property_ |
varchar2 |
Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation account set on the source location. This is the default value for all products in this category. It can also directly be set on each product. | |||
property_ |
varchar2 |
When doing automated inventory valuation, counterpart journal items for all outgoing stock moves will be posted in this account, unless there is a specific valuation account set on the destination location. This is the default value for all products in this category. It can also directly be set on each product. | |||
property_ |
varchar2 |
When doing automated inventory valuation, counterpart journal items for all outgoing stock moves will be posted in this account, unless there is a specific valuation account set on the destination location. This is the default value for all products in this category. It can also directly be set on each product. | |||
property_ |
varchar2 |
When doing automated inventory valuation, this is the Accounting Journal in which entries will be automatically posted when stock moves are processed. | |||
property_ |
varchar2 |
When doing automated inventory valuation, this is the Accounting Journal in which entries will be automatically posted when stock moves are processed. | |||
property_ |
varchar2 |
When automated inventory valuation is enabled on a product, this account will hold the current value of the products. | |||
property_ |
varchar2 |
When automated inventory valuation is enabled on a product, this account will hold the current value of the products. | |||
property_ |
varchar2 |
Inventory Valuation | Manual: The accounting entries to value the inventory are not posted automatically. Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company. | ||
putaway_ |
varchar2 |
||||
removal_ |
varchar2 |
Set a specific removal strategy that will be used regardless of the source location for this product category. FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting). | |||
removal_ |
varchar2 |
Set a specific removal strategy that will be used regardless of the source location for this product category. FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting). | |||
route_ |
varchar2 |
||||
total_ |
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: