account_report

-1 rows


Description

Accounting Report

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_report_id_seq'::regclass)
account_report.root_report_id account_report_root_report_id_fkey N
account_report_column.report_id account_report_column_report_id_fkey N
account_report_line.report_id account_report_line_report_id_fkey C
account_report_section_rel.main_report_id account_report_section_rel_main_report_id_fkey C
account_report_section_rel.sub_report_id account_report_section_rel_sub_report_id_fkey C
sequence int4 10 √ null

Sequence
root_report_id int4 10 √ null
account_report.id account_report_root_report_id_fkey N

Root Report
country_id int4 10 √ null
res_country.id account_report_country_id_fkey N

Country
load_more_limit int4 10 √ null

Load More Limit
prefix_groups_threshold int4 10 √ null

Prefix Groups Threshold
create_uid int4 10 √ null
res_users.id account_report_create_uid_fkey N

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

Last Updated by
chart_template varchar 2147483647 √ null

Chart of Accounts
availability_condition varchar 2147483647 √ null

Availability
default_opening_date_filter varchar 2147483647 √ null

Default Opening
filter_multi_company varchar 2147483647 √ null

Multi-Company
filter_hide_0_lines varchar 2147483647 √ null

Hide lines at 0
filter_hierarchy varchar 2147483647 √ null

Account Groups
filter_account_type varchar 2147483647 √ null

Account Types
name jsonb 2147483647 null

Name
active bool 1 √ null

Active
use_sections bool 1 √ null

Composite Report
only_tax_exigible bool 1 √ null

Only Tax Exigible Lines
search_bar bool 1 √ null

Search Bar
filter_date_range bool 1 √ null

Date Range
filter_show_draft bool 1 √ null

Draft Entries
filter_unreconciled bool 1 √ null

Unreconciled Entries
filter_unfold_all bool 1 √ null

Unfold All
filter_period_comparison bool 1 √ null

Period Comparison
filter_growth_comparison bool 1 √ null

Growth Comparison
filter_journals bool 1 √ null

Journals
filter_analytic bool 1 √ null

Analytic Filter
filter_partner bool 1 √ null

Partners
filter_fiscal_position bool 1 √ null

Filter Multivat
filter_aml_ir_filters bool 1 √ null

Favorite Filters
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

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

Relationships

Close relationships within degrees of separation