sale_order_template_line

-1 rows


Description

Quotation Template Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_template_line_id_seq'::regclass)
sale_order_template_id int4 10 null
sale_order_template.id sale_order_template_line_sale_order_template_id_fkey C

Quotation Template Reference
sequence int4 10 √ null

Sequence
company_id int4 10 √ null
res_company.id sale_order_template_line_company_id_fkey N

Company
product_id int4 10 √ null
product_product.id sale_order_template_line_product_id_fkey N

Product
product_uom_id int4 10 √ null
uom_uom.id sale_order_template_line_product_uom_id_fkey N

Unit of Measure
create_uid int4 10 √ null
res_users.id sale_order_template_line_create_uid_fkey N

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

Last Updated by
display_type varchar 2147483647 √ null

Display Type
name jsonb 2147483647 null

Description
product_uom_qty numeric 0 null

Quantity
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
sale_order_template_line_pkey Primary key Asc id
sale_order_template_line__company_id_index Performance Asc company_id
sale_order_template_line__sale_order_template_id_index Performance Asc sale_order_template_id

Check Constraints

Constraint Name Constraint
sale_order_template_line_non_accountable_fields_null (((display_type IS NULL) OR ((product_id IS NULL) AND (product_uom_qty = (0)::numeric) AND (product_uom_id IS NULL))))
sale_order_template_line_accountable_product_id_required (((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom_id IS NOT NULL))))

Relationships

Close relationships within degrees of separation