idempiere11.adempiere contains 249 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
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_process	accesslevel	bpchar	1				Access Level required
ad_table	accesslevel	bpchar	1				Access Level required
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
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	createpartition	bpchar	1	√		NULL::bpchar	Process which create or update table partitions based on the table and column records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_process_para	daterangeoption	bpchar	1			'D'::bpchar	Options, how the date editor will be displayed.
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 text fields
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for text fields
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_viewcomponent	isdistinct	bpchar	1			'N'::bpchar	Select Distinct
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_table	ispartition	bpchar	1			'N'::bpchar	This is a partitioned table
ad_column	ispartitionkey	bpchar	1			'N'::bpchar	This is a partition key
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_table	isshowindrilloptions	bpchar	1	√		'Y'::bpchar	This parameter enables the table to be displayed in Drill Assistant - Table tab
ad_process_para	isshownegatebutton	bpchar	1			'N'::bpchar	Show Negate Button for Chosen Multiple editors
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	allowmultipleexecution	varchar	2			'P'::character varying	Allow or disallow executing a process/report multiple times concurrently
ad_column	partitioningmethod	varchar	2	√		NULL::character varying	Indicates how the Table is partitioned
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_column	ad_client_id	numeric	10				Tenant for this installation.
ad_process	ad_client_id	numeric	10				Tenant for this installation.
ad_process_para	ad_client_id	numeric	10				Tenant for this installation.
ad_reportview	ad_client_id	numeric	10				Tenant for this installation.
ad_reportview_col	ad_client_id	numeric	10				Tenant for this installation.
ad_reportview_column	ad_client_id	numeric	10	√		NULL::numeric	Tenant for this installation.
ad_table	ad_client_id	numeric	10				Tenant for this installation.
ad_viewcolumn	ad_client_id	numeric	10				Tenant for this installation.
ad_viewcomponent	ad_client_id	numeric	10				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_infowindow_id	numeric	10	√		null	Info and search/select Window
ad_column	ad_org_id	numeric	10				Organizational entity within tenant
ad_process	ad_org_id	numeric	10				Organizational entity within tenant
ad_process_para	ad_org_id	numeric	10				Organizational entity within tenant
ad_reportview	ad_org_id	numeric	10				Organizational entity within tenant
ad_reportview_col	ad_org_id	numeric	10				Organizational entity within tenant
ad_reportview_column	ad_org_id	numeric	10				Organizational entity within tenant
ad_table	ad_org_id	numeric	10				Organizational entity within tenant
ad_viewcolumn	ad_org_id	numeric	10				Organizational entity within tenant
ad_viewcomponent	ad_org_id	numeric	10				Organizational entity within tenant
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_column	fkconstraintmsg_id	numeric	10	√		NULL::numeric	Constraint Message
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	seqnopartition	numeric	10	√		NULL::numeric	Indicates the order of partition keys
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	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	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_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	rangepartitioninterval	varchar	30	√		NULL::character varying	Indicates the interval used in a range partitioning
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_process	filenamepattern	varchar	255	√		NULL::character varying	File Name Pattern
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_column	alwaysupdatablelogic	varchar	2000	√		NULL::character varying	Logic to determine if field is Updatable irrespective if record's active status or processed status. This logic Applicable only if Always Updatable is N.
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_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)
ad_viewcomponent	fromclause	varchar	4000			NULL::character varying	SQL FROM clause