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

Table	Column	Type	Size	Nulls	Auto	Default
ad_field	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_window	ad_color_id	numeric	10	√		null	Color for backgrounds or indicators
ad_field	ad_column_id	numeric	10	√		null	Column in the table
ad_tab	ad_column_id	numeric	10	√		null	Column in the table
ad_tab	ad_columnsortorder_id	numeric	10	√		null	Column determining the order
ad_tab	ad_columnsortyesno_id	numeric	10	√		null	Column determining if a Table Column is included in Ordering
ad_form	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_tab	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_task	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_workflow	ad_ctxhelp_id	numeric	10	√		NULL::numeric	Context Help
ad_process_para	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
asp_clientexception	ad_field_id	numeric	10	√		null	Field on a database table
ad_field	ad_field_uu	varchar	36	√		NULL::character varying	AD_Field_UU
ad_field	ad_fieldgroup_id	numeric	10	√		null	Logical grouping of fields
ad_process_para	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_field	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_process	ad_form_id	numeric	10	√		null	Special Form
asp_clientexception	ad_form_id	numeric	10	√		null	Special Form
ad_form	ad_form_uu	varchar	36	√		NULL::character varying	AD_Form_UU
ad_tab	ad_image_id	numeric	10	√		null	Image or Icon
ad_window	ad_image_id	numeric	10	√		null	Image or Icon
ad_field	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_tab	ad_process_id	numeric	10	√		null	Process or Report
asp_clientexception	ad_process_id	numeric	10	√		null	Process or Report
asp_clientexception	ad_process_para_id	numeric	10	√		null	Process Parameter
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_ref_list	ad_ref_list_uu	varchar	36	√		NULL::character varying	AD_Ref_List_UU
ad_field	ad_reference_id	numeric	10	√		null	System Reference and Validation
ad_field	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_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_tab_customization	ad_tab_customization_uu	varchar	36	√		NULL::character varying	AD_Tab_Customization_UU
ad_tab_customization	ad_tab_id	numeric	10	√		NULL::numeric	Tab within a Window
asp_clientexception	ad_tab_id	numeric	10	√		null	Tab within a Window
ad_tab	ad_tab_uu	varchar	36	√		NULL::character varying	AD_Tab_UU
ad_workflow	ad_table_id	numeric	10	√		null	Database Table information
ad_tab	ad_tabtype	varchar	40	√		NULL::character varying	Defines Tab Type
asp_clientexception	ad_task_id	numeric	10	√		null	Operation System Task
ad_task	ad_task_uu	varchar	36	√		NULL::character varying	AD_Task_UU
ad_field	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_process_para	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_field	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_workflow	ad_wf_node_id	numeric	10	√		null	Workflow Node (activity), step or process
asp_clientexception	ad_wf_node_id	numeric	10	√		null	Workflow Node (activity), step or process
ad_workflow	ad_wf_responsible_id	numeric	10	√		null	Responsible for Workflow Execution
asp_clientexception	ad_window_id	numeric	10	√		null	Data entry or display window
ad_window	ad_window_uu	varchar	36	√		NULL::character varying	AD_Window_UU
ad_process	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
asp_clientexception	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
ad_workflow	ad_workflow_uu	varchar	36	√		NULL::character varying	AD_Workflow_UU
ad_workflow	ad_workflowprocessor_id	numeric	10	√		null	Workflow Processor Server
asp_tab	allfields	bpchar	1	√		'Y'::bpchar	All Fields
ad_field	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.
asp_clientexception	asp_clientexception_uu	varchar	36	√		NULL::character varying	ASP_ClientException_UU
asp_clientlevel	asp_clientlevel_uu	varchar	36	√		NULL::character varying	ASP_ClientLevel_UU
asp_field	asp_field_uu	varchar	36	√		NULL::character varying	ASP_Field_UU
asp_form	asp_form_uu	varchar	36	√		NULL::character varying	ASP_Form_UU
asp_level	asp_level_uu	varchar	36	√		NULL::character varying	ASP_Level_UU
asp_module	asp_module_uu	varchar	36	√		NULL::character varying	ASP_Module_UU
asp_process_para	asp_process_id	numeric	10	√		null	ASP Process
asp_process_para	asp_process_para_uu	varchar	36	√		NULL::character varying	ASP_Process_Para_UU
asp_process	asp_process_uu	varchar	36	√		NULL::character varying	ASP_Process_UU
asp_ref_list	asp_ref_list_uu	varchar	36	√		NULL::character varying	ASP_Ref_List_UU
asp_ref_list	asp_status	bpchar	1	√		'U'::bpchar	ASP Status
asp_field	asp_tab_id	numeric	10	√		null	ASP Tab
asp_tab	asp_tab_uu	varchar	36	√		NULL::character varying	ASP_Tab_UU
asp_task	asp_task_uu	varchar	36	√		NULL::character varying	ASP_Task_UU
asp_tab	asp_window_id	numeric	10	√		null	ASP Window
asp_window	asp_window_uu	varchar	36	√		NULL::character varying	ASP_Window_UU
asp_workflow	asp_workflow_uu	varchar	36	√		NULL::character varying	ASP_Workflow_UU
ad_form	classname	varchar	60	√		null	Java Classname
ad_process	classname	varchar	255	√		null	Java Classname
ad_field	columnspan	numeric	10	√		(1)::numeric	Number of column for a box of field
ad_field	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_tab	commitwarning	varchar	2000	√		null	Warning displayed when saving
ad_process	copyfromprocess	bpchar	1	√		NULL::bpchar	Copy settings from one report and process to another.
ad_field	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_tab	deleteconfirmationlogic	varchar	255	√		NULL::character varying	Delete Confirmation Logic
ad_field	description	varchar	255	√		null	Optional short description of the record
ad_form	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_ref_list	description	varchar	255	√		null	Optional short description of the record
ad_tab	description	varchar	255	√		null	Optional short description of the record
ad_task	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
asp_level	description	varchar	255	√		null	Optional short description of the record
asp_module	description	varchar	255	√		null	Optional short description of the record
ad_field	displaylength	numeric	10	√		null	Length of the display in characters
ad_field	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_process_para	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_tab	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
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_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
ad_process	filenamepattern	varchar	255	√		NULL::character varying	File Name Pattern
ad_field	help	varchar	2000	√		null	Comment or Hint
ad_form	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_tab	help	varchar	2000	√		null	Comment or Hint
ad_task	help	varchar	2000	√		null	Comment or Hint
ad_window	help	varchar	2000	√		null	Comment or Hint
ad_workflow	help	text	2147483647	√		null	Comment or Hint
asp_clientlevel	help	varchar	2000	√		null	Comment or Hint
asp_level	help	varchar	2000	√		null	Comment or Hint
asp_module	help	varchar	2000	√		null	Comment or Hint
ad_form	imageurl	varchar	120	√		NULL::character varying	URL of image
ad_tab	importfields	bpchar	1	√		null	Create Fields from Table Columns
ad_field	included_tab_id	numeric	10	√		null	Included Tab in this Tab (Master Detail)
ad_tab	included_tab_id	numeric	10	√		null	Included Tab in this Tab (Master Detail)
ad_field	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
asp_ref_list	isactive	bpchar	1	√		'Y'::bpchar	The record is active in the system
ad_field	isadvancedfield	bpchar	1	√		'N'::bpchar	Advanced Field
ad_tab	isallowadvancedlookup	bpchar	1	√		'Y'::bpchar	Allow Advanced Lookup
ad_field	isallowcopy	bpchar	1	√		NULL::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_field	isalwaysupdateable	bpchar	1	√		NULL::bpchar	The column is always updateable, even if the record is not active or processed
ad_tab_customization	isautohideemptycolumn	bpchar	1	√		NULL::bpchar	Auto Hide Empty Column
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_field	isdisplayedgrid	bpchar	1	√		'Y'::bpchar	Show in Grid
ad_tab_customization	isdisplayedgrid	bpchar	1	√		NULL::bpchar	Show in Grid
ad_tab	ishighvolume	bpchar	1	√		NULL::bpchar	Use Search instead of Pick list
ad_tab	isinfotab	bpchar	1	√		'N'::bpchar	This Tab contains accounting information
ad_tab	islookuponlyselection	bpchar	1	√		'N'::bpchar	When defined to true Lookup panel will display only selection columns. Default to false.
ad_field	ismandatory	bpchar	1	√		null	Data entry is required in this column
ad_tab_customization	isquickform	bpchar	1	√		'N'::bpchar	Display in Quick Form
ad_field	isselectioncolumn	bpchar	1	√		NULL::bpchar	Is this column used for finding rows in windows
ad_process	isserverprocess	bpchar	1	√		null	Run this Process on Server only
ad_task	isserverprocess	bpchar	1	√		'N'::bpchar	Run this Process on Server only
ad_field	istoolbarbutton	bpchar	1	√		null	Show the button on the toolbar, the window, or both
ad_field	isupdateable	bpchar	1	√		NULL::bpchar	Determines, if the field can be updated
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_field	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_process_para	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_tab	maxqueryrecords	numeric	10	√		'0'::numeric	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
ad_workflow	movingtime	numeric	10	√		null	Moving Time
ad_field	numlines	numeric	10	√		(1)::numeric	Number of lines for a field
ad_field	obscuretype	bpchar	3	√		null	Type of obscuring the data (limiting the display)
ad_tab	orderbyclause	varchar	2000	√		null	Fully qualified ORDER BY clause
ad_workflow	overlapunits	numeric	0	√		null	Overlap Units are number of units that must be completed before they are moved the next activity
ad_tab	parent_column_id	numeric	10	√		NULL::numeric	The link column on the parent tab.
ad_field	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_window	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
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_tab	processing	bpchar	1	√		null	Process Now
ad_window	processing	bpchar	1	√		null	Process Now
asp_level	processing	bpchar	1	√		null	Process Now
asp_tab	processing	bpchar	1	√		null	Process Now
ad_workflow	processtype	bpchar	2	√		null	Process Type
ad_workflow	qtybatchsize	numeric	0	√		(1)::numeric	Qty Batch Size
ad_process_para	query	varchar	2000	√		NULL::character varying	SQL
ad_workflow	queuingtime	numeric	10	√		null	Queue time is the time a job waits at a work center before begin handled.
ad_field	readonlylogic	varchar	2000	√		NULL::character varying	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_tab	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
ad_workflow	s_resource_id	numeric	10	√		null	Resource
ad_field	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_field	seqnogrid	numeric	10	√		NULL::numeric	Grid Sequence No
ad_workflow	setuptime	numeric	10	√		null	Setup time before starting Production
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
ad_field	sortno	numeric	10	√		null	Determines in what order the records are displayed
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_window	titlelogic	varchar	255	√		NULL::character varying	The result determines the title to be displayed for this window
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_ref_list	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_ref_list	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_process_para	valuemax	varchar	20	√		null	Maximum Value for a field
ad_process_para	valuemin	varchar	20	√		null	Minimum Value for a field
ad_field	vformat	varchar	255	√		NULL::character varying	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_tab	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
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_process	workflowvalue	varchar	40	√		null	Key of the Workflow to start
ad_field	xposition	numeric	10	√		(1)::numeric	Absolute X (horizontal) position in 1/72 of an inch
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_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_field	ad_client_id	numeric	10				Tenant for this installation.
ad_form	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_ref_list	ad_client_id	numeric	10				Tenant for this installation.
ad_tab	ad_client_id	numeric	10				Tenant for this installation.
ad_tab_customization	ad_client_id	numeric	10				Tenant for this installation.
ad_task	ad_client_id	numeric	10				Tenant for this installation.
ad_window	ad_client_id	numeric	10				Tenant for this installation.
ad_workflow	ad_client_id	numeric	10				Tenant for this installation.
asp_clientexception	ad_client_id	numeric	10				Tenant for this installation.
asp_clientlevel	ad_client_id	numeric	10				Tenant for this installation.
asp_field	ad_client_id	numeric	10				Tenant for this installation.
asp_form	ad_client_id	numeric	10				Tenant for this installation.
asp_level	ad_client_id	numeric	10				Tenant for this installation.
asp_module	ad_client_id	numeric	10				Tenant for this installation.
asp_process	ad_client_id	numeric	10				Tenant for this installation.
asp_process_para	ad_client_id	numeric	10				Tenant for this installation.
asp_ref_list	ad_client_id	numeric	10				Tenant for this installation.
asp_tab	ad_client_id	numeric	10				Tenant for this installation.
asp_task	ad_client_id	numeric	10				Tenant for this installation.
asp_window	ad_client_id	numeric	10				Tenant for this installation.
asp_workflow	ad_client_id	numeric	10				Tenant for this installation.
ad_field	ad_field_id	numeric	10				Field on a database table
asp_field	ad_field_id	numeric	10				Field on a database table
ad_form	ad_form_id	numeric	10				Special Form
asp_form	ad_form_id	numeric	10				Special Form
ad_field	ad_org_id	numeric	10				Organizational entity within tenant
ad_form	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_ref_list	ad_org_id	numeric	10				Organizational entity within tenant
ad_tab	ad_org_id	numeric	10				Organizational entity within tenant
ad_tab_customization	ad_org_id	numeric	10				Organizational entity within tenant
ad_task	ad_org_id	numeric	10				Organizational entity within tenant
ad_window	ad_org_id	numeric	10				Organizational entity within tenant
ad_workflow	ad_org_id	numeric	10				Organizational entity within tenant
asp_clientexception	ad_org_id	numeric	10			0	Organizational entity within tenant
asp_clientlevel	ad_org_id	numeric	10			0	Organizational entity within tenant
asp_field	ad_org_id	numeric	10				Organizational entity within tenant
asp_form	ad_org_id	numeric	10				Organizational entity within tenant
asp_level	ad_org_id	numeric	10				Organizational entity within tenant
asp_module	ad_org_id	numeric	10				Organizational entity within tenant
asp_process	ad_org_id	numeric	10				Organizational entity within tenant
asp_process_para	ad_org_id	numeric	10				Organizational entity within tenant
asp_ref_list	ad_org_id	numeric	10				Organizational entity within tenant
asp_tab	ad_org_id	numeric	10				Organizational entity within tenant
asp_task	ad_org_id	numeric	10				Organizational entity within tenant
asp_window	ad_org_id	numeric	10				Organizational entity within tenant
asp_workflow	ad_org_id	numeric	10				Organizational entity within tenant
ad_process	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_id	numeric	10				Process or Report
asp_process	ad_process_id	numeric	10				Process or Report
ad_process_para	ad_process_para_id	numeric	10				Process Parameter
asp_process_para	ad_process_para_id	numeric	10				Process Parameter
ad_ref_list	ad_ref_list_id	numeric	10				Reference List based on Table
asp_ref_list	ad_ref_list_id	numeric	10				Reference List based on Table
ad_process_para	ad_reference_id	numeric	10				System Reference and Validation
ad_ref_list	ad_reference_id	numeric	10				System Reference and Validation
asp_ref_list	ad_reference_id	numeric	10				System Reference and Validation
ad_tab_customization	ad_tab_customization_id	numeric	10			NULL::numeric	Tab Customization
ad_field	ad_tab_id	numeric	10				Tab within a Window
ad_tab	ad_tab_id	numeric	10				Tab within a Window
asp_tab	ad_tab_id	numeric	10				Tab within a Window
ad_tab	ad_table_id	numeric	10				Database Table information
ad_task	ad_task_id	numeric	10				Operation System Task
asp_task	ad_task_id	numeric	10				Operation System Task
ad_tab_customization	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_tab	ad_window_id	numeric	10				Data entry or display window
ad_window	ad_window_id	numeric	10				Data entry or display window
asp_window	ad_window_id	numeric	10				Data entry or display window
ad_workflow	ad_workflow_id	numeric	10				Workflow or combination of tasks
asp_workflow	ad_workflow_id	numeric	10				Workflow or combination of tasks
ad_process	allowmultipleexecution	varchar	2			'P'::character varying	Allow or disallow executing a process/report multiple times concurrently
asp_clientexception	asp_clientexception_id	numeric	10				Tenant Exception
asp_clientlevel	asp_clientlevel_id	numeric	10				Tenant Level
asp_field	asp_field_id	numeric	10				ASP Field
asp_form	asp_form_id	numeric	10				ASP Form
asp_clientlevel	asp_level_id	numeric	10				ASP Level
asp_form	asp_level_id	numeric	10				ASP Level
asp_level	asp_level_id	numeric	10				ASP Level
asp_process	asp_level_id	numeric	10				ASP Level
asp_ref_list	asp_level_id	numeric	10				ASP Level
asp_task	asp_level_id	numeric	10				ASP Level
asp_window	asp_level_id	numeric	10				ASP Level
asp_workflow	asp_level_id	numeric	10				ASP Level
asp_clientlevel	asp_module_id	numeric	10				ASP Module
asp_level	asp_module_id	numeric	10				ASP Module
asp_module	asp_module_id	numeric	10				ASP Module
asp_process	asp_process_id	numeric	10				ASP Process
asp_process_para	asp_process_para_id	numeric	10				ASP Process Parameter
asp_ref_list	asp_ref_list_id	numeric	10				ASP_Ref_List
asp_clientexception	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_field	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_form	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_process	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_process_para	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_tab	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_task	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_window	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_workflow	asp_status	bpchar	1			'U'::bpchar	ASP Status
asp_tab	asp_tab_id	numeric	10				ASP Tab
asp_task	asp_task_id	numeric	10				ASP Task
asp_window	asp_window_id	numeric	10				ASP Window
asp_workflow	asp_workflow_id	numeric	10				ASP Workflow
ad_workflow	author	varchar	20			'ComPiere'::character varying	Author/Creator of the Entity
ad_process_para	columnname	varchar	30				Name of the column in the database
ad_workflow	cost	numeric	0				Cost information
ad_field	created	timestamp	29,6			now()	Date this record was created
ad_form	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_ref_list	created	timestamp	29,6			now()	Date this record was created
ad_tab	created	timestamp	29,6			now()	Date this record was created
ad_tab_customization	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_task	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
asp_clientexception	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_clientlevel	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_field	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_form	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_level	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_module	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_process	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_process_para	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_ref_list	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_tab	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_task	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_window	created	timestamp	29,6			statement_timestamp()	Date this record was created
asp_workflow	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_field	createdby	numeric	10				User who created this records
ad_form	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_ref_list	createdby	numeric	10				User who created this records
ad_tab	createdby	numeric	10				User who created this records
ad_tab_customization	createdby	numeric	10				User who created this records
ad_task	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
asp_clientexception	createdby	numeric	10				User who created this records
asp_clientlevel	createdby	numeric	10				User who created this records
asp_field	createdby	numeric	10				User who created this records
asp_form	createdby	numeric	10				User who created this records
asp_level	createdby	numeric	10				User who created this records
asp_module	createdby	numeric	10				User who created this records
asp_process	createdby	numeric	10				User who created this records
asp_process_para	createdby	numeric	10				User who created this records
asp_ref_list	createdby	numeric	10				User who created this records
asp_tab	createdby	numeric	10				User who created this records
asp_task	createdby	numeric	10				User who created this records
asp_window	createdby	numeric	10				User who created this records
asp_workflow	createdby	numeric	10				User who created this records
ad_tab_customization	custom	varchar	2000				Custom
ad_process_para	daterangeoption	bpchar	1			'D'::bpchar	Options, how the date editor will be displayed.
ad_workflow	duration	numeric	10			0	Normal Duration in Duration Unit
ad_field	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_form	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_ref_list	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_tab	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_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_process_para	fieldlength	numeric	10				Length of the column in the database
ad_tab	hastree	bpchar	1			'N'::bpchar	Window has Tree Graph
ad_field	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_form	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_ref_list	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tab	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tab_customization	isactive	bpchar	1				The record is active in the system
ad_task	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
asp_clientexception	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_clientlevel	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_field	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_form	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_level	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_module	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_process	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_process_para	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_tab	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_task	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_window	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
asp_workflow	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tab	isadvancedtab	bpchar	1			'N'::bpchar	This Tab contains advanced Functionality
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for text fields
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_field	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_process_para	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_window	isdefault	bpchar	1			'N'::bpchar	Default value
ad_workflow	isdefault	bpchar	1			'N'::bpchar	Default value
ad_field	isdefaultfocus	bpchar	1			'N'::bpchar	Default Focus
ad_field	isdisplayed	bpchar	1			'Y'::bpchar	Determines, if this field is displayed
ad_field	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_process_para	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_field	isfieldonly	bpchar	1			'N'::bpchar	Label is not displayed
ad_field	isheading	bpchar	1			'N'::bpchar	Field without Column - Only label is displayed
ad_tab	isinsertrecord	bpchar	1			'Y'::bpchar	The user can insert a new Record
ad_process_para	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_field	isquickentry	bpchar	1			'N'::bpchar	Quick Entry
ad_field	isquickform	bpchar	1			'N'::bpchar	Display in Quick Form
ad_process_para	isrange	bpchar	1			'N'::bpchar	The parameter is a range of values
ad_field	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_tab	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
ad_field	issameline	bpchar	1			'N'::bpchar	Displayed on same line as previous field
ad_process_para	isshownegatebutton	bpchar	1			'N'::bpchar	Show Negate Button for Chosen Multiple editors
ad_tab	issinglerow	bpchar	1			'Y'::bpchar	Default for toggle between Single- and Multi-Row (Grid) Layout
ad_tab	issorttab	bpchar	1			'N'::bpchar	The Tab determines the Order
ad_window	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
ad_tab	istranslationtab	bpchar	1			'N'::bpchar	This Tab contains translation information
ad_workflow	isvalid	bpchar	1			'N'::bpchar	Element is valid
ad_field	name	varchar	60				Alphanumeric identifier of the entity
ad_form	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_ref_list	name	varchar	60				Alphanumeric identifier of the entity
ad_tab	name	varchar	60				Alphanumeric identifier of the entity
ad_task	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
asp_level	name	varchar	60				Alphanumeric identifier of the entity
asp_module	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_process_para	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_tab	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_tab	tablevel	numeric	10				Hierarchical Tab Level (0 = top)
ad_tab	treedisplayedon	bpchar	1			'B'::bpchar	The tree can be displayed on master tab, detail tab or both
ad_field	updated	timestamp	29,6			now()	Date this record was updated
ad_form	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_ref_list	updated	timestamp	29,6			now()	Date this record was updated
ad_tab	updated	timestamp	29,6			now()	Date this record was updated
ad_tab_customization	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_task	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
asp_clientexception	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_clientlevel	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_field	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_form	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_level	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_module	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_process	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_process_para	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_ref_list	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_tab	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_task	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_window	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
asp_workflow	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_field	updatedby	numeric	10				User who updated this records
ad_form	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_ref_list	updatedby	numeric	10				User who updated this records
ad_tab	updatedby	numeric	10				User who updated this records
ad_tab_customization	updatedby	numeric	10				User who updated this records
ad_task	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
asp_clientexception	updatedby	numeric	10				User who updated this records
asp_clientlevel	updatedby	numeric	10				User who updated this records
asp_field	updatedby	numeric	10				User who updated this records
asp_form	updatedby	numeric	10				User who updated this records
asp_level	updatedby	numeric	10				User who updated this records
asp_module	updatedby	numeric	10				User who updated this records
asp_process	updatedby	numeric	10				User who updated this records
asp_process_para	updatedby	numeric	10				User who updated this records
asp_ref_list	updatedby	numeric	10				User who updated this records
asp_tab	updatedby	numeric	10				User who updated this records
asp_task	updatedby	numeric	10				User who updated this records
asp_window	updatedby	numeric	10				User who updated this records
asp_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_ref_list	value	varchar	60				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
asp_level	value	varchar	40				Search key for the record in the format required - must be unique
asp_module	value	varchar	40				Search key for the record in the format required - must be unique
ad_workflow	version	numeric	10			0	Version of the table definition
ad_workflow	waitingtime	numeric	10			0	Workflow Simulation Waiting time
ad_workflow	workflowtype	bpchar	1			'G'::bpchar	Type of Workflow
ad_workflow	workingtime	numeric	10			0	Workflow Simulation Execution Time