idempiere9.adempiere contains 264 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
ad_workflow	author	varchar	20			'ComPiere'::character varying	Author/Creator of the Entity
ad_form	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_menu	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_task	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_wf_nodenext	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_window	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_workflow	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_workflow	workflowtype	bpchar	1			'G'::bpchar	Type of Workflow
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_wf_node	ismilestone	bpchar	1	√		'N'::bpchar	Is Milestone
ad_task	isserverprocess	bpchar	1	√		'N'::bpchar	Run this Process on Server only
ad_wf_node	issubcontracting	bpchar	1	√		'N'::bpchar	Is Subcontracting
ad_form	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_process	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_window	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_workflow	isbetafunctionality	bpchar	1			'N'::bpchar	This functionality is considered Beta
ad_window	isdefault	bpchar	1			'N'::bpchar	Default value
ad_workflow	isdefault	bpchar	1			'N'::bpchar	Default value
ad_menu	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_wf_nodenext	isstduserworkflow	bpchar	1			'N'::bpchar	Standard Manual User Approval Workflow
ad_menu	issummary	bpchar	1			'N'::bpchar	This is a summary entity
ad_workflow	isvalid	bpchar	1			'N'::bpchar	Element is valid
ad_wf_process	processed	bpchar	1			'N'::bpchar	The document has been processed
ad_process	allowmultipleexecution	bpchar	1	√		'P'::bpchar	Allow or disallow executing a process/report multiple times.
ad_wf_node	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_menu	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
ad_form	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_menu	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_task	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_nodenext	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_process	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_window	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_workflow	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_wf_node	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
ad_menu	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_window	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_wf_node	unitscycles	numeric	0	√		(0)::numeric	The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
ad_workflow	qtybatchsize	numeric	0	√		(1)::numeric	Qty Batch Size
ad_wf_node	yield	numeric	10	√		(100)::numeric	The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
ad_workflow	yield	numeric	10	√		(100)::numeric	The Yield is the percentage of a lot that is expected to be of acceptable wuality may fall below 100 percent
ad_wf_node	cost	numeric	0			0	Cost information
ad_wf_node	duration	numeric	10			0	Normal Duration in Duration Unit
ad_workflow	duration	numeric	10			0	Normal Duration in Duration Unit
ad_wf_node	limit	numeric	10			0	Maximum Duration in Duration Unit
ad_workflow	version	numeric	10			0	Version of the table definition
ad_wf_node	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_workflow	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_workflow	workingtime	numeric	10			0	Workflow Simulation Execution Time
ad_wf_node	xposition	numeric	10			0	Absolute X (horizontal) position in 1/72 of an inch
ad_wf_node	yposition	numeric	10			0	Absolute Y (vertical) position in 1/72 of an inch
ad_form	created	timestamp	29,6			now()	Date this record was created
ad_menu	created	timestamp	29,6			now()	Date this record was created
ad_process	created	timestamp	29,6			now()	Date this record was created
ad_task	created	timestamp	29,6			now()	Date this record was created
ad_wf_node	created	timestamp	29,6			now()	Date this record was created
ad_wf_nodenext	created	timestamp	29,6			now()	Date this record was created
ad_wf_process	created	timestamp	29,6			now()	Date this record was created
ad_window	created	timestamp	29,6			now()	Date this record was created
ad_workflow	created	timestamp	29,6			now()	Date this record was created
ad_form	updated	timestamp	29,6			now()	Date this record was updated
ad_menu	updated	timestamp	29,6			now()	Date this record was updated
ad_process	updated	timestamp	29,6			now()	Date this record was updated
ad_task	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_node	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_nodenext	updated	timestamp	29,6			now()	Date this record was updated
ad_wf_process	updated	timestamp	29,6			now()	Date this record was updated
ad_window	updated	timestamp	29,6			now()	Date this record was updated
ad_workflow	updated	timestamp	29,6			now()	Date this record was updated
ad_menu	action	bpchar	1	√		null	Indicates the Action to be performed
ad_window	ad_color_id	numeric	10	√		null	Color for backgrounds or indicators
ad_wf_node	ad_column_id	numeric	10	√		null	Column in the table
ad_menu	ad_form_id	numeric	10	√		null	Special Form
ad_process	ad_form_id	numeric	10	√		null	Special Form
ad_wf_node	ad_form_id	numeric	10	√		null	Special Form
ad_wf_node	ad_image_id	numeric	10	√		null	Image or Icon
ad_window	ad_image_id	numeric	10	√		null	Image or Icon
ad_wf_process	ad_message_id	numeric	10	√		null	System Message
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_menu	ad_process_id	numeric	10	√		null	Process or Report
ad_wf_node	ad_process_id	numeric	10	√		null	Process or Report
ad_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_workflow	ad_table_id	numeric	10	√		null	Database Table information
ad_menu	ad_task_id	numeric	10	√		null	Operation System Task
ad_wf_node	ad_task_id	numeric	10	√		null	Operation System Task
ad_wf_process	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_wf_node	ad_wf_block_id	numeric	10	√		null	Workflow Transaction Execution Block
ad_workflow	ad_wf_node_id	numeric	10	√		null	Workflow Node (activity), step or process
ad_wf_node	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
ad_workflow	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
ad_menu	ad_window_id	numeric	10	√		null	Data entry or display window
ad_wf_node	ad_window_id	numeric	10	√		null	Data entry or display window
ad_menu	ad_workbench_id	numeric	10	√		null	Collection of windows, reports
ad_menu	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_process	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_workflow	ad_workflowprocessor_id	numeric	10	√		null	Workflow Processor Server
ad_wf_node	attributename	varchar	60	√		null	Name of the Attribute
ad_wf_node	attributevalue	varchar	60	√		null	Value of the Attribute
ad_wf_node	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
ad_form	classname	varchar	60	√		null	Java Classname
ad_process	classname	varchar	255	√		null	Java Classname
ad_form	description	varchar	255	√		null	Optional short description of the record
ad_menu	description	varchar	255	√		null	Optional short description of the record
ad_process	description	varchar	255	√		null	Optional short description of the record
ad_task	description	varchar	255	√		null	Optional short description of the record
ad_wf_node	description	varchar	255	√		null	Optional short description of the record
ad_wf_nodenext	description	varchar	255	√		null	Optional short description of the record
ad_window	description	varchar	255	√		null	Optional short description of the record
ad_workflow	description	varchar	255	√		null	Optional short description of the record
ad_wf_node	docaction	bpchar	2	√		null	The targeted status of the document
ad_workflow	documentno	varchar	30	√		null	Document sequence number of the document
ad_workflow	docvaluelogic	varchar	2000	√		null	Logic to determine Workflow Start - If true, a workflow process is started for the document
ad_workflow	durationunit	bpchar	1	√		null	Unit of Duration
ad_wf_node	dynprioritychange	numeric	0	√		null	Change of priority when Activity is suspended waiting for user
ad_wf_node	dynpriorityunit	bpchar	1	√		null	Change of priority when Activity is suspended waiting for user
ad_wf_node	email	varchar	60	√		null	Electronic Mail Address
ad_wf_node	emailrecipient	bpchar	1	√		null	Recipient of the EMail
ad_wf_node	finishmode	bpchar	1	√		null	Workflow Activity Finish Mode
ad_form	help	varchar	2000	√		null	Comment or Hint
ad_process	help	varchar	2000	√		null	Comment or Hint
ad_task	help	varchar	2000	√		null	Comment or Hint
ad_wf_node	help	text	2147483647	√		null	Comment or Hint
ad_window	help	varchar	2000	√		null	Comment or Hint
ad_workflow	help	text	2147483647	√		null	Comment or Hint
ad_process	isserverprocess	bpchar	1	√		null	Run this Process on Server only
ad_process	jasperreport	varchar	255	√		null	Jasper Report
ad_form	jspurl	varchar	120	√		null	Web URL of the jsp function
ad_workflow	limit	numeric	10	√		null	Maximum Duration in Duration Unit
ad_wf_node	movingtime	numeric	10	√		null	Moving Time
ad_workflow	movingtime	numeric	10	√		null	Moving Time
ad_wf_node	overlapunits	numeric	10	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
ad_workflow	overlapunits	numeric	0	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
ad_wf_node	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_wf_process	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_workflow	priority	numeric	10	√		null	Indicates if this request is of a high, medium or low priority.
ad_process	procedurename	varchar	60	√		null	Name of the Database Procedure
ad_wf_process	processing	bpchar	1	√		null	Process Now
ad_window	processing	bpchar	1	√		null	Process Now
ad_workflow	processtype	bpchar	2	√		null	Process Type
ad_wf_node	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_workflow	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_wf_node	r_mailtext_id	numeric	10	√		null	Text templates for mailings
ad_wf_node	s_resource_id	numeric	10	√		null	Resource
ad_workflow	s_resource_id	numeric	10	√		null	Resource
ad_wf_node	setuptime	numeric	10	√		null	Setup time before starting Production
ad_workflow	setuptime	numeric	10	√		null	Setup time before starting Production
ad_wf_node	startmode	bpchar	1	√		null	Workflow Activity Start Mode
ad_process	statistic_count	numeric	10	√		null	Internal statistics how often the entity was used
ad_process	statistic_seconds	numeric	0	√		null	Internal statistics how many seconds a process took
ad_wf_node	subflowexecution	bpchar	1	√		null	Mode how the sub-workflow is executed
ad_wf_process	textmsg	varchar	2000	√		null	Text Message
ad_wf_nodenext	transitioncode	varchar	2000	√		null	Code resulting in TRUE of FALSE
ad_workflow	unitscycles	numeric	0	√		null	The Units by Cycles are defined for process type Flow Repetitive Dedicated and indicated the product to be manufactured on a production line for duration unit.
ad_workflow	validateworkflow	bpchar	1	√		null	Validate Workflow
ad_wf_node	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
ad_workflow	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
ad_wf_node	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_workflow	validto	timestamp	29,6	√		null	Valid to including this date (last day)
ad_wf_node	waittime	numeric	10	√		null	Time in minutes to wait (sleep)
ad_window	windowtype	bpchar	1	√		null	Type or classification of a Window
ad_window	winheight	numeric	10	√		null	Window Height
ad_window	winwidth	numeric	10	√		null	Window Width
ad_wf_node	workflow_id	numeric	10	√		null	Workflow or tasks
ad_process	workflowvalue	varchar	40	√		null	Key of the Workflow to start
ad_wf_node	workingtime	numeric	10	√		null	Workflow Simulation Execution Time
ad_form	accesslevel	bpchar	1				Access Level required
ad_process	accesslevel	bpchar	1				Access Level required
ad_task	accesslevel	bpchar	1				Access Level required
ad_workflow	accesslevel	bpchar	1				Access Level required
ad_wf_node	action	bpchar	1				Indicates the Action to be performed
ad_form	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_menu	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_process	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_task	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wf_node	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wf_nodenext	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_wf_process	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_window	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_workflow	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_form	ad_form_id	numeric	10				Special Form
ad_menu	ad_menu_id	numeric	10				Identifies a Menu
ad_form	ad_org_id	numeric	10				Organizational entity within client
ad_menu	ad_org_id	numeric	10				Organizational entity within client
ad_process	ad_org_id	numeric	10				Organizational entity within client
ad_task	ad_org_id	numeric	10				Organizational entity within client
ad_wf_node	ad_org_id	numeric	10				Organizational entity within client
ad_wf_nodenext	ad_org_id	numeric	10				Organizational entity within client
ad_wf_process	ad_org_id	numeric	10				Organizational entity within client
ad_window	ad_org_id	numeric	10				Organizational entity within client
ad_workflow	ad_org_id	numeric	10				Organizational entity within client
ad_process	ad_process_id	numeric	10				Process or Report
ad_wf_process	ad_table_id	numeric	10				Database Table information
ad_task	ad_task_id	numeric	10				Operation System Task
ad_wf_nodenext	ad_wf_next_id	numeric	10				Next Node in workflow
ad_wf_node	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_nodenext	ad_wf_node_id	numeric	10				Workflow Node (activity), step or process
ad_wf_nodenext	ad_wf_nodenext_id	numeric	10				Workflow Node Transition
ad_wf_process	ad_wf_process_id	numeric	10				Actual Workflow Process Instance
ad_wf_process	ad_wf_responsible_id	numeric	10				Responsible for Workflow Execution
ad_window	ad_window_id	numeric	10				Data entry or display window
ad_wf_node	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_wf_process	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_workflow	cost	numeric	0				Cost information
ad_form	createdby	numeric	10				User who created this records
ad_menu	createdby	numeric	10				User who created this records
ad_process	createdby	numeric	10				User who created this records
ad_task	createdby	numeric	10				User who created this records
ad_wf_node	createdby	numeric	10				User who created this records
ad_wf_nodenext	createdby	numeric	10				User who created this records
ad_wf_process	createdby	numeric	10				User who created this records
ad_window	createdby	numeric	10				User who created this records
ad_workflow	createdby	numeric	10				User who created this records
ad_wf_node	joinelement	bpchar	1				Semantics for multiple incoming Transitions
ad_form	name	varchar	60				Alphanumeric identifier of the entity
ad_menu	name	varchar	60				Alphanumeric identifier of the entity
ad_process	name	varchar	60				Alphanumeric identifier of the entity
ad_task	name	varchar	60				Alphanumeric identifier of the entity
ad_wf_node	name	varchar	60				Alphanumeric identifier of the entity
ad_window	name	varchar	60				Alphanumeric identifier of the entity
ad_workflow	name	varchar	60				Alphanumeric identifier of the entity
ad_task	os_command	varchar	2000				Operating System Command
ad_workflow	publishstatus	bpchar	1				Status of Publication
ad_wf_process	record_id	numeric	10				Direct internal record ID
ad_wf_nodenext	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_wf_node	splitelement	bpchar	1				Semantics for multiple outgoing Transitions
ad_form	updatedby	numeric	10				User who updated this records
ad_menu	updatedby	numeric	10				User who updated this records
ad_process	updatedby	numeric	10				User who updated this records
ad_task	updatedby	numeric	10				User who updated this records
ad_wf_node	updatedby	numeric	10				User who updated this records
ad_wf_nodenext	updatedby	numeric	10				User who updated this records
ad_wf_process	updatedby	numeric	10				User who updated this records
ad_window	updatedby	numeric	10				User who updated this records
ad_workflow	updatedby	numeric	10				User who updated this records
ad_process	value	varchar	40				Search key for the record in the format required - must be unique
ad_wf_node	value	varchar	40				Search key for the record in the format required - must be unique
ad_workflow	value	varchar	40				Search key for the record in the format required - must be unique
ad_wf_process	wfstate	bpchar	2				State of the execution of the workflow
ad_process	copyfromprocess	bpchar	1	√		NULL::bpchar	Copy settings from one report and process to another.
ad_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
ad_form	ad_form_uu	varchar	36	√		NULL::character varying	AD_Form_UU
ad_menu	ad_menu_uu	varchar	36	√		NULL::character varying	AD_Menu_UU
ad_process	ad_process_uu	varchar	36	√		NULL::character varying	AD_Process_UU
ad_task	ad_task_uu	varchar	36	√		NULL::character varying	AD_Task_UU
ad_wf_node	ad_wf_node_uu	varchar	36	√		NULL::character varying	AD_WF_Node_UU
ad_wf_nodenext	ad_wf_nodenext_uu	varchar	36	√		NULL::character varying	AD_WF_NodeNext_UU
ad_wf_process	ad_wf_process_uu	varchar	36	√		NULL::character varying	AD_WF_Process_UU
ad_window	ad_window_uu	varchar	36	√		NULL::character varying	AD_Window_UU
ad_workflow	ad_workflow_uu	varchar	36	√		NULL::character varying	AD_Workflow_UU
ad_menu	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_window	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_window	titlelogic	varchar	255	√		NULL::character varying	The result determines the title to be displayed for this window
ad_form	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_task	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_wf_node	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_workflow	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_menu	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_wf_node	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window