account_payment_term

-1 rows


Description

Payment Terms

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_payment_term_id_seq'::regclass)
account_move.invoice_payment_term_id account_move_invoice_payment_term_id_fkey N
account_payment_term_line.payment_id account_payment_term_line_payment_id_fkey C
purchase_order.payment_term_id purchase_order_payment_term_id_fkey N
sale_order.payment_term_id sale_order_payment_term_id_fkey N
company_id int4 10 √ null
res_company.id account_payment_term_company_id_fkey N

Company
sequence int4 10 null

Sequence
discount_days int4 10 √ null

Discount Days
create_uid int4 10 √ null
res_users.id account_payment_term_create_uid_fkey N

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

Last Updated by
early_pay_discount_computation varchar 2147483647 √ null

Cash Discount Tax Reduction
name jsonb 2147483647 null

Payment Terms
note jsonb 2147483647 √ null

Description on the Invoice
active bool 1 √ null

Active
display_on_invoice bool 1 √ null

Show installment dates
early_discount bool 1 √ null

Early Discount
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
discount_percentage float8 17,17 √ null

Discount %

Indexes

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

Relationships

Close relationships within degrees of separation