product_template

43 rows


Description

Product

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_template_id_seq'::regclass)
account_account_tag_product_template_rel.product_template_id account_account_tag_product_template_r_product_template_id_fkey C
mrp_bom.product_tmpl_id mrp_bom_product_tmpl_id_fkey R
mrp_bom_line.product_tmpl_id mrp_bom_line_product_tmpl_id_fkey N
product_attribute_product_template_rel.product_template_id product_attribute_product_template_rel_product_template_id_fkey C
product_label_layout_product_template_rel.product_template_id product_label_layout_product_template__product_template_id_fkey C
product_optional_rel.dest_id product_optional_rel_dest_id_fkey C
product_optional_rel.src_id product_optional_rel_src_id_fkey C
product_pricelist_item.product_tmpl_id product_pricelist_item_product_tmpl_id_fkey C
product_product.product_tmpl_id product_product_product_tmpl_id_fkey C
product_replenish.product_tmpl_id product_replenish_product_tmpl_id_fkey C
product_supplier_taxes_rel.prod_id product_supplier_taxes_rel_prod_id_fkey C
product_supplierinfo.product_tmpl_id product_supplierinfo_product_tmpl_id_fkey C
product_tag_product_template_rel.product_template_id product_tag_product_template_rel_product_template_id_fkey C
product_taxes_rel.prod_id product_taxes_rel_prod_id_fkey C
product_template_attribute_exclusion.product_tmpl_id product_template_attribute_exclusion_product_tmpl_id_fkey C
product_template_attribute_line.product_tmpl_id product_template_attribute_line_product_tmpl_id_fkey C
product_template_attribute_value.product_tmpl_id product_template_attribute_value_product_tmpl_id_fkey N
stock_change_product_qty.product_tmpl_id stock_change_product_qty_product_tmpl_id_fkey C
stock_route_product.product_id stock_route_product_product_id_fkey C
stock_rules_report.product_tmpl_id stock_rules_report_product_tmpl_id_fkey C
sequence int4 10 √ null

Sequence
categ_id int4 10 null
product_category.id product_template_categ_id_fkey R

Product Category
uom_id int4 10 null
uom_uom.id product_template_uom_id_fkey R

Unit of Measure
uom_po_id int4 10 null
uom_uom.id product_template_uom_po_id_fkey R

Purchase UoM
company_id int4 10 √ null
res_company.id product_template_company_id_fkey N

Company
color int4 10 √ null

Color Index
create_uid int4 10 √ null
res_users.id product_template_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id product_template_write_uid_fkey N

Last Updated by
detailed_type varchar 2147483647 null

Product Type
type varchar 2147483647 √ null

Type
default_code varchar 2147483647 √ null

Internal Reference
priority varchar 2147483647 √ null

Favorite
name jsonb 2147483647 null

Name
description jsonb 2147483647 √ null

Description
description_purchase jsonb 2147483647 √ null

Purchase Description
description_sale jsonb 2147483647 √ null

Sales Description
product_properties jsonb 2147483647 √ null

Properties
list_price numeric 0 √ null

Sales Price
volume numeric 0 √ null

Volume
weight numeric 0 √ null

Weight
sale_ok bool 1 √ null

Can be Sold
purchase_ok bool 1 √ null

Can be Purchased
active bool 1 √ null

Active
can_image_1024_be_zoomed bool 1 √ null

Can Image 1024 be zoomed
has_configurable_attributes bool 1 √ null

Is a configurable product
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
sale_delay int4 10 √ null

Customer Lead Time
tracking varchar 2147483647 null

Tracking
description_picking jsonb 2147483647 √ null

Description on Picking
description_pickingout jsonb 2147483647 √ null

Description on Delivery Orders
description_pickingin jsonb 2147483647 √ null

Description on Receptions
purchase_method varchar 2147483647 √ null

Control Policy
purchase_line_warn varchar 2147483647 null

Purchase Order Line Warning
purchase_line_warn_msg text 2147483647 √ null

Message for Purchase Order Line
service_type varchar 2147483647 √ null

Track Service
sale_line_warn varchar 2147483647 null

Sales Order Line
expense_policy varchar 2147483647 √ null

Re-Invoice Expenses
invoice_policy varchar 2147483647 √ null

Invoicing Policy
sale_line_warn_msg text 2147483647 √ null

Message for Sales Order Line

Indexes

Constraint Name Type Sort Column(s)
product_template_pkey Primary key Asc id
product_template__company_id_index Performance Asc company_id

Relationships

Close relationships within degrees of separation