pa_reportline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_reportline_id numeric 10 null
i_reportline.pa_reportline_id pareportline_ireportline N
pa_reportline.oper_1_id pareportline_oper1 N
pa_reportline.oper_2_id pareportline_oper2 N
pa_reportline.parent_id pareportline_parent N
pa_reportline_trl.pa_reportline_id pareportline_pareportlinetrl C
pa_reportsource.pa_reportline_id pareportline_pareportsource C
t_report.pa_reportline_id pareportline_treport C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
pa_reportlineset_id numeric 10 null
pa_reportlineset.pa_reportlineset_id pareportlineset_line C
name varchar 255 null
seqno numeric 10 null
description varchar 255 √ null
isprinted bpchar 1 'Y'::bpchar
parent_id numeric 10 √ null
pa_reportline.pa_reportline_id pareportline_parent N
issummary bpchar 1 'N'::bpchar
linetype bpchar 1 null
calculationtype bpchar 1 √ null
oper_1_id numeric 10 √ null
pa_reportline.pa_reportline_id pareportline_oper1 N
oper_2_id numeric 10 √ null
pa_reportline.pa_reportline_id pareportline_oper2 N
postingtype bpchar 1 √ null
gl_budget_id numeric 10 √ null
gl_budget.gl_budget_id glbudget_pareportline R
amounttype bpchar 2 √ null
paamounttype bpchar 1 √ NULL::bpchar
paperiodtype bpchar 1 √ NULL::bpchar
pa_reportline_uu varchar 36 √ NULL::character varying
isinversedebitcreditonly bpchar 1 'N'::bpchar
isshowoppositesign bpchar 1 √ 'N'::bpchar
overlinestroketype varchar 3 √ NULL::character varying
underlinestroketype varchar 3 √ NULL::character varying
roundfactor numeric 10 √ NULL::numeric
multiplier numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
pa_reportline_pkey Primary key Asc pa_reportline_id
pa_reportline_uu_idx Must be unique Asc pa_reportline_uu

Check Constraints

Constraint Name Constraint
pa_reportline_isinversedebitcreditonly_check ((isinversedebitcreditonly = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportline_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportline_isshowoppositesign_check ((isshowoppositesign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation