SchemaSpy Analysis of idempiere9.adempiere - ColumnsReport Views Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:55 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 235 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_process accesslevel bpchar 1 Access Level required
ad_table accesslevel bpchar 1 Access Level required
ad_process allowmultipleexecution bpchar 1  √  'P'::bpchar Allow or disallow executing a process/report multiple times.
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
ad_process copyfromprocess bpchar 1  √  NULL::bpchar Copy settings from one report and process to another.
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_viewcolumn dbdatatype bpchar 1  √  NULL::bpchar Database Data Type
ad_process executiontype bpchar 1  √  NULL::bpchar Execution Type defines whether the report/process will always run in background or foreground.
ad_column fkconstrainttype bpchar 1  √  'N'::bpchar Constraint Type
ad_table importtable bpchar 1  √  null Import Table Columns from Database
ad_column isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_para isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_reportview isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_reportview_col isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_reportview_column isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_viewcolumn isactive bpchar 1 The record is active in the system
ad_viewcomponent isactive bpchar 1 The record is active in the system
ad_column isallowcopy bpchar 1 'Y'::bpchar Determine if a column must be copied when pushing the button to copy record
ad_column isallowlogging bpchar 1  √  'Y'::bpchar Determine if a column must be recorded into the change log
ad_column isalwaysupdateable bpchar 1 'N'::bpchar The column is always updateable, even if the record is not active or processed
ad_column isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_process_para isautocomplete bpchar 1 'N'::bpchar Automatic completion for textfields
ad_process isbetafunctionality bpchar 1 'N'::bpchar This functionality is considered Beta
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar Information maintained in System Element table
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
ad_process isdirectprint bpchar 1  √  'N'::bpchar Print without dialog
ad_column isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_process_para isencrypted bpchar 1 'N'::bpchar Display or Storage is encrypted
ad_reportview_col isgroupfunction bpchar 1 'N'::bpchar This function will generate a Group By Clause
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
ad_column ishtml bpchar 1  √  'N'::bpchar Text has HTML tags
ad_column isidentifier bpchar 1 'N'::bpchar This column is part of the record identifier
ad_column iskey bpchar 1 'N'::bpchar This column is the key in this table
ad_column ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_process_para ismandatory bpchar 1 'N'::bpchar Data entry is required in this column
ad_column isparent bpchar 1 'N'::bpchar This column is a link to the parent table (e.g. header from lines) - incl. Association key columns
ad_process_para isrange bpchar 1 'N'::bpchar The parameter is a range of values
ad_process isreport bpchar 1 'Y'::bpchar Indicates a Report record
ad_column issecure bpchar 1 'N'::bpchar Defines whether content must be treated as secure
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
ad_column isselectioncolumn bpchar 1 'N'::bpchar Is this column used for finding rows in windows
ad_process isserverprocess bpchar 1  √  null Run this Process on Server only
ad_column issyncdatabase bpchar 1  √  'N'::bpchar Change database table definition when changing dictionary definition
ad_column istoolbarbutton bpchar 1 'Y'::bpchar Show the button on the toolbar, the window, or both
ad_column istranslated bpchar 1 'N'::bpchar This column is translated
ad_viewcomponent isunionall bpchar 1 'N'::bpchar The component view is UNION ALL
ad_column isupdateable bpchar 1 'Y'::bpchar Determines, if the field can be updated
ad_table isview bpchar 1 'N'::bpchar This is a view
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_process showhelp bpchar 1  √  'Y'::bpchar Show Help
ad_process statistic_seconds numeric 0  √  null Internal statistics how many seconds a process took
ad_column version numeric 0 Version of the table definition
ad_column ad_chart_id numeric 10  √  NULL::numeric Chart
ad_column ad_client_id numeric 10 Client/Tenant for this installation.
ad_process ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_para ad_client_id numeric 10 Client/Tenant for this installation.
ad_reportview ad_client_id numeric 10 Client/Tenant for this installation.
ad_reportview_col ad_client_id numeric 10 Client/Tenant for this installation.
ad_reportview_column ad_client_id numeric 10  √  NULL::numeric Client/Tenant for this installation.
ad_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_viewcolumn ad_client_id numeric 10 Client/Tenant for this installation.
ad_viewcomponent ad_client_id numeric 10 Client/Tenant for this installation.
ad_column ad_column_id numeric 10 Column in the table
ad_reportview_col ad_column_id numeric 10  √  null Column in the table
ad_reportview_column ad_column_id numeric 10 Column in the table
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric Context Help
ad_column ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_process_para ad_element_id numeric 10  √  null System Element enables the central maintenance of column description and help.
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric Logical grouping of fields
ad_process ad_form_id numeric 10  √  null Special Form
ad_column ad_org_id numeric 10 Organizational entity within client
ad_process ad_org_id numeric 10 Organizational entity within client
ad_process_para ad_org_id numeric 10 Organizational entity within client
ad_reportview ad_org_id numeric 10 Organizational entity within client
ad_reportview_col ad_org_id numeric 10 Organizational entity within client
ad_reportview_column ad_org_id numeric 10 Organizational entity within client
ad_table ad_org_id numeric 10 Organizational entity within client
ad_viewcolumn ad_org_id numeric 10 Organizational entity within client
ad_viewcomponent ad_org_id numeric 10 Organizational entity within client
ad_process ad_printformat_id numeric 10  √  null Data Print Format
ad_column ad_process_id numeric 10  √  null Process or Report
ad_process ad_process_id numeric 10 Process or Report
ad_process_para ad_process_id numeric 10 Process or Report
ad_process_para ad_process_para_id numeric 10 Process Parameter
ad_column ad_reference_id numeric 10 System Reference and Validation
ad_process_para ad_reference_id numeric 10 System Reference and Validation
ad_column ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_process_para ad_reference_value_id numeric 10  √  null Required to specify, if data type is Table or List
ad_reportview_col ad_reportview_col_id numeric 10 Report view Column
ad_process ad_reportview_id numeric 10  √  null View used to generate this report
ad_reportview ad_reportview_id numeric 10 View used to generate this report
ad_reportview_col ad_reportview_id numeric 10 View used to generate this report
ad_reportview_column ad_reportview_id numeric 10 View used to generate this report
ad_column ad_table_id numeric 10 Database Table information
ad_reportview ad_table_id numeric 10 Database Table information
ad_table ad_table_id numeric 10 Database Table information
ad_viewcomponent ad_table_id numeric 10 Database Table information
ad_column ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_process_para ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_column ad_val_rule_lookup_id numeric 10  √  NULL::numeric Override Dynamic Validation Rule for Lookup Window
ad_viewcolumn ad_viewcolumn_id numeric 10 Database View Column
ad_viewcolumn ad_viewcomponent_id numeric 10 Database View Component
ad_viewcomponent ad_viewcomponent_id numeric 10 Database View Component
ad_table ad_window_id numeric 10  √  null Data entry or display window
ad_process ad_workflow_id numeric 10  √  null Workflow or combination of tasks
ad_column createdby numeric 10 User who created this records
ad_process createdby numeric 10 User who created this records
ad_process_para createdby numeric 10 User who created this records
ad_reportview createdby numeric 10 User who created this records
ad_reportview_col createdby numeric 10 User who created this records
ad_reportview_column createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_viewcolumn createdby numeric 10 User who created this records
ad_viewcomponent createdby numeric 10 User who created this records
ad_column fieldlength numeric 10  √  null Length of the column in the database
ad_process_para fieldlength numeric 10 Length of the column in the database
ad_table loadseq numeric 10  √  null Sequence
ad_column pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
ad_table po_window_id numeric 10  √  null Purchase Order Window
ad_viewcomponent referenced_table_id numeric 10  √  NULL::numeric Referenced Table
ad_column seqno numeric 10  √  null Method of ordering records; lowest number comes first
ad_process_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_viewcolumn seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_viewcomponent seqno numeric 10  √  NULL::numeric Method of ordering records; lowest number comes first
ad_column seqnoselection numeric 10  √  NULL::numeric Selection Column Sequence
ad_process statistic_count numeric 10  √  null Internal statistics how often the entity was used
ad_column updatedby numeric 10 User who updated this records
ad_process updatedby numeric 10 User who updated this records
ad_process_para updatedby numeric 10 User who updated this records
ad_reportview updatedby numeric 10 User who updated this records
ad_reportview_col updatedby numeric 10 User who updated this records
ad_reportview_column updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_viewcolumn updatedby numeric 10 User who updated this records
ad_viewcomponent updatedby numeric 10 User who updated this records
ad_column created timestamp 29,6 now() Date this record was created
ad_process created timestamp 29,6 now() Date this record was created
ad_process_para created timestamp 29,6 now() Date this record was created
ad_reportview created timestamp 29,6 now() Date this record was created
ad_reportview_col created timestamp 29,6 now() Date this record was created
ad_reportview_column created timestamp 29,6 Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_viewcolumn created timestamp 29,6 statement_timestamp() Date this record was created
ad_viewcomponent created timestamp 29,6 statement_timestamp() Date this record was created
ad_column updated timestamp 29,6 now() Date this record was updated
ad_process updated timestamp 29,6 now() Date this record was updated
ad_process_para updated timestamp 29,6 now() Date this record was updated
ad_reportview updated timestamp 29,6 now() Date this record was updated
ad_reportview_col updated timestamp 29,6 now() Date this record was updated
ad_reportview_column updated timestamp 29,6 Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_viewcolumn updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_viewcomponent updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_column valuemax varchar 20  √  null Maximum Value for a field
ad_process_para valuemax varchar 20  √  null Maximum Value for a field
ad_column valuemin varchar 20  √  null Minimum Value for a field
ad_process_para valuemin varchar 20  √  null Minimum Value for a field
ad_column formatpattern varchar 22  √  null The pattern used to format a number or date.
ad_column columnname varchar 30 Name of the column in the database
ad_process_para columnname varchar 30 Name of the column in the database
ad_viewcolumn columnname varchar 30 NULL::character varying Name of the column in the database
ad_column fkconstraintname varchar 30  √  NULL::character varying Constraint Name
ad_column ad_column_uu varchar 36  √  NULL::character varying AD_Column_UU
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying AD_Process_Para_UU
ad_process ad_process_uu varchar 36  √  NULL::character varying AD_Process_UU
ad_reportview_col ad_reportview_col_uu varchar 36  √  NULL::character varying AD_ReportView_Col_UU
ad_reportview_column ad_reportview_column_uu varchar 36  √  NULL::character varying AD_ReportView_Column_UU
ad_reportview ad_reportview_uu varchar 36  √  NULL::character varying AD_ReportView_UU
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
ad_viewcolumn ad_viewcolumn_uu varchar 36  √  NULL::character varying AD_ViewColumn_UU
ad_viewcomponent ad_viewcomponent_uu varchar 36  √  NULL::character varying AD_ViewComponent_UU
ad_column entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_process_para entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_reportview entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_viewcolumn entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_viewcomponent entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table tablename varchar 40 Name of the table in the database
ad_process value varchar 40 Search key for the record in the format required - must be unique
ad_process workflowvalue varchar 40  √  null Key of the Workflow to start
ad_viewcomponent name varchar 50 Alphanumeric identifier of the entity
ad_reportview_col functioncolumn varchar 60 Overwrite Column with Function
ad_column name varchar 60 Alphanumeric identifier of the entity
ad_process name varchar 60 Alphanumeric identifier of the entity
ad_process_para name varchar 60 Alphanumeric identifier of the entity
ad_reportview name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_process procedurename varchar 60  √  null Name of the Database Procedure
ad_column callout varchar 255  √  null Fully qualified class names and method - separated by semicolons
ad_process classname varchar 255  √  null Java Classname
ad_column description varchar 255  √  null Optional short description of the record
ad_process description varchar 255  √  null Optional short description of the record
ad_process_para description varchar 255  √  null Optional short description of the record
ad_reportview description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_viewcolumn description varchar 255  √  NULL::character varying Optional short description of the record
ad_viewcomponent description varchar 255  √  NULL::character varying Optional short description of the record
ad_column infofactoryclass varchar 255  √  null Fully qualified class name that implements the InfoFactory interface
ad_process jasperreport varchar 255  √  null Jasper Report
ad_column placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder varchar 255  √  NULL::character varying Placeholder
ad_process_para placeholder2 varchar 255  √  NULL::character varying Placeholder2
ad_column vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_process_para vformat varchar 255  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_viewcolumn columnsql varchar 2000  √  null Virtual Column (r/o)
ad_column defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para defaultvalue varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para defaultvalue2 varchar 2000  √  null Default value hierarchy, separated by ;
ad_process_para displaylogic varchar 2000  √  null If the Field is displayed, the result determines if the field is actually displayed
ad_viewcomponent fromclause varchar 2000 NULL::character varying SQL FROM clause
ad_column help varchar 2000  √  null Comment or Hint
ad_process help varchar 2000  √  null Comment or Hint
ad_process_para help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
ad_viewcolumn help varchar 2000  √  NULL::character varying Comment or Hint
ad_viewcomponent help varchar 2000  √  NULL::character varying Comment or Hint
ad_column mandatorylogic varchar 2000  √  null Mandatory Logic
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying Mandatory Logic
ad_reportview orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
ad_viewcomponent otherclause varchar 2000  √  NULL::character varying Other SQL Clause
ad_process_para query varchar 2000  √  NULL::character varying SQL
ad_column readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_process_para readonlylogic varchar 2000  √  null Logic to determine if field is read only (applies only when field is read-write)
ad_reportview whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_viewcomponent whereclause varchar 2000  √  NULL::character varying Fully qualified SQL WHERE clause
ad_column columnsql varchar 4000  √  null Virtual Column (r/o)