account_report_line

-1 rows


Description

Accounting Report Line

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_report_line_id_seq'::regclass)
account_report_expression.report_line_id account_report_expression_report_line_id_fkey C
account_report_external_value.carryover_origin_report_line_id account_report_external_value_carryover_origin_report_line_fkey N
account_report_line.parent_id account_report_line_parent_id_fkey N
report_id int4 10 null
account_report.id account_report_line_report_id_fkey C

Parent Report
hierarchy_level int4 10 null

Level
parent_id int4 10 √ null
account_report_line.id account_report_line_parent_id_fkey N

Parent Line
sequence int4 10 √ null

Sequence
action_id int4 10 √ null

Action
create_uid int4 10 √ null
res_users.id account_report_line_create_uid_fkey N

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

Last Updated by
groupby varchar 2147483647 √ null

Group By
user_groupby varchar 2147483647 √ null

User Group By
code varchar 2147483647 √ null

Code
name jsonb 2147483647 null

Name
foldable bool 1 √ null

Foldable
print_on_new_page bool 1 √ null

Print On New Page
hide_if_zero bool 1 √ null

Hide if Zero
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_line_pkey Primary key Asc id
account_report_line_code_uniq Must be unique Asc/Asc report_id + code

Relationships

Close relationships within degrees of separation