account_report_expression

-1 rows


Description

Accounting Report Expression

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_report_expression_id_seq'::regclass)
account_report_external_value.target_report_expression_id account_report_external_value_target_report_expression_id_fkey C
report_line_id int4 10 null
account_report_line.id account_report_expression_report_line_id_fkey C

Report Line
create_uid int4 10 √ null
res_users.id account_report_expression_create_uid_fkey N

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

Last Updated by
label varchar 2147483647 null

Label
engine varchar 2147483647 null

Computation Engine
formula varchar 2147483647 null

Formula
subformula varchar 2147483647 √ null

Subformula
date_scope varchar 2147483647 null

Date Scope
figure_type varchar 2147483647 √ null

Figure Type
carryover_target varchar 2147483647 √ null

Carry Over To
green_on_positive bool 1 √ null

Is Growth Good when Positive
blank_if_zero bool 1 √ null

Blank if Zero
auditable bool 1 √ null

Auditable
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_expression_pkey Primary key Asc id
account_report_expression_line_label_uniq Must be unique Asc/Asc report_line_id + label

Check Constraints

Constraint Name Constraint
account_report_expression_domain_engine_subformula_required ((((engine)::text <> 'domain'::text) OR (subformula IS NOT NULL)))

Relationships

Close relationships within degrees of separation