invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id varchar2
attribute_id_label varchar2
attribute_line_id varchar2
attribute_line_id_label varchar2
color int32 Color
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
display_name varchar2 Display Name
display_type varchar2 Display Type The display type used in the Product Configurator.
exclude_for varchar2 Make this attribute value not compatible with other values of the product or some attribute values of optional and accessory products.
html_color 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_custom boolean Is custom value Allow users to input custom values for this attribute value
name varchar2 Value
price_extra numeric Value Price Extra Extra price for the variant with this attribute value on sale price. eg. 200 price extra, 1000 + 200 = 1200.
product_attribute_value_id varchar2
product_attribute_value_id_label varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
ptav_active boolean Active
ptav_product_variant_ids varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: