Table idempiere11.adempiere.pa_reportline
Report Line

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
pa_reportline_id numeric 10
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
Report Line
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
pa_reportlineset_id numeric 10
pa_reportlineset.pa_reportlineset_id pareportlineset_line C
Report Line Set
name varchar 255 Alphanumeric identifier of the entity
seqno numeric 10 Method of ordering records; lowest number comes first
description varchar 255  √  null Optional short description of the record
isprinted bpchar 1 'Y'::bpchar Indicates if this document / line is printed
parent_id numeric 10  √  null
pa_reportline.pa_reportline_id pareportline_parent N
Parent of Entity
issummary bpchar 1 'N'::bpchar This is a summary entity
linetype bpchar 1 Line Type
calculationtype bpchar 1  √  null Calculation
oper_1_id numeric 10  √  null
pa_reportline.pa_reportline_id pareportline_oper1 N
First operand for calculation
oper_2_id numeric 10  √  null
pa_reportline.pa_reportline_id pareportline_oper2 N
Second operand for calculation
postingtype bpchar 1  √  null The type of posted amount for the transaction
gl_budget_id numeric 10  √  null
gl_budget.gl_budget_id glbudget_pareportline R
General Ledger Budget
amounttype bpchar 2  √  null Type of amount to report
paamounttype bpchar 1  √  NULL::bpchar PA Amount Type for reporting
paperiodtype bpchar 1  √  NULL::bpchar PA Period Type
pa_reportline_uu varchar 36  √  NULL::character varying PA_ReportLine_UU
isinversedebitcreditonly bpchar 1 'N'::bpchar Apply inverse operation to debit or credit only column
isshowoppositesign bpchar 1  √  'N'::bpchar Display values with the opposite sign
overlinestroketype varchar 3  √  NULL::character varying Overline Stroke Type
underlinestroketype varchar 3  √  NULL::character varying Underline Stroke Type
roundfactor numeric 10  √  NULL::numeric Round Factor
multiplier numeric 0  √  null Type Multiplier (Credit = -1)

Table contained 113 rows at 2024-01-03 13:44 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.