template_attribute_value: Odoo itgen_odoo_template_attribute_value
read only per partition
- Catalog:
Odoo - Schema:
product - Label: itgen_odoo_template_attribute_value
Product Template Attribute Value
Can only retrieve data.
Summary
Materialized relationship between attribute values and product template generated by the product.template.attribute.line
Table Columns
The columns of the table template_attribute_value 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 |
|---|---|---|---|---|---|
attribute_ |
varchar2 |
||||
attribute_ |
varchar2 |
||||
attribute_ |
varchar2 |
||||
attribute_ |
varchar2 |
||||
color |
int32 |
Color | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
display_ |
varchar2 |
Display Type | The display type used in the Product Configurator. | ||
exclude_ |
varchar2 |
Make this attribute value not compatible with other values of the product or some attribute values of optional and accessory products. | |||
html_ |
varchar2 |
HTML Color Index | Here you can set a specific HTML color index (e.g. #ff0000) to display the color if the attribute type is 'Color'. | ||
id |
int32 |
ID | |||
is_ |
boolean |
Is custom value | Allow users to input custom values for this attribute value | ||
name |
varchar2 |
Value | |||
price_ |
numeric |
Value Price Extra | Extra price for the variant with this attribute value on sale price. eg. 200 price extra, 1000 + 200 = 1200. | ||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
ptav_ |
boolean |
Active | |||
ptav_ |
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: