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

Table	Column	Type	Size	Nulls	Auto	Default
ad_process	accesslevel	bpchar	1				Access Level required
ad_rule	accesslevel	bpchar	1	√		null	Access Level required
ad_table	accesslevel	bpchar	1				Access Level required
ad_toolbarbutton	action	bpchar	1			'W'::bpchar	Indicates the Action to be performed
ad_toolbarbutton	actionclassname	varchar	255	√		NULL::character varying	The service component name that implements the interface for toolbar actions
ad_toolbarbutton	actionname	varchar	60	√		NULL::character varying	Action name on the toolbar
ad_attribute	ad_attribute_id	numeric	10				System Attribute
ad_attribute_value	ad_attribute_id	numeric	10				System Attribute
ad_attribute	ad_attribute_uu	varchar	36	√		NULL::character varying	AD_Attribute_UU
ad_attribute_value	ad_attribute_value_uu	varchar	36	√		NULL::character varying	AD_Attribute_Value_UU
ad_column	ad_chart_id	numeric	10	√		NULL::numeric	Chart
ad_attribute	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_column	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_element	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_field	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_fieldgroup	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_indexcolumn	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_infocolumn	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_infoprocess	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_inforelated	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_infowindow	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_language	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_message	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_modelvalidator	ad_client_id	numeric	10			0	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_ref_list	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_ref_table	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_reference	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_relationtype	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_role	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_rule	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_searchdefinition	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
ad_statusline	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_statuslineusedin	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_style	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_styleline	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_sysconfig	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tab	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tab_customization	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table_scriptvalidator	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_tableindex	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_toolbarbutton	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_field	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_info	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_info_column	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_info_related	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_proc	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_proc_parameter	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_tab	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_userdef_win	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_val_rule	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_window	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_zoomcondition	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_window	ad_color_id	numeric	10	√		null	Color for backgrounds or indicators
ad_column	ad_column_id	numeric	10				Column in the table
ad_field	ad_column_id	numeric	10	√		null	Column in the table
ad_indexcolumn	ad_column_id	numeric	10	√		null	Column in the table
ad_searchdefinition	ad_column_id	numeric	10	√		null	Column in the table
ad_tab	ad_column_id	numeric	10	√		null	Column in the table
ad_column	ad_column_uu	varchar	36	√		NULL::character varying	AD_Column_UU
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_infowindow	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_ref_table	ad_display	numeric	10				Column that will display
ad_column	ad_element_id	numeric	10	√		null	System Element enables the central maintenance of column description and help.
ad_element	ad_element_id	numeric	10				System Element enables the central maintenance of column description and help.
ad_infocolumn	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_reference	ad_element_id	numeric	10	√		NULL::numeric	System Element enables the central maintenance of column description and help.
ad_element	ad_element_uu	varchar	36	√		NULL::character varying	AD_Element_UU
ad_field	ad_field_id	numeric	10				Field on a database table
ad_userdef_field	ad_field_id	numeric	10				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_fieldgroup	ad_fieldgroup_id	numeric	10				Logical grouping of fields
ad_process_para	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_userdef_field	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_userdef_proc_parameter	ad_fieldgroup_id	numeric	10	√		NULL::numeric	Logical grouping of fields
ad_fieldgroup	ad_fieldgroup_uu	varchar	36	√		NULL::character varying	AD_FieldGroup_UU
ad_field	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_infocolumn	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_userdef_field	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_userdef_info_column	ad_fieldstyle_id	numeric	10	√		NULL::numeric	Field CSS Style
ad_process	ad_form_id	numeric	10	√		null	Special Form
ad_tab	ad_image_id	numeric	10	√		null	Image or Icon
ad_window	ad_image_id	numeric	10	√		null	Image or Icon
ad_indexcolumn	ad_indexcolumn_id	numeric	10				Table Index Column
ad_indexcolumn	ad_indexcolumn_uu	varchar	36	√		NULL::character varying	AD_IndexColumn_UU
ad_infocolumn	ad_infocolumn_id	numeric	10				Info Window Column
ad_infoprocess	ad_infocolumn_id	numeric	10	√		null	Info Window Column
ad_userdef_info_column	ad_infocolumn_id	numeric	10				Info Window Column
ad_infocolumn	ad_infocolumn_uu	varchar	36	√		NULL::character varying	AD_InfoColumn_UU
ad_infoprocess	ad_infoprocess_id	numeric	10				Info Process
ad_infoprocess	ad_infoprocess_uu	varchar	36				AD_InfoProcess_UU
ad_inforelated	ad_inforelated_id	numeric	10				InfoRelated
ad_userdef_info_related	ad_inforelated_id	numeric	10				InfoRelated
ad_inforelated	ad_inforelated_uu	varchar	36	√		NULL::character varying	AD_InfoRelated_UU
ad_infocolumn	ad_infowindow_id	numeric	10				Info and search/select Window
ad_infoprocess	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_inforelated	ad_infowindow_id	numeric	10				Info and search/select Window
ad_infowindow	ad_infowindow_id	numeric	10				Info and search/select Window
ad_ref_table	ad_infowindow_id	numeric	10	√		NULL::numeric	Info and search/select Window
ad_userdef_info	ad_infowindow_id	numeric	10				Info and search/select Window
ad_infowindow	ad_infowindow_uu	varchar	36	√		NULL::character varying	AD_InfoWindow_UU
ad_ref_table	ad_key	numeric	10				Unique identifier of a record
ad_field	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_userdef_field	ad_labelstyle_id	numeric	10	√		NULL::numeric	Label CSS Style
ad_language	ad_language	varchar	6				Language for this entity
ad_userdef_info	ad_language	varchar	6	√		NULL::character varying	Language for this entity
ad_userdef_proc	ad_language	varchar	6	√		NULL::character varying	Language for this entity
ad_userdef_win	ad_language	varchar	6	√		null	Language for this entity
ad_language	ad_language_id	numeric	10				Language ID
ad_language	ad_language_uu	varchar	36	√		NULL::character varying	AD_Language_UU
ad_message	ad_message_id	numeric	10				System Message
ad_statusline	ad_message_id	numeric	10				System Message
ad_tableindex	ad_message_id	numeric	10	√		NULL::numeric	System Message
ad_message	ad_message_uu	varchar	36	√		NULL::character varying	AD_Message_UU
ad_modelvalidator	ad_modelvalidator_id	numeric	10				Model Validator
ad_modelvalidator	ad_modelvalidator_uu	varchar	36	√		NULL::character varying	AD_ModelValidator_UU
ad_attribute	ad_org_id	numeric	10				Organizational entity within client
ad_column	ad_org_id	numeric	10				Organizational entity within client
ad_element	ad_org_id	numeric	10				Organizational entity within client
ad_field	ad_org_id	numeric	10				Organizational entity within client
ad_fieldgroup	ad_org_id	numeric	10				Organizational entity within client
ad_indexcolumn	ad_org_id	numeric	10				Organizational entity within client
ad_infocolumn	ad_org_id	numeric	10				Organizational entity within client
ad_infoprocess	ad_org_id	numeric	10				Organizational entity within client
ad_inforelated	ad_org_id	numeric	10				Organizational entity within client
ad_infowindow	ad_org_id	numeric	10				Organizational entity within client
ad_language	ad_org_id	numeric	10				Organizational entity within client
ad_message	ad_org_id	numeric	10				Organizational entity within client
ad_modelvalidator	ad_org_id	numeric	10			0	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_ref_list	ad_org_id	numeric	10				Organizational entity within client
ad_ref_table	ad_org_id	numeric	10				Organizational entity within client
ad_reference	ad_org_id	numeric	10				Organizational entity within client
ad_relationtype	ad_org_id	numeric	10				Organizational entity within client
ad_role	ad_org_id	numeric	10				Organizational entity within client
ad_rule	ad_org_id	numeric	10				Organizational entity within client
ad_searchdefinition	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
ad_statusline	ad_org_id	numeric	10				Organizational entity within client
ad_statuslineusedin	ad_org_id	numeric	10				Organizational entity within client
ad_style	ad_org_id	numeric	10				Organizational entity within client
ad_styleline	ad_org_id	numeric	10				Organizational entity within client
ad_sysconfig	ad_org_id	numeric	10				Organizational entity within client
ad_tab	ad_org_id	numeric	10				Organizational entity within client
ad_tab_customization	ad_org_id	numeric	10				Organizational entity within client
ad_table	ad_org_id	numeric	10				Organizational entity within client
ad_table_scriptvalidator	ad_org_id	numeric	10				Organizational entity within client
ad_tableindex	ad_org_id	numeric	10				Organizational entity within client
ad_toolbarbutton	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_field	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_info	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_info_column	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_info_related	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_proc	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_proc_parameter	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_tab	ad_org_id	numeric	10				Organizational entity within client
ad_userdef_win	ad_org_id	numeric	10				Organizational entity within client
ad_val_rule	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_window	ad_org_id	numeric	10				Organizational entity within client
ad_zoomcondition	ad_org_id	numeric	10				Organizational entity within client
ad_process	ad_printformat_id	numeric	10	√		null	Data Print Format
ad_language	ad_printpaper_id	numeric	10	√		NULL::numeric	Printer paper definition
ad_column	ad_process_id	numeric	10	√		null	Process or Report
ad_infoprocess	ad_process_id	numeric	10				Process or Report
ad_infowindow	ad_process_id	numeric	10	√		NULL::numeric	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_tab	ad_process_id	numeric	10	√		null	Process or Report
ad_toolbarbutton	ad_process_id	numeric	10	√		NULL::numeric	Process or Report
ad_userdef_proc	ad_process_id	numeric	10				Process or Report
ad_userdef_tab	ad_process_id	numeric	10	√		NULL::numeric	Process or Report
ad_process_para	ad_process_para_id	numeric	10				Process Parameter
ad_userdef_proc_parameter	ad_process_para_id	numeric	10				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_id	numeric	10				Reference List based on Table
ad_ref_list	ad_ref_list_uu	varchar	36	√		NULL::character varying	AD_Ref_List_UU
ad_ref_table	ad_ref_table_uu	varchar	36	√		NULL::character varying	AD_Ref_Table_UU
ad_attribute	ad_reference_id	numeric	10				System Reference and Validation
ad_column	ad_reference_id	numeric	10				System Reference and Validation
ad_field	ad_reference_id	numeric	10	√		null	System Reference and Validation
ad_infocolumn	ad_reference_id	numeric	10				System Reference and Validation
ad_process_para	ad_reference_id	numeric	10				System Reference and Validation
ad_ref_list	ad_reference_id	numeric	10				System Reference and Validation
ad_ref_table	ad_reference_id	numeric	10				System Reference and Validation
ad_reference	ad_reference_id	numeric	10				System Reference and Validation
ad_userdef_field	ad_reference_id	numeric	10	√		NULL::numeric	System Reference and Validation
ad_userdef_info_column	ad_reference_id	numeric	10	√		NULL::numeric	System Reference and Validation
ad_userdef_proc_parameter	ad_reference_id	numeric	10	√		NULL::numeric	System Reference and Validation
ad_relationtype	ad_reference_source_id	numeric	10	√		NULL::numeric	Source Reference
ad_relationtype	ad_reference_target_id	numeric	10	√		NULL::numeric	Target Reference
ad_reference	ad_reference_uu	varchar	36	√		NULL::character varying	AD_Reference_UU
ad_attribute	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_column	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_field	ad_reference_value_id	numeric	10	√		null	Required to specify, if data type is Table or List
ad_infocolumn	ad_reference_value_id	numeric	10	√		NULL::numeric	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_userdef_field	ad_reference_value_id	numeric	10	√		NULL::numeric	Required to specify, if data type is Table or List
ad_userdef_info_column	ad_reference_value_id	numeric	10	√		NULL::numeric	Required to specify, if data type is Table or List
ad_userdef_proc_parameter	ad_reference_value_id	numeric	10	√		NULL::numeric	Required to specify, if data type is Table or List
ad_relationtype	ad_relationtype_id	numeric	10				Relation Type
ad_relationtype	ad_relationtype_uu	varchar	36	√		NULL::character varying	AD_RelationType_UU
ad_process	ad_reportview_id	numeric	10	√		null	View used to generate this report
ad_role	ad_role_id	numeric	10				Responsibility Role
ad_userdef_info	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
ad_userdef_proc	ad_role_id	numeric	10	√		NULL::numeric	Responsibility Role
ad_userdef_win	ad_role_id	numeric	10	√		null	Responsibility Role
ad_role	ad_role_uu	varchar	36	√		NULL::character varying	AD_Role_UU
ad_rule	ad_rule_id	numeric	10				Rule
ad_table_scriptvalidator	ad_rule_id	numeric	10				Rule
ad_rule	ad_rule_uu	varchar	36	√		NULL::character varying	AD_Rule_UU
ad_searchdefinition	ad_searchdefinition_id	numeric	10				Search Definition
ad_searchdefinition	ad_searchdefinition_uu	varchar	36	√		NULL::character varying	AD_SearchDefinition_UU
ad_statusline	ad_statusline_id	numeric	10				Status Line
ad_statuslineusedin	ad_statusline_id	numeric	10				Status Line
ad_statusline	ad_statusline_uu	varchar	36	√		NULL::character varying	AD_StatusLine_UU
ad_statuslineusedin	ad_statuslineusedin_id	numeric	10				AD_StatusLineUsedIn
ad_statuslineusedin	ad_statuslineusedin_uu	varchar	36	√		NULL::character varying	AD_StatusLineUsedIn_UU
ad_style	ad_style_id	numeric	10				CSS style for field and label
ad_styleline	ad_style_id	numeric	10				CSS style for field and label
ad_style	ad_style_uu	varchar	36				CSS Style for field and label
ad_styleline	ad_styleline_id	numeric	10				CSS Style Line
ad_styleline	ad_styleline_uu	varchar	36				CSS Style Line
ad_sysconfig	ad_sysconfig_id	numeric	10				System Configurator
ad_sysconfig	ad_sysconfig_uu	varchar	36	√		NULL::character varying	AD_SysConfig_UU
ad_tab_customization	ad_tab_customization_id	numeric	10			NULL::numeric	Tab Customization
ad_tab_customization	ad_tab_customization_uu	varchar	36	√		NULL::character varying	AD_Tab_Customization_UU
ad_field	ad_tab_id	numeric	10				Tab within a Window
ad_statuslineusedin	ad_tab_id	numeric	10	√		NULL::numeric	Tab within a Window
ad_tab	ad_tab_id	numeric	10				Tab within a Window
ad_tab_customization	ad_tab_id	numeric	10	√		NULL::numeric	Tab within a Window
ad_toolbarbutton	ad_tab_id	numeric	10	√		NULL::numeric	Tab within a Window
ad_userdef_tab	ad_tab_id	numeric	10				Tab within a Window
ad_tab	ad_tab_uu	varchar	36	√		NULL::character varying	AD_Tab_UU
ad_attribute	ad_table_id	numeric	10				Database Table information
ad_column	ad_table_id	numeric	10				Database Table information
ad_infowindow	ad_table_id	numeric	10				Database Table information
ad_ref_table	ad_table_id	numeric	10				Database Table information
ad_searchdefinition	ad_table_id	numeric	10				Database Table information
ad_statuslineusedin	ad_table_id	numeric	10	√		NULL::numeric	Database Table information
ad_tab	ad_table_id	numeric	10				Database Table information
ad_table	ad_table_id	numeric	10				Database Table information
ad_table_scriptvalidator	ad_table_id	numeric	10				Database Table information
ad_tableindex	ad_table_id	numeric	10				Database Table information
ad_viewcomponent	ad_table_id	numeric	10				Database Table information
ad_zoomcondition	ad_table_id	numeric	10				Database Table information
ad_table_scriptvalidator	ad_table_scriptvalidator_id	numeric	10				Table Script Validator
ad_table_scriptvalidator	ad_table_scriptvalidator_uu	varchar	36	√		NULL::character varying	AD_Table_ScriptValidator_UU
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
ad_indexcolumn	ad_tableindex_id	numeric	10				Table Index
ad_tableindex	ad_tableindex_id	numeric	10				Table Index
ad_tableindex	ad_tableindex_uu	varchar	36	√		NULL::character varying	AD_TableIndex_UU
ad_tab	ad_tabtype	varchar	40	√		NULL::character varying	Defines Tab Type
ad_toolbarbutton	ad_toolbarbutton_id	numeric	10				ToolBar Button
ad_toolbarbutton	ad_toolbarbutton_uu	varchar	36	√		NULL::character varying	AD_ToolBarButton_UU
ad_role	ad_tree_menu_id	numeric	10	√		null	Tree of the menu
ad_role	ad_tree_org_id	numeric	10	√		null	Trees are used for (financial) reporting and security access (via role)
ad_tab_customization	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
ad_userdef_info	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_userdef_proc	ad_user_id	numeric	10	√		NULL::numeric	User within the system - Internal or Business Partner Contact
ad_userdef_win	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_userdef_field	ad_userdef_field_id	numeric	10				User defined Field
ad_userdef_field	ad_userdef_field_uu	varchar	36	√		NULL::character varying	AD_UserDef_Field_UU
ad_userdef_info_column	ad_userdef_info_column_id	numeric	10				User defined Info Column
ad_userdef_info_column	ad_userdef_info_column_uu	varchar	36	√		NULL::character varying	AD_UserDef_Info_Column_UU
ad_userdef_info	ad_userdef_info_id	numeric	10				User defined Info Window
ad_userdef_info_column	ad_userdef_info_id	numeric	10				User defined Info Window
ad_userdef_info_related	ad_userdef_info_id	numeric	10				User defined Info Window
ad_userdef_info_related	ad_userdef_info_related_id	numeric	10				User defined Info Related
ad_userdef_info_related	ad_userdef_info_related_uu	varchar	36	√		NULL::character varying	AD_UserDef_Info_Related_UU
ad_userdef_info	ad_userdef_info_uu	varchar	36	√		NULL::character varying	AD_UserDef_Info_UU
ad_userdef_proc	ad_userdef_proc_id	numeric	10				Primary Key : User defined Process
ad_userdef_proc_parameter	ad_userdef_proc_id	numeric	10				Primary Key : User defined Process
ad_userdef_proc_parameter	ad_userdef_proc_parameter_id	numeric	10				Primary Key : User defined Process Parameter
ad_userdef_proc_parameter	ad_userdef_proc_parameter_uu	varchar	36	√		NULL::character varying	AD_UserDef_Proc_Parameter_UU
ad_userdef_proc	ad_userdef_proc_uu	varchar	36	√		NULL::character varying	AD_UserDef_Proc_UU
ad_userdef_field	ad_userdef_tab_id	numeric	10				User defined Tab
ad_userdef_tab	ad_userdef_tab_id	numeric	10				User defined Tab
ad_userdef_tab	ad_userdef_tab_uu	varchar	36	√		NULL::character varying	AD_UserDef_Tab_UU
ad_userdef_tab	ad_userdef_win_id	numeric	10				User defined Window
ad_userdef_win	ad_userdef_win_id	numeric	10				User defined Window
ad_userdef_win	ad_userdef_win_uu	varchar	36	√		NULL::character varying	AD_UserDef_Win_UU
ad_attribute	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_column	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_field	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_infocolumn	ad_val_rule_id	numeric	10	√		NULL::numeric	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_userdef_field	ad_val_rule_id	numeric	10	√		NULL::numeric	Dynamic Validation Rule
ad_userdef_info_column	ad_val_rule_id	numeric	10	√		NULL::numeric	Dynamic Validation Rule
ad_userdef_proc_parameter	ad_val_rule_id	numeric	10	√		NULL::numeric	Dynamic Validation Rule
ad_val_rule	ad_val_rule_id	numeric	10				Dynamic Validation Rule
ad_column	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_field	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_userdef_field	ad_val_rule_lookup_id	numeric	10	√		NULL::numeric	Override Dynamic Validation Rule for Lookup Window
ad_val_rule	ad_val_rule_uu	varchar	36	√		NULL::character varying	AD_Val_Rule_UU
ad_viewcolumn	ad_viewcolumn_id	numeric	10				Database View Column
ad_viewcolumn	ad_viewcolumn_uu	varchar	36	√		NULL::character varying	AD_ViewColumn_UU
ad_viewcolumn	ad_viewcomponent_id	numeric	10				Database View Component
ad_viewcomponent	ad_viewcomponent_id	numeric	10				Database View Component
ad_viewcomponent	ad_viewcomponent_uu	varchar	36	√		NULL::character varying	AD_ViewComponent_UU
ad_ref_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_searchdefinition	ad_window_id	numeric	10				Data entry or display window
ad_statuslineusedin	ad_window_id	numeric	10	√		NULL::numeric	Data entry or display window
ad_tab	ad_window_id	numeric	10				Data entry or display window
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
ad_userdef_win	ad_window_id	numeric	10				Data entry or display window
ad_window	ad_window_id	numeric	10				Data entry or display window
ad_zoomcondition	ad_window_id	numeric	10	√		NULL::numeric	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
ad_zoomcondition	ad_zoomcondition_id	numeric	10				Zoom condition
ad_zoomcondition	ad_zoomcondition_uu	varchar	36	√		NULL::character varying	AD_ZoomCondition_UU
ad_role	allow_info_account	bpchar	1			'Y'::bpchar	Allow Info Account
ad_role	allow_info_asset	bpchar	1			'Y'::bpchar	Allow Info Asset
ad_role	allow_info_bpartner	bpchar	1			'Y'::bpchar	Allow Info BPartner
ad_role	allow_info_cashjournal	bpchar	1			'N'::bpchar	Allow Info CashJournal
ad_role	allow_info_crp	bpchar	1			'N'::bpchar	Allow Info CRP
ad_role	allow_info_inout	bpchar	1			'Y'::bpchar	Allow Info InOut
ad_role	allow_info_invoice	bpchar	1			'Y'::bpchar	Allow Info Invoice
ad_role	allow_info_mrp	bpchar	1			'N'::bpchar	Allow Info MRP
ad_role	allow_info_order	bpchar	1			'Y'::bpchar	Allow Info Order
ad_role	allow_info_payment	bpchar	1			'Y'::bpchar	Allow Info Payment
ad_role	allow_info_product	bpchar	1			'Y'::bpchar	Allow Info Product
ad_role	allow_info_resource	bpchar	1			'Y'::bpchar	Allow Info Resource
ad_role	allow_info_schedule	bpchar	1			'Y'::bpchar	Allow Info Schedule
ad_process	allowmultipleexecution	bpchar	1	√		'P'::bpchar	Allow or disallow executing a process/report multiple times.
ad_role	amtapproval	numeric	0	√		0	The approval amount limit for this role
ad_role	amtapprovalaccum	numeric	0	√		null	The approval amount limit for this role accumulated on a period
ad_role	c_currency_id	numeric	10	√		null	The Currency for this record
ad_attribute	callout	varchar	60	√		null	Fully qualified class names and method - separated by semicolons
ad_column	callout	varchar	255	√		null	Fully qualified class names and method - separated by semicolons
ad_process	classname	varchar	255	√		null	Java Classname
ad_toolbarbutton	classname	varchar	255	√		null	Java Classname
ad_val_rule	code	varchar	2000	√		null	Validation Code
ad_column	columnname	varchar	30				Name of the column in the database
ad_element	columnname	varchar	30				Name of the column in the database
ad_infocolumn	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_field	columnspan	numeric	10	√		(1)::numeric	Number of column for a box of field
ad_userdef_field	columnspan	numeric	10	√		NULL::numeric	Number of column for a box of field
ad_column	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_field	columnsql	varchar	4000	√		null	Virtual Column (r/o)
ad_indexcolumn	columnsql	varchar	255	√		NULL::character varying	Virtual Column (r/o)
ad_viewcolumn	columnsql	varchar	2000	√		null	Virtual Column (r/o)
ad_tab	commitwarning	varchar	2000	√		null	Warning displayed when saving
ad_toolbarbutton	componentname	varchar	255				Component Name
ad_sysconfig	configurationlevel	bpchar	1	√		'S'::bpchar	Configuration Level for this parameter
ad_role	confirmqueryrecords	numeric	10			0	Require Confirmation if more records will be returned by the query (If not defined 500)
ad_role	connectionprofile	bpchar	1	√		null	How a Java Client connects to the server(s)
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_language	countrycode	bpchar	2	√		null	Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
ad_attribute	created	timestamp	29,6			now()	Date this record was created
ad_column	created	timestamp	29,6			now()	Date this record was created
ad_element	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_field	created	timestamp	29,6			now()	Date this record was created
ad_fieldgroup	created	timestamp	29,6			now()	Date this record was created
ad_indexcolumn	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_infocolumn	created	timestamp	29,6			now()	Date this record was created
ad_infoprocess	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_inforelated	created	timestamp	29,6				Date this record was created
ad_infowindow	created	timestamp	29,6			now()	Date this record was created
ad_language	created	timestamp	29,6			now()	Date this record was created
ad_message	created	timestamp	29,6			now()	Date this record was created
ad_modelvalidator	created	timestamp	29,6			statement_timestamp()	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_ref_table	created	timestamp	29,6			now()	Date this record was created
ad_reference	created	timestamp	29,6			now()	Date this record was created
ad_relationtype	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_role	created	timestamp	29,6			now()	Date this record was created
ad_rule	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_searchdefinition	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_statusline	created	timestamp	29,6				Date this record was created
ad_statuslineusedin	created	timestamp	29,6				Date this record was created
ad_style	created	timestamp	29,6	√		statement_timestamp()	Date this record was created
ad_styleline	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_sysconfig	created	timestamp	29,6			statement_timestamp()	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_table	created	timestamp	29,6			now()	Date this record was created
ad_table_scriptvalidator	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_tableindex	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_toolbarbutton	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_userdef_field	created	timestamp	29,6			now()	Date this record was created
ad_userdef_info	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_userdef_info_column	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_userdef_info_related	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_userdef_proc	created	timestamp	29,6				Date this record was created
ad_userdef_proc_parameter	created	timestamp	29,6				Date this record was created
ad_userdef_tab	created	timestamp	29,6			now()	Date this record was created
ad_userdef_win	created	timestamp	29,6			now()	Date this record was created
ad_val_rule	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_window	created	timestamp	29,6			now()	Date this record was created
ad_zoomcondition	created	timestamp	29,6			statement_timestamp()	Date this record was created
ad_attribute	createdby	numeric	10				User who created this records
ad_column	createdby	numeric	10				User who created this records
ad_element	createdby	numeric	10				User who created this records
ad_field	createdby	numeric	10				User who created this records
ad_fieldgroup	createdby	numeric	10				User who created this records
ad_indexcolumn	createdby	numeric	10				User who created this records
ad_infocolumn	createdby	numeric	10				User who created this records
ad_infoprocess	createdby	numeric	10				User who created this records
ad_inforelated	createdby	numeric	10				User who created this records
ad_infowindow	createdby	numeric	10				User who created this records
ad_language	createdby	numeric	10				User who created this records
ad_message	createdby	numeric	10				User who created this records
ad_modelvalidator	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_ref_table	createdby	numeric	10				User who created this records
ad_reference	createdby	numeric	10				User who created this records
ad_relationtype	createdby	numeric	10				User who created this records
ad_role	createdby	numeric	10				User who created this records
ad_rule	createdby	numeric	10				User who created this records
ad_searchdefinition	createdby	numeric	10	√		null	User who created this records
ad_statusline	createdby	numeric	10				User who created this records
ad_statuslineusedin	createdby	numeric	10				User who created this records
ad_style	createdby	numeric	10				User who created this records
ad_styleline	createdby	numeric	10				User who created this records
ad_sysconfig	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_table	createdby	numeric	10				User who created this records
ad_table_scriptvalidator	createdby	numeric	10				User who created this records
ad_tableindex	createdby	numeric	10				User who created this records
ad_toolbarbutton	createdby	numeric	10				User who created this records
ad_userdef_field	createdby	numeric	10				User who created this records
ad_userdef_info	createdby	numeric	10				User who created this records
ad_userdef_info_column	createdby	numeric	10				User who created this records
ad_userdef_info_related	createdby	numeric	10				User who created this records
ad_userdef_proc	createdby	numeric	10				User who created this records
ad_userdef_proc_parameter	createdby	numeric	10				User who created this records
ad_userdef_tab	createdby	numeric	10				User who created this records
ad_userdef_win	createdby	numeric	10				User who created this records
ad_val_rule	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_window	createdby	numeric	10				User who created this records
ad_zoomcondition	createdby	numeric	10				User who created this records
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_tab_customization	custom	varchar	2000				Custom
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
ad_searchdefinition	datatype	varchar	1				Type of data
ad_language	datepattern	varchar	20	√		null	Java Date Pattern
ad_role	daysapprovalaccum	numeric	10	√		null	The days approval indicates the days to take into account to verify the accumulated approval amount.
ad_viewcolumn	dbdatatype	bpchar	1	√		NULL::bpchar	Database Data Type
ad_attribute	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_column	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_field	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_infocolumn	defaultvalue	varchar	2000	√		NULL::character varying	Default value hierarchy, separated by ;
ad_process_para	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_userdef_field	defaultvalue	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_userdef_info_column	defaultvalue	varchar	2000	√		NULL::character varying	Default value hierarchy, separated by ;
ad_userdef_proc_parameter	defaultvalue	varchar	2000	√		NULL::character varying	Default value hierarchy, separated by ;
ad_process_para	defaultvalue2	varchar	2000	√		null	Default value hierarchy, separated by ;
ad_userdef_proc_parameter	defaultvalue2	varchar	2000	√		NULL::character varying	Default value hierarchy, separated by ;
ad_attribute	description	varchar	255	√		null	Optional short description of the record
ad_column	description	varchar	255	√		null	Optional short description of the record
ad_element	description	varchar	255	√		null	Optional short description of the record
ad_field	description	varchar	255	√		null	Optional short description of the record
ad_infocolumn	description	varchar	255	√		null	Optional short description of the record
ad_inforelated	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_infowindow	description	varchar	255	√		null	Optional short description of the record
ad_modelvalidator	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_reference	description	varchar	255	√		null	Optional short description of the record
ad_relationtype	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_role	description	varchar	255	√		null	Optional short description of the record
ad_rule	description	varchar	255	√		null	Optional short description of the record
ad_searchdefinition	description	varchar	255	√		null	Optional short description of the record
ad_style	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_sysconfig	description	varchar	255	√		null	Optional short description of the record
ad_tab	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
ad_tableindex	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_field	description	varchar	255	√		null	Optional short description of the record
ad_userdef_info	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_info_column	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_info_related	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_proc	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_proc_parameter	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_userdef_tab	description	varchar	255	√		null	Optional short description of the record
ad_userdef_win	description	varchar	255	√		null	Optional short description of the record
ad_val_rule	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_window	description	varchar	255	√		null	Optional short description of the record
ad_zoomcondition	description	varchar	255	√		NULL::character varying	Optional short description of the record
ad_attribute	displaylength	numeric	10	√		null	Length of the display in characters
ad_field	displaylength	numeric	10	√		null	Length of the display in characters
ad_userdef_field	displaylength	numeric	10			0	Length of the display in characters
ad_attribute	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_field	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_infocolumn	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_infoprocess	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_inforelated	displaylogic	varchar	2000	√		NULL::character varying	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_styleline	displaylogic	varchar	2000	√		NULL::character varying	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_toolbarbutton	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_field	displaylogic	varchar	2000	√		null	If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_info_column	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_info_related	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_proc_parameter	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_userdef_tab	displaylogic	varchar	2000	√		NULL::character varying	If the Field is displayed, the result determines if the field is actually displayed
ad_column	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_element	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_field	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_fieldgroup	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_indexcolumn	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_infocolumn	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_infoprocess	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_inforelated	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_infowindow	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_message	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_modelvalidator	entitytype	varchar	40				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_ref_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_reference	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_relationtype	entitytype	varchar	40	√		'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_rule	entitytype	varchar	40	√		'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_searchdefinition	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_statusline	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_statuslineusedin	entitytype	varchar	40	√		'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_style	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_styleline	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_sysconfig	entitytype	varchar	40			'U'::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_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_tableindex	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_toolbarbutton	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_val_rule	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_window	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_zoomcondition	entitytype	varchar	40			'U'::character varying	Dictionary Entity Type; Determines ownership and synchronization
ad_table_scriptvalidator	eventmodelvalidator	varchar	4				Event Model Validator
ad_rule	eventtype	bpchar	1	√		null	Type of Event
ad_process	executiontype	bpchar	1	√		NULL::bpchar	Execution Type defines whether the report/process will always run in background or foreground.
ad_fieldgroup	fieldgrouptype	bpchar	1	√		null	Field Group Type
ad_attribute	fieldlength	numeric	10	√		null	Length of the column in the database
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	fkconstraintname	varchar	30	√		NULL::character varying	Constraint Name
ad_column	fkconstrainttype	bpchar	1	√		'N'::bpchar	Constraint Type
ad_column	formatpattern	varchar	22	√		null	The pattern used to format a number or date.
ad_infowindow	fromclause	varchar	2000				SQL FROM clause
ad_viewcomponent	fromclause	varchar	2000			NULL::character varying	SQL FROM clause
ad_tab	hastree	bpchar	1			'N'::bpchar	Window has Tree Graph
ad_attribute	help	varchar	2000	√		null	Comment or Hint
ad_column	help	varchar	2000	√		null	Comment or Hint
ad_element	help	varchar	2000	√		null	Comment or Hint
ad_field	help	varchar	2000	√		null	Comment or Hint
ad_infocolumn	help	varchar	2000	√		null	Comment or Hint
ad_inforelated	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_infowindow	help	varchar	2000	√		null	Comment or Hint
ad_modelvalidator	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_reference	help	varchar	2000	√		null	Comment or Hint
ad_rule	help	varchar	2000	√		null	Comment or Hint
ad_tab	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
ad_tableindex	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_field	help	varchar	2000	√		null	Comment or Hint
ad_userdef_info	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_info_column	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_info_related	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_proc	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_proc_parameter	help	varchar	2000	√		NULL::character varying	Comment or Hint
ad_userdef_tab	help	varchar	2000	√		null	Comment or Hint
ad_userdef_win	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_window	help	varchar	2000	√		null	Comment or Hint
ad_infoprocess	imageurl	varchar	120	√		NULL::character varying	URL of image
ad_infowindow	imageurl	varchar	120	√		NULL::character varying	URL of image
ad_userdef_info	imageurl	varchar	120	√		NULL::character varying	URL of image
ad_tab	importfields	bpchar	1	√		null	Create Fields from Table Columns
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
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_column	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_field	infofactoryclass	varchar	255	√		null	Fully qualified class name that implements the InfoFactory interface
ad_styleline	inlinestyle	varchar	2000				CSS Inline Style
ad_infocolumn	inputfieldvalidation	varchar	2000	√		NULL::character varying	Input field validaton query
ad_userdef_info_column	inputfieldvalidation	varchar	2000	√		NULL::character varying	Input field validaton query
ad_role	isaccessadvanced	bpchar	1	√		'N'::bpchar	Access Advanced
ad_role	isaccessallorgs	bpchar	1			'N'::bpchar	Access all Organizations (no org access control) of the client
ad_attribute	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_element	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_field	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_fieldgroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_indexcolumn	isactive	bpchar	1				The record is active in the system
ad_infocolumn	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_infoprocess	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_inforelated	isactive	bpchar	1				The record is active in the system
ad_infowindow	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_language	isactive	bpchar	1			'N'::bpchar	The record is active in the system
ad_message	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_modelvalidator	isactive	bpchar	1				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_ref_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_reference	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_relationtype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_role	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_rule	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_searchdefinition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_statusline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_statuslineusedin	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_style	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_styleline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_sysconfig	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_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table_scriptvalidator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_tableindex	isactive	bpchar	1				The record is active in the system
ad_toolbarbutton	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_field	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_info	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_info_column	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_info_related	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_proc	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_proc_parameter	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_tab	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_userdef_win	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_val_rule	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_window	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_zoomcondition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_toolbarbutton	isaddseparator	bpchar	1			'N'::bpchar	Add Separator
ad_toolbarbutton	isadvancedbutton	bpchar	1			'N'::bpchar	This Button contains advanced Functionality
ad_field	isadvancedfield	bpchar	1	√		'N'::bpchar	Advanced Field
ad_tab	isadvancedtab	bpchar	1			'N'::bpchar	This Tab contains advanced Functionality
ad_tab	isallowadvancedlookup	bpchar	1	√		'Y'::bpchar	Allow Advanced Lookup
ad_userdef_tab	isallowadvancedlookup	bpchar	1	√		NULL::bpchar	Allow Advanced Lookup
ad_column	isallowcopy	bpchar	1			'Y'::bpchar	Determine if a column must be copied when pushing the button to copy record
ad_field	isallowcopy	bpchar	1	√		NULL::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_field	isalwaysupdateable	bpchar	1	√		NULL::bpchar	The column is always updateable, even if the record is not active or processed
ad_userdef_field	isalwaysupdateable	bpchar	1	√		NULL::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_infocolumn	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
ad_process_para	isautocomplete	bpchar	1			'N'::bpchar	Automatic completion for textfields
ad_userdef_field	isautocomplete	bpchar	1	√		NULL::bpchar	Automatic completion for textfields
ad_userdef_info_column	isautocomplete	bpchar	1	√		NULL::bpchar	Automatic completion for textfields
ad_tab_customization	isautohideemptycolumn	bpchar	1	√		NULL::bpchar	Auto Hide Empty Column
ad_language	isbaselanguage	bpchar	1			'N'::bpchar	The system information is maintained in this language
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_role	iscanapproveowndoc	bpchar	1			'Y'::bpchar	Users with this role can approve their own documents
ad_role	iscanexport	bpchar	1			'Y'::bpchar	Users with this role can export data
ad_role	iscanreport	bpchar	1			'Y'::bpchar	Users with this role can create reports
ad_field	iscentrallymaintained	bpchar	1			'Y'::bpchar	Information maintained in System Element table
ad_infocolumn	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_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
ad_role	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
ad_fieldgroup	iscollapsedbydefault	bpchar	1	√		'N'::bpchar	Flag to set the initial state of collapsible field group.
ad_tableindex	iscreateconstraint	bpchar	1			'N'::bpchar	Create Constraint
ad_toolbarbutton	iscustomization	bpchar	1			'N'::bpchar	The change is a customization of the data dictionary and can be applied after Migration
ad_language	isdecimalpoint	bpchar	1	√		null	The number notation has a decimal point (no decimal comma)
ad_infowindow	isdefault	bpchar	1			'N'::bpchar	Default value
ad_searchdefinition	isdefault	bpchar	1			'N'::bpchar	Default value
ad_userdef_win	isdefault	bpchar	1			'N'::bpchar	Default value
ad_window	isdefault	bpchar	1			'N'::bpchar	Default value
ad_field	isdefaultfocus	bpchar	1			'N'::bpchar	Default Focus
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
ad_relationtype	isdirected	bpchar	1			'N'::bpchar	Tells whether one "sees" the other end of the relation from each end or just from the source
ad_process	isdirectprint	bpchar	1	√		'N'::bpchar	Print without dialog
ad_role	isdiscountallowedontotal	bpchar	1			'N'::bpchar	IsDiscountAllowedOnTotal
ad_role	isdiscountuptolimitprice	bpchar	1			'N'::bpchar	IsDiscountUptoLimitPrice
ad_field	isdisplayed	bpchar	1			'Y'::bpchar	Determines, if this field is displayed
ad_infocolumn	isdisplayed	bpchar	1			'Y'::bpchar	Determines, if this field is displayed
ad_userdef_field	isdisplayed	bpchar	1	√		null	Determines, if this field is displayed
ad_userdef_info_column	isdisplayed	bpchar	1	√		NULL::bpchar	Determines, if this field is displayed
ad_userdef_proc_parameter	isdisplayed	bpchar	1	√		null	Determines, if this field is displayed
ad_field	isdisplayedgrid	bpchar	1	√		'Y'::bpchar	Show in Grid
ad_tab_customization	isdisplayedgrid	bpchar	1	√		NULL::bpchar	Show in Grid
ad_userdef_field	isdisplayedgrid	bpchar	1	√		NULL::bpchar	Show in Grid
ad_infowindow	isdistinct	bpchar	1			'N'::bpchar	Select Distinct
ad_attribute	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
ad_column	isencrypted	bpchar	1			'N'::bpchar	Display or Storage is encrypted
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_attribute	isfieldonly	bpchar	1			'N'::bpchar	Label is not displayed
ad_field	isfieldonly	bpchar	1			'N'::bpchar	Label is not displayed
ad_attribute	isheading	bpchar	1			'N'::bpchar	Field without Column - Only label is displayed
ad_field	isheading	bpchar	1			'N'::bpchar	Field without Column - Only label is displayed
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_infocolumn	isidentifier	bpchar	1			'N'::bpchar	This column is part of the record identifier
ad_tab	isinfotab	bpchar	1	√		'N'::bpchar	This Tab contains accounting information
ad_tab	isinsertrecord	bpchar	1			'Y'::bpchar	The user can insert a new Record
ad_column	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_infocolumn	iskey	bpchar	1	√		NULL::bpchar	This column is the key in this table
ad_tableindex	iskey	bpchar	1			'N'::bpchar	This column is the key in this table
ad_infowindow	isloadpagenum	bpchar	1	√		'Y'::bpchar	When load data for info window, also load number of paging
ad_language	isloginlocale	bpchar	1	√		'N'::bpchar	Login Locale
ad_tab	islookuponlyselection	bpchar	1	√		'N'::bpchar	When defined to true Lookup panel will display only selection columns. Default to false.
ad_userdef_tab	islookuponlyselection	bpchar	1	√		NULL::bpchar	When defined to true Lookup panel will display only selection columns. Default to false.
ad_attribute	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_column	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
ad_field	ismandatory	bpchar	1	√		null	Data entry is required in this column
ad_infocolumn	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_userdef_field	ismandatory	bpchar	1	√		NULL::bpchar	Data entry is required in this column
ad_userdef_info_column	ismandatory	bpchar	1	√		NULL::bpchar	Data entry is required in this column
ad_userdef_proc_parameter	ismandatory	bpchar	1	√		NULL::bpchar	Data entry is required in this column
ad_role	ismanual	bpchar	1			'Y'::bpchar	This is a manual process
ad_role	ismasterrole	bpchar	1			'N'::bpchar	A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
ad_role	ismenuautoexpand	bpchar	1			'N'::bpchar	If ticked, the menu is automatically expanded
ad_userdef_tab	ismultirowonly	bpchar	1			'N'::bpchar	This applies to Multi-Row view only
ad_reference	isorderbyvalue	bpchar	1	√		'N'::bpchar	Order list using the value column instead of the name 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_role	ispersonalaccess	bpchar	1			'N'::bpchar	Allow access to all personal records
ad_role	ispersonallock	bpchar	1			'N'::bpchar	Allow users with role to lock access to personal records
ad_infocolumn	isquerycriteria	bpchar	1			'N'::bpchar	The column is also used as a query criteria
ad_userdef_info_column	isquerycriteria	bpchar	1	√		NULL::bpchar	The column is also used as a query criteria
ad_field	isquickentry	bpchar	1			'N'::bpchar	Quick Entry
ad_field	isquickform	bpchar	1			'N'::bpchar	Display in Quick Form
ad_tab_customization	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_userdef_proc_parameter	isrange	bpchar	1	√		NULL::bpchar	The parameter is a range of values
ad_attribute	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_field	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_infocolumn	isreadonly	bpchar	1			'Y'::bpchar	Field is read only
ad_tab	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_userdef_field	isreadonly	bpchar	1	√		null	Field is read only
ad_userdef_info_column	isreadonly	bpchar	1	√		NULL::bpchar	Field is read only
ad_userdef_tab	isreadonly	bpchar	1	√		null	Field is read only
ad_userdef_win	isreadonly	bpchar	1			'N'::bpchar	Field is read only
ad_process	isreport	bpchar	1			'Y'::bpchar	Indicates a Report record
ad_attribute	issameline	bpchar	1			'N'::bpchar	Displayed on same line as previous field
ad_field	issameline	bpchar	1			'N'::bpchar	Displayed on same line as previous field
ad_userdef_field	issameline	bpchar	1	√		null	Displayed on same line as previous field
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_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_role	isshowacct	bpchar	1			'Y'::bpchar	Users with this role can see accounting information
ad_infowindow	isshowindashboard	bpchar	1			'Y'::bpchar	Show the dashlet in the dashboard
ad_userdef_info	isshowindashboard	bpchar	1	√		NULL::bpchar	Show the dashlet in the dashboard
ad_toolbarbutton	isshowmore	bpchar	1	√		'N'::bpchar	Group in show more
ad_tab	issinglerow	bpchar	1			'Y'::bpchar	Default for toggle between Single- and Multi-Row (Grid) Layout
ad_userdef_tab	issinglerow	bpchar	1	√		null	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_statuslineusedin	isstatusline	bpchar	1			'Y'::bpchar	Defines if this record refers to a status line or to a help widget
ad_column	issyncdatabase	bpchar	1	√		'N'::bpchar	Change database table definition when changing dictionary definition
ad_language	issystemlanguage	bpchar	1			'N'::bpchar	The screens, etc. are maintained in this Language
ad_column	istoolbarbutton	bpchar	1			'Y'::bpchar	Show the button on the toolbar, the window, or both
ad_field	istoolbarbutton	bpchar	1	√		null	Show the button on the toolbar, the window, or both
ad_userdef_field	istoolbarbutton	bpchar	1	√		null	Show the button on the toolbar, the window, or both
ad_column	istranslated	bpchar	1			'N'::bpchar	This column is translated
ad_tab	istranslationtab	bpchar	1			'N'::bpchar	This Tab contains translation information
ad_viewcomponent	isunionall	bpchar	1			'N'::bpchar	The component view is UNION ALL
ad_tableindex	isunique	bpchar	1			'N'::bpchar	Unique
ad_attribute	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
ad_column	isupdateable	bpchar	1			'Y'::bpchar	Determines, if the field can be updated
ad_field	isupdateable	bpchar	1	√		NULL::bpchar	Determines, if the field can be updated
ad_userdef_field	isupdateable	bpchar	1	√		null	Determines, if the field can be updated
ad_userdef_proc	isuserupdateable	bpchar	1	√		NULL::bpchar	The field can be updated by the user
ad_userdef_win	isuserupdateable	bpchar	1			'Y'::bpchar	The field can be updated by the user
ad_role	isuseuserorgaccess	bpchar	1			'N'::bpchar	Use Org Access defined by user instead of Role Org Access
ad_infowindow	isvalid	bpchar	1			'N'::bpchar	Element is valid
ad_ref_table	isvaluedisplayed	bpchar	1			'N'::bpchar	Displays Value column with the Display column
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
ad_process	jasperreport	varchar	255	√		null	Jasper Report
ad_toolbarbutton	keystroke_keycode	numeric	10	√		NULL::numeric	KeyCode for shortcuts
ad_toolbarbutton	keystroke_modifiers	numeric	10	√		NULL::numeric	Keystroke Modifiers for shortcuts
ad_language	languageiso	bpchar	2	√		null	Lower-case two-letter ISO-3166 code - http://www.ics.uci.edu/pub/ietf/http/related/iso639.txt
ad_infoprocess	layouttype	varchar	10			'B'::character varying	Layout type of info process
ad_styleline	line	numeric	10				Unique line for this document
ad_table	loadseq	numeric	10	√		null	Sequence
ad_column	mandatorylogic	varchar	2000	√		null	Mandatory Logic
ad_field	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_process_para	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_userdef_field	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_userdef_proc_parameter	mandatorylogic	varchar	2000	√		NULL::character varying	Mandatory Logic
ad_infowindow	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_role	maxqueryrecords	numeric	10			0	If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
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_modelvalidator	modelvalidationclass	varchar	255				Model Validation Class
ad_message	msgtext	varchar	2000				Textual Informational, Menu or Error Message
ad_message	msgtip	varchar	2000	√		null	Additional tip or help for this message
ad_message	msgtype	bpchar	1				Type of message (Informational, Menu or Error)
ad_attribute	name	varchar	60				Alphanumeric identifier of the entity
ad_column	name	varchar	60				Alphanumeric identifier of the entity
ad_element	name	varchar	60				Alphanumeric identifier of the entity
ad_field	name	varchar	60				Alphanumeric identifier of the entity
ad_fieldgroup	name	varchar	60				Alphanumeric identifier of the entity
ad_infocolumn	name	varchar	60				Alphanumeric identifier of the entity
ad_inforelated	name	varchar	60				Alphanumeric identifier of the entity
ad_infowindow	name	varchar	60				Alphanumeric identifier of the entity
ad_language	name	varchar	60				Alphanumeric identifier of the entity
ad_modelvalidator	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_reference	name	varchar	60				Alphanumeric identifier of the entity
ad_relationtype	name	varchar	60				Alphanumeric identifier of the entity
ad_role	name	varchar	60				Alphanumeric identifier of the entity
ad_rule	name	varchar	60				Alphanumeric identifier of the entity
ad_searchdefinition	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_statusline	name	varchar	60				Alphanumeric identifier of the entity
ad_style	name	varchar	60				Alphanumeric identifier of the entity
ad_sysconfig	name	varchar	50				Alphanumeric identifier of the entity
ad_tab	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
ad_tableindex	name	varchar	50				Alphanumeric identifier of the entity
ad_toolbarbutton	name	varchar	60				Alphanumeric identifier of the entity
ad_userdef_field	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_userdef_info	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_userdef_info_column	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_userdef_info_related	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_userdef_proc	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_userdef_proc_parameter	name	varchar	60	√		NULL::character varying	Alphanumeric identifier of the entity
ad_userdef_tab	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_userdef_win	name	varchar	60	√		null	Alphanumeric identifier of the entity
ad_val_rule	name	varchar	60				Alphanumeric identifier of the entity
ad_viewcomponent	name	varchar	50				Alphanumeric identifier of the entity
ad_window	name	varchar	60				Alphanumeric identifier of the entity
ad_zoomcondition	name	varchar	60				Alphanumeric identifier of the entity
ad_field	numlines	numeric	10	√		(1)::numeric	Number of lines for a field
ad_userdef_field	numlines	numeric	10	√		NULL::numeric	Number of lines for a field
ad_field	obscuretype	bpchar	3	√		null	Type of obscuring the data (limiting the display)
ad_infowindow	orderbyclause	varchar	2000	√		NULL::character varying	Fully qualified ORDER BY clause
ad_ref_table	orderbyclause	varchar	2000	√		null	Fully qualified ORDER BY clause
ad_tab	orderbyclause	varchar	2000	√		null	Fully qualified ORDER BY clause
ad_userdef_tab	orderbyclause	varchar	2000	√		NULL::character varying	Fully qualified ORDER BY clause
ad_infowindow	otherclause	varchar	2000	√		null	Other SQL Clause
ad_viewcomponent	otherclause	varchar	2000	√		NULL::character varying	Other SQL Clause
ad_role	overwritepricelimit	bpchar	1			'N'::bpchar	Overwrite Price Limit if the Price List enforces the Price Limit
ad_column	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
ad_userdef_field	pa_dashboardcontent_id	numeric	10	√		NULL::numeric	Dashboard Content
ad_infowindow	pagingsize	numeric	10			'0'::numeric	Paging Size
ad_tab	parent_column_id	numeric	10	√		NULL::numeric	The link column on the parent tab.
ad_inforelated	parentrelatedcolumn_id	numeric	10	√		NULL::numeric	column in parent info window, link with column in this relate info
ad_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_element	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_field	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_infocolumn	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_userdef_field	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_userdef_info_column	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_userdef_proc_parameter	placeholder	varchar	255	√		NULL::character varying	Placeholder
ad_process_para	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
ad_userdef_proc_parameter	placeholder2	varchar	255	√		NULL::character varying	Placeholder2
ad_element	po_description	varchar	255	√		null	Description in PO Screens
ad_element	po_help	varchar	2000	√		null	Help for PO Screens
ad_element	po_name	varchar	60	√		null	Name on PO Screens
ad_element	po_printname	varchar	60	√		null	Print name on PO Screens/Reports
ad_searchdefinition	po_window_id	numeric	10	√		null	Purchase Order Window
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
ad_window	predefinedcontextvariables	varchar	4000	√		NULL::character varying	Predefined context variables to inject when opening a menu entry or a window
ad_role	preferencetype	bpchar	1			'C'::bpchar	Determines what preferences the user can set
ad_element	printname	varchar	60				The label text to be printed on a document or correspondence.
ad_language	printname	varchar	60			NULL::character varying	The label text to be printed on a document or correspondence.
ad_process	procedurename	varchar	60	√		null	Name of the Database Procedure
ad_infowindow	processing	bpchar	1	√		null	Process Now
ad_language	processing	bpchar	1	√		null	Process Now
ad_tab	processing	bpchar	1	√		null	Process Now
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_tableindex	processing	bpchar	1	√		NULL::bpchar	Process Now
ad_window	processing	bpchar	1	√		null	Process Now
ad_process_para	query	varchar	2000	√		NULL::character varying	SQL
ad_searchdefinition	query	varchar	2000	√		null	SQL
ad_infocolumn	queryfunction	varchar	255	√		NULL::character varying	Database function for query
ad_userdef_info_column	queryfunction	varchar	2000	√		NULL::character varying	Database function for query
ad_infocolumn	queryoperator	varchar	10	√		NULL::character varying	Operator for database query
ad_userdef_info_column	queryoperator	varchar	10	√		NULL::character varying	Operator for database query
ad_column	readonlylogic	varchar	2000	√		null	Logic to determine if field is read only (applies only when field is read-write)
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_userdef_field	readonlylogic	varchar	2000	√		NULL::character varying	Logic to determine if field is read only (applies only when field is read-write)
ad_userdef_proc_parameter	readonlylogic	varchar	2000	√		NULL::character varying	Logic to determine if field is read only (applies only when field is read-write)
ad_userdef_tab	readonlylogic	varchar	2000	√		NULL::character varying	Logic to determine if field is read only (applies only when field is read-write)
ad_attribute_value	record_id	numeric	10				Direct internal record ID
ad_viewcomponent	referenced_table_id	numeric	10	√		NULL::numeric	Referenced Table
ad_inforelated	relatedcolumn_id	numeric	10			(0)::numeric	Related Info Column
ad_inforelated	relatedinfo_id	numeric	10			(0)::numeric	Related Info Window
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
ad_relationtype	role_source	varchar	50	√		null	If set, this role will be used as label for the zoom destination instead of the destinations's window name
ad_relationtype	role_target	varchar	50	√		null	If set, this role will be used as label for the zoom destination instead of the destinations's window name
ad_role	roletype	varchar	2	√		NULL::character varying	Role Type
ad_rule	ruletype	bpchar	1	√		null	Rule Type
ad_rule	script	varchar	4000	√		null	Dynamic Java Language Script to calculate result
ad_searchdefinition	searchtype	varchar	1				Which kind of search is used (Query or Table)
ad_infocolumn	selectclause	varchar	2000				SQL SELECT clause
ad_attribute	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_column	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_field	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_indexcolumn	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_infocolumn	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_infoprocess	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_inforelated	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_infowindow	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_modelvalidator	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_statuslineusedin	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_tab	seqno	numeric	10				Method of ordering records; lowest number comes first
ad_table_scriptvalidator	seqno	numeric	10			0	Method of ordering records; lowest number comes first
ad_toolbarbutton	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_userdef_field	seqno	numeric	10			(0)::numeric	Method of ordering records; lowest number comes first
ad_userdef_info	seqno	numeric	10			'0'::numeric	Method of ordering records; lowest number comes first
ad_userdef_info_column	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_userdef_info_related	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
ad_userdef_proc_parameter	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_userdef_tab	seqno	numeric	10	√		NULL::numeric	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_zoomcondition	seqno	numeric	10	√		NULL::numeric	Method of ordering records; lowest number comes first
ad_field	seqnogrid	numeric	10	√		NULL::numeric	Grid Sequence No
ad_userdef_field	seqnogrid	numeric	10			'0'::numeric	Grid Sequence No
ad_column	seqnoselection	numeric	10	√		NULL::numeric	Selection Column Sequence
ad_infocolumn	seqnoselection	numeric	10	√		(0)::numeric	Selection Column Sequence
ad_userdef_info_column	seqnoselection	numeric	10	√		'0'::numeric	Selection Column Sequence
ad_process	showhelp	bpchar	1	√		'Y'::bpchar	Show Help
ad_field	sortno	numeric	10	√		null	Determines in what order the records are displayed
ad_userdef_field	sortno	numeric	10			0	Determines in what order the records are displayed
ad_statusline	sqlstatement	varchar	2000				SQL Expression/Statement
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_role	supervisor_id	numeric	10	√		null	Supervisor for this user/organization - used for escalation and approval
ad_tableindex	tableindexdrop	bpchar	1	√		NULL::bpchar	Drop table index
ad_table	tablename	varchar	40				Name of the table in the database
ad_tab	tablevel	numeric	10				Hierarchical Tab Level (0 = top)
ad_styleline	theme	varchar	60	√		NULL::character varying	Theme name
ad_language	timepattern	varchar	20	√		null	Java Time Pattern
ad_window	titlelogic	varchar	255	√		NULL::character varying	The result determines the title to be displayed for this window
ad_searchdefinition	transactioncode	varchar	8	√		null	The transaction code represents the search definition
ad_tab	treedisplayedon	bpchar	1			'B'::bpchar	The tree can be displayed on master tab, detail tab or both
ad_relationtype	type	bpchar	1			'I'::bpchar	Type of Validation (SQL, Java Script, Java Language)
ad_val_rule	type	bpchar	1	√		null	Type of Validation (SQL, Java Script, Java Language)
ad_attribute	updated	timestamp	29,6			now()	Date this record was updated
ad_column	updated	timestamp	29,6			now()	Date this record was updated
ad_element	updated	timestamp	29,6			now()	Date this record was updated
ad_field	updated	timestamp	29,6			now()	Date this record was updated
ad_fieldgroup	updated	timestamp	29,6			now()	Date this record was updated
ad_indexcolumn	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_infocolumn	updated	timestamp	29,6			now()	Date this record was updated
ad_infoprocess	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_inforelated	updated	timestamp	29,6				Date this record was updated
ad_infowindow	updated	timestamp	29,6			now()	Date this record was updated
ad_language	updated	timestamp	29,6			now()	Date this record was updated
ad_message	updated	timestamp	29,6			now()	Date this record was updated
ad_modelvalidator	updated	timestamp	29,6			statement_timestamp()	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_ref_table	updated	timestamp	29,6			now()	Date this record was updated
ad_reference	updated	timestamp	29,6			now()	Date this record was updated
ad_relationtype	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_role	updated	timestamp	29,6			now()	Date this record was updated
ad_rule	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_searchdefinition	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_statusline	updated	timestamp	29,6				Date this record was updated
ad_statuslineusedin	updated	timestamp	29,6				Date this record was updated
ad_style	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_styleline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_sysconfig	updated	timestamp	29,6			statement_timestamp()	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_table	updated	timestamp	29,6			now()	Date this record was updated
ad_table_scriptvalidator	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_tableindex	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_toolbarbutton	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_userdef_field	updated	timestamp	29,6			now()	Date this record was updated
ad_userdef_info	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_userdef_info_column	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_userdef_info_related	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_userdef_proc	updated	timestamp	29,6				Date this record was updated
ad_userdef_proc_parameter	updated	timestamp	29,6				Date this record was updated
ad_userdef_tab	updated	timestamp	29,6			now()	Date this record was updated
ad_userdef_win	updated	timestamp	29,6			now()	Date this record was updated
ad_val_rule	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_window	updated	timestamp	29,6			now()	Date this record was updated
ad_zoomcondition	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
ad_attribute	updatedby	numeric	10				User who updated this records
ad_column	updatedby	numeric	10				User who updated this records
ad_element	updatedby	numeric	10				User who updated this records
ad_field	updatedby	numeric	10				User who updated this records
ad_fieldgroup	updatedby	numeric	10				User who updated this records
ad_indexcolumn	updatedby	numeric	10				User who updated this records
ad_infocolumn	updatedby	numeric	10				User who updated this records
ad_infoprocess	updatedby	numeric	10				User who updated this records
ad_inforelated	updatedby	numeric	10				User who updated this records
ad_infowindow	updatedby	numeric	10				User who updated this records
ad_language	updatedby	numeric	10				User who updated this records
ad_message	updatedby	numeric	10				User who updated this records
ad_modelvalidator	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_ref_table	updatedby	numeric	10				User who updated this records
ad_reference	updatedby	numeric	10				User who updated this records
ad_relationtype	updatedby	numeric	10				User who updated this records
ad_role	updatedby	numeric	10				User who updated this records
ad_rule	updatedby	numeric	10				User who updated this records
ad_searchdefinition	updatedby	numeric	10				User who updated this records
ad_statusline	updatedby	numeric	10				User who updated this records
ad_statuslineusedin	updatedby	numeric	10				User who updated this records
ad_style	updatedby	numeric	10				User who updated this records
ad_styleline	updatedby	numeric	10				User who updated this records
ad_sysconfig	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_table	updatedby	numeric	10				User who updated this records
ad_table_scriptvalidator	updatedby	numeric	10				User who updated this records
ad_tableindex	updatedby	numeric	10				User who updated this records
ad_toolbarbutton	updatedby	numeric	10				User who updated this records
ad_userdef_field	updatedby	numeric	10				User who updated this records
ad_userdef_info	updatedby	numeric	10				User who updated this records
ad_userdef_info_column	updatedby	numeric	10				User who updated this records
ad_userdef_info_related	updatedby	numeric	10				User who updated this records
ad_userdef_proc	updatedby	numeric	10				User who updated this records
ad_userdef_proc_parameter	updatedby	numeric	10				User who updated this records
ad_userdef_tab	updatedby	numeric	10				User who updated this records
ad_userdef_win	updatedby	numeric	10				User who updated this records
ad_val_rule	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_window	updatedby	numeric	10				User who updated this records
ad_zoomcondition	updatedby	numeric	10				User who updated this records
ad_role	userdiscount	numeric	22,2	√		null	UserDiscount
ad_role	userlevel	bpchar	3			' O'::bpchar	System Client Organization
ad_attribute_value	v_date	timestamp	29,6	√		null	Date
ad_attribute_value	v_number	numeric	0	√		null	Number
ad_attribute_value	v_string	varchar	2000	√		null	String
ad_reference	validationtype	bpchar	1				Different method of validating data
ad_ref_list	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_message	value	varchar	255				Search key for the record in the format required - must be unique
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_rule	value	varchar	40				Search key for the record in the format required - must be unique
ad_sysconfig	value	varchar	4000				Search key for the record in the format required - must be unique
ad_attribute	valuemax	varchar	20	√		null	Maximum Value for a field
ad_column	valuemax	varchar	20	√		null	Maximum Value for a field
ad_process_para	valuemax	varchar	20	√		null	Maximum Value for a field
ad_userdef_proc_parameter	valuemax	varchar	20	√		NULL::character varying	Maximum Value for a field
ad_attribute	valuemin	varchar	20	√		null	Minimum 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_userdef_proc_parameter	valuemin	varchar	20	√		NULL::character varying	Minimum Value for a field
ad_column	version	numeric	0				Version of the table definition
ad_attribute	vformat	varchar	60	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_column	vformat	varchar	255	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
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_reference	vformat	varchar	40	√		null	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_userdef_field	vformat	varchar	255	√		NULL::character varying	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_userdef_proc_parameter	vformat	varchar	40	√		NULL::character varying	Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_infowindow	whereclause	varchar	2000	√		NULL::character varying	Fully qualified SQL WHERE clause
ad_ref_table	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_tab	whereclause	varchar	2000	√		null	Fully qualified SQL WHERE clause
ad_userdef_tab	whereclause	varchar	2000	√		NULL::character varying	Fully qualified SQL WHERE clause
ad_viewcomponent	whereclause	varchar	2000	√		NULL::character varying	Fully qualified SQL WHERE clause
ad_zoomcondition	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_userdef_field	xposition	numeric	10	√		NULL::numeric	Absolute X (horizontal) position in 1/72 of an inch
ad_zoomcondition	zoomlogic	varchar	2000	√		NULL::character varying	the result determines if the zoom condition is applied