account_reconcile_model_line

-1 rows


Description

Rules for the reconciliation model

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_reconcile_model_line_id_seq'::regclass)
account_reconcile_model_line_account_tax_rel.account_reconcile_model_line_id account_reconcile_model_line__account_reconcile_model_line_fkey C
model_id int4 10 √ null
account_reconcile_model.id account_reconcile_model_line_model_id_fkey C

Model
company_id int4 10 √ null
res_company.id account_reconcile_model_line_company_id_fkey N

Company
sequence int4 10 null

Sequence
account_id int4 10 null
account_account.id account_reconcile_model_line_account_id_fkey C

Account
journal_id int4 10 √ null
account_journal.id account_reconcile_model_line_journal_id_fkey C

Journal
create_uid int4 10 √ null
res_users.id account_reconcile_model_line_create_uid_fkey N

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

Last Updated by
amount_type varchar 2147483647 null

Amount Type
amount_string varchar 2147483647 null

Amount
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution
label jsonb 2147483647 √ null

Journal Item Label
force_tax_included bool 1 √ null

Tax Included in Price
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
amount float8 17,17 √ null

Float Amount

Indexes

Constraint Name Type Sort Column(s)
account_reconcile_model_line_pkey Primary key Asc id
account_reconcile_model_line_analytic_distribution_accounts_gin Performance

Relationships

Close relationships within degrees of separation