sale_order_template

-1 rows


Description

Quotation Template

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('sale_order_template_id_seq'::regclass)
res_company.sale_order_template_id res_company_sale_order_template_id_fkey N
sale_order.sale_order_template_id sale_order_sale_order_template_id_fkey N
sale_order_template_line.sale_order_template_id sale_order_template_line_sale_order_template_id_fkey C
sale_order_template_option.sale_order_template_id sale_order_template_option_sale_order_template_id_fkey C
company_id int4 10 √ null
res_company.id sale_order_template_company_id_fkey N

Company
mail_template_id int4 10 √ null
mail_template.id sale_order_template_mail_template_id_fkey N

Confirmation Mail
number_of_days int4 10 √ null

Quotation Duration
create_uid int4 10 √ null
res_users.id sale_order_template_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Quotation Template
note jsonb 2147483647 √ null

Terms and conditions
active bool 1 √ null

Active
require_signature bool 1 √ null

Online Signature
require_payment bool 1 √ null

Online Payment
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
prepayment_percent float8 17,17 √ null

Prepayment percentage
sale_header_name varchar 2147483647 √ null

Sale Header Name
sale_footer_name varchar 2147483647 √ null

Sale Footer Name

Indexes

Constraint Name Type Sort Column(s)
sale_order_template_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation