Table idempiere9.adempiere.pa_report
Financial Report

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_report_id numeric 10 Financial Report
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10  √  null
ad_org.ad_org_id adorg_pareport C
Organizational entity within client
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
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
pa_reportlineset_id numeric 10
pa_reportlineset.pa_reportlineset_id pareport_lineset R
Report Line Set
pa_reportcolumnset_id numeric 10
pa_reportcolumnset.pa_reportcolumnset_id pareport_columnset R
Collection of Columns for Report
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_pareport R
Rules for accounting
c_calendar_id numeric 10
c_calendar.c_calendar_id ccalendar_pareport R
Accounting Calendar Name
processing bpchar 1 Process Now
ad_printformat_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformat_pareport N
Data Print Format
listsources bpchar 1 'N'::bpchar List Report Line Sources
listtrx bpchar 1 'N'::bpchar List the report transactions
jasperprocess_id numeric 10  √  null
ad_process.ad_process_id jasperprocess_pareport R
The Jasper Process used by the printengine if any process defined
jasperprocessing bpchar 1  √  null Jasper Process Now
pa_reportcube_id numeric 10  √  NULL::numeric
pa_reportcube.pa_reportcube_id pareportcube_pareport R
Define reporting cube for pre-calculation of summary accounting data.
pa_report_uu varchar 36  √  NULL::character varying PA_Report_UU
listsourcesxtrx bpchar 1  √  'N'::bpchar Include source accounts with no transaction for list report line sources
excludeadjustmentperiods bpchar 1 '1'::bpchar Exclude Adjustment Periods

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

Indexes:
Column(s) Type Sort Constraint Name
pa_report_id Primary key Asc pa_report_pkey
pa_report_uu Must be unique Asc pa_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.