Table idempiere9.adempiere.t_report
Temporary Reporting Table

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
ad_pinstance_id numeric 10
ad_pinstance.ad_pinstance_id adpinstance_treport C
Instance of the process
pa_reportline_id numeric 10
pa_reportline.pa_reportline_id pareportline_treport C
Report Line
record_id numeric 10 Direct internal record ID
fact_acct_id numeric 10 Accounting Fact
seqno numeric 0  √  null Method of ordering records; lowest number comes first
levelno numeric 10  √  0 Level no
name varchar 60  √  null Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
col_0 numeric 0  √  null Col_0
col_2 numeric 0  √  null Col_2
col_1 numeric 0  √  null Col_1
col_3 numeric 0  √  null Col_3
col_4 numeric 0  √  null Col_4
col_5 numeric 0  √  null Col_5
col_6 numeric 0  √  null Col_6
col_7 numeric 0  √  null Col_7
col_8 numeric 0  √  null Col_8
col_9 numeric 0  √  null Col_9
col_10 numeric 0  √  null Col_10
col_11 numeric 0  √  null Col_11
col_12 numeric 0  √  null Col_12
col_13 numeric 0  √  null Col_13
col_14 numeric 0  √  null Col_14
col_15 numeric 0  √  null Col_15
col_16 numeric 0  √  null Col_16
col_17 numeric 0  √  null Col_17
col_18 numeric 0  √  null Col_18
col_19 numeric 0  √  null Col_19
col_20 numeric 0  √  null Col_20
t_report_uu varchar 36  √  NULL::character varying T_Report_UU
col_21 numeric 0  √  null Col_21
col_22 numeric 0  √  null Col_22
col_23 numeric 0  √  null Col_23
col_24 numeric 0  √  null Col_24
col_25 numeric 0  √  null Col_25
col_26 numeric 0  √  null Col_26
col_27 numeric 0  √  null Col_27
col_28 numeric 0  √  null Col_28
col_29 numeric 0  √  null Col_29
col_30 numeric 0  √  null Col_30

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_pinstance_id + pa_reportline_id + record_id + fact_acct_id Primary key Asc/Asc/Asc/Asc t_report_pkey
t_report_uu Must be unique Asc t_report_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.