Table idempiere9.adempiere.ad_process
Process or 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
ad_process_id numeric 10
ad_process_para.ad_process_id adprocess_adprocesspara C
ad_tab.ad_process_id adprocess_adtab R
asp_clientexception.ad_process_id adprocess_aspclientexception R
asp_process.ad_process_id adprocess_aspprocess R
Process or Report
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 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
value varchar 40 Search key for the record in the format required - must be unique
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
help varchar 2000  √  null Comment or Hint
accesslevel bpchar 1 Access Level required
entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
procedurename varchar 60  √  null Name of the Database Procedure
isreport bpchar 1 'Y'::bpchar Indicates a Report record
isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_reportview_id numeric 10  √  null View used to generate this report
classname varchar 255  √  null Java Classname
statistic_count numeric 10  √  null Internal statistics how often the entity was used
statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
ad_printformat_id numeric 10  √  null Data Print Format
workflowvalue varchar 40  √  null Key of the Workflow to start
ad_workflow_id numeric 10  √  null
ad_workflow.ad_workflow_id adworkflow_adprocess R
Workflow or combination of tasks
isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
isserverprocess bpchar 1  √  null Run this Process on Server only
showhelp bpchar 1  √  'Y'::bpchar Show Help
jasperreport varchar 255  √  null Jasper Report
ad_form_id numeric 10  √  null
ad_form.ad_form_id adform_adprocess R
Special Form
copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
allowmultipleexecution bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.

Table contained 454 rows at 2021-12-25 14:57 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_process_id Primary key Asc ad_process_pkey
ad_process_uu Must be unique Asc ad_process_uu_idx

Close relationships  within of separation: