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

idempiere9.adempiere contains 1102 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
ad_process accesslevel bpchar 1
ad_rule accesslevel bpchar 1  √  null
ad_table accesslevel bpchar 1
ad_toolbarbutton action bpchar 1 'W'::bpchar
ad_toolbarbutton actionclassname varchar 255  √  NULL::character varying
ad_toolbarbutton actionname varchar 60  √  NULL::character varying
ad_attribute ad_attribute_id numeric 10
ad_attribute_value ad_attribute_id numeric 10
ad_attribute ad_attribute_uu varchar 36  √  NULL::character varying
ad_attribute_value ad_attribute_value_uu varchar 36  √  NULL::character varying
ad_column ad_chart_id numeric 10  √  NULL::numeric
ad_attribute ad_client_id numeric 10
ad_column ad_client_id numeric 10
ad_element ad_client_id numeric 10
ad_field ad_client_id numeric 10
ad_fieldgroup ad_client_id numeric 10
ad_indexcolumn ad_client_id numeric 10
ad_infocolumn ad_client_id numeric 10
ad_infoprocess ad_client_id numeric 10
ad_inforelated ad_client_id numeric 10
ad_infowindow ad_client_id numeric 10
ad_language ad_client_id numeric 10
ad_message ad_client_id numeric 10
ad_modelvalidator ad_client_id numeric 10 0
ad_process ad_client_id numeric 10
ad_process_para ad_client_id numeric 10
ad_ref_list ad_client_id numeric 10
ad_ref_table ad_client_id numeric 10
ad_reference ad_client_id numeric 10
ad_relationtype ad_client_id numeric 10
ad_role ad_client_id numeric 10
ad_rule ad_client_id numeric 10
ad_searchdefinition ad_client_id numeric 10 NULL::numeric
ad_statusline ad_client_id numeric 10
ad_statuslineusedin ad_client_id numeric 10
ad_style ad_client_id numeric 10
ad_styleline ad_client_id numeric 10
ad_sysconfig ad_client_id numeric 10
ad_tab ad_client_id numeric 10
ad_tab_customization ad_client_id numeric 10
ad_table ad_client_id numeric 10
ad_table_scriptvalidator ad_client_id numeric 10
ad_tableindex ad_client_id numeric 10
ad_toolbarbutton ad_client_id numeric 10
ad_userdef_field ad_client_id numeric 10
ad_userdef_info ad_client_id numeric 10
ad_userdef_info_column ad_client_id numeric 10
ad_userdef_info_related ad_client_id numeric 10
ad_userdef_proc ad_client_id numeric 10
ad_userdef_proc_parameter ad_client_id numeric 10
ad_userdef_tab ad_client_id numeric 10
ad_userdef_win ad_client_id numeric 10
ad_val_rule ad_client_id numeric 10
ad_viewcolumn ad_client_id numeric 10
ad_viewcomponent ad_client_id numeric 10
ad_window ad_client_id numeric 10
ad_zoomcondition ad_client_id numeric 10
ad_window ad_color_id numeric 10  √  null
ad_column ad_column_id numeric 10
ad_field ad_column_id numeric 10  √  null
ad_indexcolumn ad_column_id numeric 10  √  null
ad_searchdefinition ad_column_id numeric 10  √  null
ad_tab ad_column_id numeric 10  √  null
ad_column ad_column_uu varchar 36  √  NULL::character varying
ad_tab ad_columnsortorder_id numeric 10  √  null
ad_tab ad_columnsortyesno_id numeric 10  √  null
ad_infowindow ad_ctxhelp_id numeric 10  √  NULL::numeric
ad_process ad_ctxhelp_id numeric 10  √  NULL::numeric
ad_tab ad_ctxhelp_id numeric 10  √  NULL::numeric
ad_ref_table ad_display numeric 10
ad_column ad_element_id numeric 10  √  null
ad_element ad_element_id numeric 10
ad_infocolumn ad_element_id numeric 10  √  null
ad_process_para ad_element_id numeric 10  √  null
ad_reference ad_element_id numeric 10  √  NULL::numeric
ad_element ad_element_uu varchar 36  √  NULL::character varying
ad_field ad_field_id numeric 10
ad_userdef_field ad_field_id numeric 10
ad_field ad_field_uu varchar 36  √  NULL::character varying
ad_field ad_fieldgroup_id numeric 10  √  null
ad_fieldgroup ad_fieldgroup_id numeric 10
ad_process_para ad_fieldgroup_id numeric 10  √  NULL::numeric
ad_userdef_field ad_fieldgroup_id numeric 10  √  NULL::numeric
ad_userdef_proc_parameter ad_fieldgroup_id numeric 10  √  NULL::numeric
ad_fieldgroup ad_fieldgroup_uu varchar 36  √  NULL::character varying
ad_field ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_infocolumn ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_userdef_field ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_userdef_info_column ad_fieldstyle_id numeric 10  √  NULL::numeric
ad_process ad_form_id numeric 10  √  null
ad_tab ad_image_id numeric 10  √  null
ad_window ad_image_id numeric 10  √  null
ad_indexcolumn ad_indexcolumn_id numeric 10
ad_indexcolumn ad_indexcolumn_uu varchar 36  √  NULL::character varying
ad_infocolumn ad_infocolumn_id numeric 10
ad_infoprocess ad_infocolumn_id numeric 10  √  null
ad_userdef_info_column ad_infocolumn_id numeric 10
ad_infocolumn ad_infocolumn_uu varchar 36  √  NULL::character varying
ad_infoprocess ad_infoprocess_id numeric 10
ad_infoprocess ad_infoprocess_uu varchar 36
ad_inforelated ad_inforelated_id numeric 10
ad_userdef_info_related ad_inforelated_id numeric 10
ad_inforelated ad_inforelated_uu varchar 36  √  NULL::character varying
ad_infocolumn ad_infowindow_id numeric 10
ad_infoprocess ad_infowindow_id numeric 10  √  NULL::numeric
ad_inforelated ad_infowindow_id numeric 10
ad_infowindow ad_infowindow_id numeric 10
ad_ref_table ad_infowindow_id numeric 10  √  NULL::numeric
ad_userdef_info ad_infowindow_id numeric 10
ad_infowindow ad_infowindow_uu varchar 36  √  NULL::character varying
ad_ref_table ad_key numeric 10
ad_field ad_labelstyle_id numeric 10  √  NULL::numeric
ad_userdef_field ad_labelstyle_id numeric 10  √  NULL::numeric
ad_language ad_language varchar 6
ad_userdef_info ad_language varchar 6  √  NULL::character varying
ad_userdef_proc ad_language varchar 6  √  NULL::character varying
ad_userdef_win ad_language varchar 6  √  null
ad_language ad_language_id numeric 10
ad_language ad_language_uu varchar 36  √  NULL::character varying
ad_message ad_message_id numeric 10
ad_statusline ad_message_id numeric 10
ad_tableindex ad_message_id numeric 10  √  NULL::numeric
ad_message ad_message_uu varchar 36  √  NULL::character varying
ad_modelvalidator ad_modelvalidator_id numeric 10
ad_modelvalidator ad_modelvalidator_uu varchar 36  √  NULL::character varying
ad_attribute ad_org_id numeric 10
ad_column ad_org_id numeric 10
ad_element ad_org_id numeric 10
ad_field ad_org_id numeric 10
ad_fieldgroup ad_org_id numeric 10
ad_indexcolumn ad_org_id numeric 10
ad_infocolumn ad_org_id numeric 10
ad_infoprocess ad_org_id numeric 10
ad_inforelated ad_org_id numeric 10
ad_infowindow ad_org_id numeric 10
ad_language ad_org_id numeric 10
ad_message ad_org_id numeric 10
ad_modelvalidator ad_org_id numeric 10 0
ad_process ad_org_id numeric 10
ad_process_para ad_org_id numeric 10
ad_ref_list ad_org_id numeric 10
ad_ref_table ad_org_id numeric 10
ad_reference ad_org_id numeric 10
ad_relationtype ad_org_id numeric 10
ad_role ad_org_id numeric 10
ad_rule ad_org_id numeric 10
ad_searchdefinition ad_org_id numeric 10 NULL::numeric
ad_statusline ad_org_id numeric 10
ad_statuslineusedin ad_org_id numeric 10
ad_style ad_org_id numeric 10
ad_styleline ad_org_id numeric 10
ad_sysconfig ad_org_id numeric 10
ad_tab ad_org_id numeric 10
ad_tab_customization ad_org_id numeric 10
ad_table ad_org_id numeric 10
ad_table_scriptvalidator ad_org_id numeric 10
ad_tableindex ad_org_id numeric 10
ad_toolbarbutton ad_org_id numeric 10
ad_userdef_field ad_org_id numeric 10
ad_userdef_info ad_org_id numeric 10
ad_userdef_info_column ad_org_id numeric 10
ad_userdef_info_related ad_org_id numeric 10
ad_userdef_proc ad_org_id numeric 10
ad_userdef_proc_parameter ad_org_id numeric 10
ad_userdef_tab ad_org_id numeric 10
ad_userdef_win ad_org_id numeric 10
ad_val_rule ad_org_id numeric 10
ad_viewcolumn ad_org_id numeric 10
ad_viewcomponent ad_org_id numeric 10
ad_window ad_org_id numeric 10
ad_zoomcondition ad_org_id numeric 10
ad_process ad_printformat_id numeric 10  √  null
ad_language ad_printpaper_id numeric 10  √  NULL::numeric
ad_column ad_process_id numeric 10  √  null
ad_infoprocess ad_process_id numeric 10
ad_infowindow ad_process_id numeric 10  √  NULL::numeric
ad_process ad_process_id numeric 10
ad_process_para ad_process_id numeric 10
ad_tab ad_process_id numeric 10  √  null
ad_toolbarbutton ad_process_id numeric 10  √  NULL::numeric
ad_userdef_proc ad_process_id numeric 10
ad_userdef_tab ad_process_id numeric 10  √  NULL::numeric
ad_process_para ad_process_para_id numeric 10
ad_userdef_proc_parameter ad_process_para_id numeric 10
ad_process_para ad_process_para_uu varchar 36  √  NULL::character varying
ad_process ad_process_uu varchar 36  √  NULL::character varying
ad_ref_list ad_ref_list_id numeric 10
ad_ref_list ad_ref_list_uu varchar 36  √  NULL::character varying
ad_ref_table ad_ref_table_uu varchar 36  √  NULL::character varying
ad_attribute ad_reference_id numeric 10
ad_column ad_reference_id numeric 10
ad_field ad_reference_id numeric 10  √  null
ad_infocolumn ad_reference_id numeric 10
ad_process_para ad_reference_id numeric 10
ad_ref_list ad_reference_id numeric 10
ad_ref_table ad_reference_id numeric 10
ad_reference ad_reference_id numeric 10
ad_userdef_field ad_reference_id numeric 10  √  NULL::numeric
ad_userdef_info_column ad_reference_id numeric 10  √  NULL::numeric
ad_userdef_proc_parameter ad_reference_id numeric 10  √  NULL::numeric
ad_relationtype ad_reference_source_id numeric 10  √  NULL::numeric
ad_relationtype ad_reference_target_id numeric 10  √  NULL::numeric
ad_reference ad_reference_uu varchar 36  √  NULL::character varying
ad_attribute ad_reference_value_id numeric 10  √  null
ad_column ad_reference_value_id numeric 10  √  null
ad_field ad_reference_value_id numeric 10  √  null
ad_infocolumn ad_reference_value_id numeric 10  √  NULL::numeric
ad_process_para ad_reference_value_id numeric 10  √  null
ad_userdef_field ad_reference_value_id numeric 10  √  NULL::numeric
ad_userdef_info_column ad_reference_value_id numeric 10  √  NULL::numeric
ad_userdef_proc_parameter ad_reference_value_id numeric 10  √  NULL::numeric
ad_relationtype ad_relationtype_id numeric 10
ad_relationtype ad_relationtype_uu varchar 36  √  NULL::character varying
ad_process ad_reportview_id numeric 10  √  null
ad_role ad_role_id numeric 10
ad_userdef_info ad_role_id numeric 10  √  NULL::numeric
ad_userdef_proc ad_role_id numeric 10  √  NULL::numeric
ad_userdef_win ad_role_id numeric 10  √  null
ad_role ad_role_uu varchar 36  √  NULL::character varying
ad_rule ad_rule_id numeric 10
ad_table_scriptvalidator ad_rule_id numeric 10
ad_rule ad_rule_uu varchar 36  √  NULL::character varying
ad_searchdefinition ad_searchdefinition_id numeric 10
ad_searchdefinition ad_searchdefinition_uu varchar 36  √  NULL::character varying
ad_statusline ad_statusline_id numeric 10
ad_statuslineusedin ad_statusline_id numeric 10
ad_statusline ad_statusline_uu varchar 36  √  NULL::character varying
ad_statuslineusedin ad_statuslineusedin_id numeric 10
ad_statuslineusedin ad_statuslineusedin_uu varchar 36  √  NULL::character varying
ad_style ad_style_id numeric 10
ad_styleline ad_style_id numeric 10
ad_style ad_style_uu varchar 36
ad_styleline ad_styleline_id numeric 10
ad_styleline ad_styleline_uu varchar 36
ad_sysconfig ad_sysconfig_id numeric 10
ad_sysconfig ad_sysconfig_uu varchar 36  √  NULL::character varying
ad_tab_customization ad_tab_customization_id numeric 10 NULL::numeric
ad_tab_customization ad_tab_customization_uu varchar 36  √  NULL::character varying
ad_field ad_tab_id numeric 10
ad_statuslineusedin ad_tab_id numeric 10  √  NULL::numeric
ad_tab ad_tab_id numeric 10
ad_tab_customization ad_tab_id numeric 10  √  NULL::numeric
ad_toolbarbutton ad_tab_id numeric 10  √  NULL::numeric
ad_userdef_tab ad_tab_id numeric 10
ad_tab ad_tab_uu varchar 36  √  NULL::character varying
ad_attribute ad_table_id numeric 10
ad_column ad_table_id numeric 10
ad_infowindow ad_table_id numeric 10
ad_ref_table ad_table_id numeric 10
ad_searchdefinition ad_table_id numeric 10
ad_statuslineusedin ad_table_id numeric 10  √  NULL::numeric
ad_tab ad_table_id numeric 10
ad_table ad_table_id numeric 10
ad_table_scriptvalidator ad_table_id numeric 10
ad_tableindex ad_table_id numeric 10
ad_viewcomponent ad_table_id numeric 10
ad_zoomcondition ad_table_id numeric 10
ad_table_scriptvalidator ad_table_scriptvalidator_id numeric 10
ad_table_scriptvalidator ad_table_scriptvalidator_uu varchar 36  √  NULL::character varying
ad_table ad_table_uu varchar 36  √  NULL::character varying
ad_indexcolumn ad_tableindex_id numeric 10
ad_tableindex ad_tableindex_id numeric 10
ad_tableindex ad_tableindex_uu varchar 36  √  NULL::character varying
ad_tab ad_tabtype varchar 40  √  NULL::character varying
ad_toolbarbutton ad_toolbarbutton_id numeric 10
ad_toolbarbutton ad_toolbarbutton_uu varchar 36  √  NULL::character varying
ad_role ad_tree_menu_id numeric 10  √  null
ad_role ad_tree_org_id numeric 10  √  null
ad_tab_customization ad_user_id numeric 10
ad_userdef_info ad_user_id numeric 10  √  NULL::numeric
ad_userdef_proc ad_user_id numeric 10  √  NULL::numeric
ad_userdef_win ad_user_id numeric 10  √  null
ad_userdef_field ad_userdef_field_id numeric 10
ad_userdef_field ad_userdef_field_uu varchar 36  √  NULL::character varying
ad_userdef_info_column ad_userdef_info_column_id numeric 10
ad_userdef_info_column ad_userdef_info_column_uu varchar 36  √  NULL::character varying
ad_userdef_info ad_userdef_info_id numeric 10
ad_userdef_info_column ad_userdef_info_id numeric 10
ad_userdef_info_related ad_userdef_info_id numeric 10
ad_userdef_info_related ad_userdef_info_related_id numeric 10
ad_userdef_info_related ad_userdef_info_related_uu varchar 36  √  NULL::character varying
ad_userdef_info ad_userdef_info_uu varchar 36  √  NULL::character varying
ad_userdef_proc ad_userdef_proc_id numeric 10
ad_userdef_proc_parameter ad_userdef_proc_id numeric 10
ad_userdef_proc_parameter ad_userdef_proc_parameter_id numeric 10
ad_userdef_proc_parameter ad_userdef_proc_parameter_uu varchar 36  √  NULL::character varying
ad_userdef_proc ad_userdef_proc_uu varchar 36  √  NULL::character varying
ad_userdef_field ad_userdef_tab_id numeric 10
ad_userdef_tab ad_userdef_tab_id numeric 10
ad_userdef_tab ad_userdef_tab_uu varchar 36  √  NULL::character varying
ad_userdef_tab ad_userdef_win_id numeric 10
ad_userdef_win ad_userdef_win_id numeric 10
ad_userdef_win ad_userdef_win_uu varchar 36  √  NULL::character varying
ad_attribute ad_val_rule_id numeric 10  √  null
ad_column ad_val_rule_id numeric 10  √  null
ad_field ad_val_rule_id numeric 10  √  null
ad_infocolumn ad_val_rule_id numeric 10  √  NULL::numeric
ad_process_para ad_val_rule_id numeric 10  √  null
ad_table ad_val_rule_id numeric 10  √  null
ad_userdef_field ad_val_rule_id numeric 10  √  NULL::numeric
ad_userdef_info_column ad_val_rule_id numeric 10  √  NULL::numeric
ad_userdef_proc_parameter ad_val_rule_id numeric 10  √  NULL::numeric
ad_val_rule ad_val_rule_id numeric 10
ad_column ad_val_rule_lookup_id numeric 10  √  NULL::numeric
ad_field ad_val_rule_lookup_id numeric 10  √  NULL::numeric
ad_userdef_field ad_val_rule_lookup_id numeric 10  √  NULL::numeric
ad_val_rule ad_val_rule_uu varchar 36  √  NULL::character varying
ad_viewcolumn ad_viewcolumn_id numeric 10
ad_viewcolumn ad_viewcolumn_uu varchar 36  √  NULL::character varying
ad_viewcolumn ad_viewcomponent_id numeric 10
ad_viewcomponent ad_viewcomponent_id numeric 10
ad_viewcomponent ad_viewcomponent_uu varchar 36  √  NULL::character varying
ad_ref_table ad_window_id numeric 10  √  null
ad_searchdefinition ad_window_id numeric 10
ad_statuslineusedin ad_window_id numeric 10  √  NULL::numeric
ad_tab ad_window_id numeric 10
ad_table ad_window_id numeric 10  √  null
ad_userdef_win ad_window_id numeric 10
ad_window ad_window_id numeric 10
ad_zoomcondition ad_window_id numeric 10  √  NULL::numeric
ad_window ad_window_uu varchar 36  √  NULL::character varying
ad_process ad_workflow_id numeric 10  √  null
ad_zoomcondition ad_zoomcondition_id numeric 10
ad_zoomcondition ad_zoomcondition_uu varchar 36  √  NULL::character varying
ad_role allow_info_account bpchar 1 'Y'::bpchar
ad_role allow_info_asset bpchar 1 'Y'::bpchar
ad_role allow_info_bpartner bpchar 1 'Y'::bpchar
ad_role allow_info_cashjournal bpchar 1 'N'::bpchar
ad_role allow_info_crp bpchar 1 'N'::bpchar
ad_role allow_info_inout bpchar 1 'Y'::bpchar
ad_role allow_info_invoice bpchar 1 'Y'::bpchar
ad_role allow_info_mrp bpchar 1 'N'::bpchar
ad_role allow_info_order bpchar 1 'Y'::bpchar
ad_role allow_info_payment bpchar 1 'Y'::bpchar
ad_role allow_info_product bpchar 1 'Y'::bpchar
ad_role allow_info_resource bpchar 1 'Y'::bpchar
ad_role allow_info_schedule bpchar 1 'Y'::bpchar
ad_process allowmultipleexecution bpchar 1  √  'P'::bpchar
ad_role amtapproval numeric 0  √  0
ad_role amtapprovalaccum numeric 0  √  null
ad_role c_currency_id numeric 10  √  null
ad_attribute callout varchar 60  √  null
ad_column callout varchar 255  √  null
ad_process classname varchar 255  √  null
ad_toolbarbutton classname varchar 255  √  null
ad_val_rule code varchar 2000  √  null
ad_column columnname varchar 30
ad_element columnname varchar 30
ad_infocolumn columnname varchar 30
ad_process_para columnname varchar 30
ad_viewcolumn columnname varchar 30 NULL::character varying
ad_field columnspan numeric 10  √  (1)::numeric
ad_userdef_field columnspan numeric 10  √  NULL::numeric
ad_column columnsql varchar 4000  √  null
ad_field columnsql varchar 4000  √  null
ad_indexcolumn columnsql varchar 255  √  NULL::character varying
ad_viewcolumn columnsql varchar 2000  √  null
ad_tab commitwarning varchar 2000  √  null
ad_toolbarbutton componentname varchar 255
ad_sysconfig configurationlevel bpchar 1  √  'S'::bpchar
ad_role confirmqueryrecords numeric 10 0
ad_role connectionprofile bpchar 1  √  null
ad_table copycolumnsfromtable varchar 1  √  null
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar
ad_process copyfromprocess bpchar 1  √  NULL::bpchar
ad_language countrycode bpchar 2  √  null
ad_attribute created timestamp 29,6 now()
ad_column created timestamp 29,6 now()
ad_element created timestamp 29,6 statement_timestamp()
ad_field created timestamp 29,6 now()
ad_fieldgroup created timestamp 29,6 now()
ad_indexcolumn created timestamp 29,6 statement_timestamp()
ad_infocolumn created timestamp 29,6 now()
ad_infoprocess created timestamp 29,6 statement_timestamp()
ad_inforelated created timestamp 29,6
ad_infowindow created timestamp 29,6 now()
ad_language created timestamp 29,6 now()
ad_message created timestamp 29,6 now()
ad_modelvalidator created timestamp 29,6 statement_timestamp()
ad_process created timestamp 29,6 now()
ad_process_para created timestamp 29,6 now()
ad_ref_list created timestamp 29,6 now()
ad_ref_table created timestamp 29,6 now()
ad_reference created timestamp 29,6 now()
ad_relationtype created timestamp 29,6 statement_timestamp()
ad_role created timestamp 29,6 now()
ad_rule created timestamp 29,6 statement_timestamp()
ad_searchdefinition created timestamp 29,6 statement_timestamp()
ad_statusline created timestamp 29,6
ad_statuslineusedin created timestamp 29,6
ad_style created timestamp 29,6  √  statement_timestamp()
ad_styleline created timestamp 29,6 statement_timestamp()
ad_sysconfig created timestamp 29,6 statement_timestamp()
ad_tab created timestamp 29,6 now()
ad_tab_customization created timestamp 29,6 statement_timestamp()
ad_table created timestamp 29,6 now()
ad_table_scriptvalidator created timestamp 29,6 statement_timestamp()
ad_tableindex created timestamp 29,6 statement_timestamp()
ad_toolbarbutton created timestamp 29,6 statement_timestamp()
ad_userdef_field created timestamp 29,6 now()
ad_userdef_info created timestamp 29,6 statement_timestamp()
ad_userdef_info_column created timestamp 29,6 statement_timestamp()
ad_userdef_info_related created timestamp 29,6 statement_timestamp()
ad_userdef_proc created timestamp 29,6
ad_userdef_proc_parameter created timestamp 29,6
ad_userdef_tab created timestamp 29,6 now()
ad_userdef_win created timestamp 29,6 now()
ad_val_rule created timestamp 29,6 now()
ad_viewcolumn created timestamp 29,6 statement_timestamp()
ad_viewcomponent created timestamp 29,6 statement_timestamp()
ad_window created timestamp 29,6 now()
ad_zoomcondition created timestamp 29,6 statement_timestamp()
ad_attribute createdby numeric 10
ad_column createdby numeric 10
ad_element createdby numeric 10
ad_field createdby numeric 10
ad_fieldgroup createdby numeric 10
ad_indexcolumn createdby numeric 10
ad_infocolumn createdby numeric 10
ad_infoprocess createdby numeric 10
ad_inforelated createdby numeric 10
ad_infowindow createdby numeric 10
ad_language createdby numeric 10
ad_message createdby numeric 10
ad_modelvalidator createdby numeric 10
ad_process createdby numeric 10
ad_process_para createdby numeric 10
ad_ref_list createdby numeric 10
ad_ref_table createdby numeric 10
ad_reference createdby numeric 10
ad_relationtype createdby numeric 10
ad_role createdby numeric 10
ad_rule createdby numeric 10
ad_searchdefinition createdby numeric 10  √  null
ad_statusline createdby numeric 10
ad_statuslineusedin createdby numeric 10
ad_style createdby numeric 10
ad_styleline createdby numeric 10
ad_sysconfig createdby numeric 10
ad_tab createdby numeric 10
ad_tab_customization createdby numeric 10
ad_table createdby numeric 10
ad_table_scriptvalidator createdby numeric 10
ad_tableindex createdby numeric 10
ad_toolbarbutton createdby numeric 10
ad_userdef_field createdby numeric 10
ad_userdef_info createdby numeric 10
ad_userdef_info_column createdby numeric 10
ad_userdef_info_related createdby numeric 10
ad_userdef_proc createdby numeric 10
ad_userdef_proc_parameter createdby numeric 10
ad_userdef_tab createdby numeric 10
ad_userdef_win createdby numeric 10
ad_val_rule createdby numeric 10
ad_viewcolumn createdby numeric 10
ad_viewcomponent createdby numeric 10
ad_window createdby numeric 10
ad_zoomcondition createdby numeric 10
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar
ad_tab_customization custom varchar 2000
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar
ad_searchdefinition datatype varchar 1
ad_language datepattern varchar 20  √  null
ad_role daysapprovalaccum numeric 10  √  null
ad_viewcolumn dbdatatype bpchar 1  √  NULL::bpchar
ad_attribute defaultvalue varchar 2000  √  null
ad_column defaultvalue varchar 2000  √  null
ad_field defaultvalue varchar 2000  √  null
ad_infocolumn defaultvalue varchar 2000  √  NULL::character varying
ad_process_para defaultvalue varchar 2000  √  null
ad_userdef_field defaultvalue varchar 2000  √  null
ad_userdef_info_column defaultvalue varchar 2000  √  NULL::character varying
ad_userdef_proc_parameter defaultvalue varchar 2000  √  NULL::character varying
ad_process_para defaultvalue2 varchar 2000  √  null
ad_userdef_proc_parameter defaultvalue2 varchar 2000  √  NULL::character varying
ad_attribute description varchar 255  √  null
ad_column description varchar 255  √  null
ad_element description varchar 255  √  null
ad_field description varchar 255  √  null
ad_infocolumn description varchar 255  √  null
ad_inforelated description varchar 255  √  NULL::character varying
ad_infowindow description varchar 255  √  null
ad_modelvalidator description varchar 255  √  null
ad_process description varchar 255  √  null
ad_process_para description varchar 255  √  null
ad_ref_list description varchar 255  √  null
ad_reference description varchar 255  √  null
ad_relationtype description varchar 255  √  NULL::character varying
ad_role description varchar 255  √  null
ad_rule description varchar 255  √  null
ad_searchdefinition description varchar 255  √  null
ad_style description varchar 255  √  NULL::character varying
ad_sysconfig description varchar 255  √  null
ad_tab description varchar 255  √  null
ad_table description varchar 255  √  null
ad_tableindex description varchar 255  √  NULL::character varying
ad_userdef_field description varchar 255  √  null
ad_userdef_info description varchar 255  √  NULL::character varying
ad_userdef_info_column description varchar 255  √  NULL::character varying
ad_userdef_info_related description varchar 255  √  NULL::character varying
ad_userdef_proc description varchar 255  √  NULL::character varying
ad_userdef_proc_parameter description varchar 255  √  NULL::character varying
ad_userdef_tab description varchar 255  √  null
ad_userdef_win description varchar 255  √  null
ad_val_rule description varchar 255  √  null
ad_viewcolumn description varchar 255  √  NULL::character varying
ad_viewcomponent description varchar 255  √  NULL::character varying
ad_window description varchar 255  √  null
ad_zoomcondition description varchar 255  √  NULL::character varying
ad_attribute displaylength numeric 10  √  null
ad_field displaylength numeric 10  √  null
ad_userdef_field displaylength numeric 10 0
ad_attribute displaylogic varchar 2000  √  null
ad_field displaylogic varchar 2000  √  null
ad_infocolumn displaylogic varchar 2000  √  NULL::character varying
ad_infoprocess displaylogic varchar 2000  √  NULL::character varying
ad_inforelated displaylogic varchar 2000  √  NULL::character varying
ad_process_para displaylogic varchar 2000  √  null
ad_styleline displaylogic varchar 2000  √  NULL::character varying
ad_tab displaylogic varchar 2000  √  null
ad_toolbarbutton displaylogic varchar 2000  √  NULL::character varying
ad_userdef_field displaylogic varchar 2000  √  null
ad_userdef_info_column displaylogic varchar 2000  √  NULL::character varying
ad_userdef_info_related displaylogic varchar 2000  √  NULL::character varying
ad_userdef_proc_parameter displaylogic varchar 2000  √  NULL::character varying
ad_userdef_tab displaylogic varchar 2000  √  NULL::character varying
ad_column entitytype varchar 40 'D'::character varying
ad_element entitytype varchar 40 'D'::character varying
ad_field entitytype varchar 40 'D'::character varying
ad_fieldgroup entitytype varchar 40 'D'::character varying
ad_indexcolumn entitytype varchar 40 'U'::character varying
ad_infocolumn entitytype varchar 40 'D'::character varying
ad_infoprocess entitytype varchar 40 'U'::character varying
ad_inforelated entitytype varchar 40 'U'::character varying
ad_infowindow entitytype varchar 40 'D'::character varying
ad_message entitytype varchar 40 'D'::character varying
ad_modelvalidator entitytype varchar 40
ad_process entitytype varchar 40 'D'::character varying
ad_process_para entitytype varchar 40 'D'::character varying
ad_ref_list entitytype varchar 40 'D'::character varying
ad_ref_table entitytype varchar 40 'D'::character varying
ad_reference entitytype varchar 40 'D'::character varying
ad_relationtype entitytype varchar 40  √  'U'::character varying
ad_rule entitytype varchar 40  √  'U'::character varying
ad_searchdefinition entitytype varchar 40 'U'::character varying
ad_statusline entitytype varchar 40 'U'::character varying
ad_statuslineusedin entitytype varchar 40  √  'U'::character varying
ad_style entitytype varchar 40 'U'::character varying
ad_styleline entitytype varchar 40 'U'::character varying
ad_sysconfig entitytype varchar 40 'U'::character varying
ad_tab entitytype varchar 40 'D'::character varying
ad_table entitytype varchar 40 'D'::character varying
ad_tableindex entitytype varchar 40 'U'::character varying
ad_toolbarbutton entitytype varchar 40 'U'::character varying
ad_val_rule entitytype varchar 40 'D'::character varying
ad_viewcolumn entitytype varchar 40 'U'::character varying
ad_viewcomponent entitytype varchar 40 'U'::character varying
ad_window entitytype varchar 40 'D'::character varying
ad_zoomcondition entitytype varchar 40 'U'::character varying
ad_table_scriptvalidator eventmodelvalidator varchar 4
ad_rule eventtype bpchar 1  √  null
ad_process executiontype bpchar 1  √  NULL::bpchar
ad_fieldgroup fieldgrouptype bpchar 1  √  null
ad_attribute fieldlength numeric 10  √  null
ad_column fieldlength numeric 10  √  null
ad_process_para fieldlength numeric 10
ad_column fkconstraintname varchar 30  √  NULL::character varying
ad_column fkconstrainttype bpchar 1  √  'N'::bpchar
ad_column formatpattern varchar 22  √  null
ad_infowindow fromclause varchar 2000
ad_viewcomponent fromclause varchar 2000 NULL::character varying
ad_tab hastree bpchar 1 'N'::bpchar
ad_attribute help varchar 2000  √  null
ad_column help varchar 2000  √  null
ad_element help varchar 2000  √  null
ad_field help varchar 2000  √  null
ad_infocolumn help varchar 2000  √  null
ad_inforelated help varchar 2000  √  NULL::character varying
ad_infowindow help varchar 2000  √  null
ad_modelvalidator help varchar 2000  √  null
ad_process help varchar 2000  √  null
ad_process_para help varchar 2000  √  null
ad_reference help varchar 2000  √  null
ad_rule help varchar 2000  √  null
ad_tab help varchar 2000  √  null
ad_table help varchar 2000  √  null
ad_tableindex help varchar 2000  √  NULL::character varying
ad_userdef_field help varchar 2000  √  null
ad_userdef_info help varchar 2000  √  NULL::character varying
ad_userdef_info_column help varchar 2000  √  NULL::character varying
ad_userdef_info_related help varchar 2000  √  NULL::character varying
ad_userdef_proc help varchar 2000  √  NULL::character varying
ad_userdef_proc_parameter help varchar 2000  √  NULL::character varying
ad_userdef_tab help varchar 2000  √  null
ad_userdef_win help varchar 2000  √  null
ad_viewcolumn help varchar 2000  √  NULL::character varying
ad_viewcomponent help varchar 2000  √  NULL::character varying
ad_window help varchar 2000  √  null
ad_infoprocess imageurl varchar 120  √  NULL::character varying
ad_infowindow imageurl varchar 120  √  NULL::character varying
ad_userdef_info imageurl varchar 120  √  NULL::character varying
ad_tab importfields bpchar 1  √  null
ad_table importtable bpchar 1  √  null
ad_field included_tab_id numeric 10  √  null
ad_tab included_tab_id numeric 10  √  null
ad_column infofactoryclass varchar 255  √  null
ad_field infofactoryclass varchar 255  √  null
ad_styleline inlinestyle varchar 2000
ad_infocolumn inputfieldvalidation varchar 2000  √  NULL::character varying
ad_userdef_info_column inputfieldvalidation varchar 2000  √  NULL::character varying
ad_role isaccessadvanced bpchar 1  √  'N'::bpchar
ad_role isaccessallorgs bpchar 1 'N'::bpchar
ad_attribute isactive bpchar 1 'Y'::bpchar
ad_column isactive bpchar 1 'Y'::bpchar
ad_element isactive bpchar 1 'Y'::bpchar
ad_field isactive bpchar 1 'Y'::bpchar
ad_fieldgroup isactive bpchar 1 'Y'::bpchar
ad_indexcolumn isactive bpchar 1
ad_infocolumn isactive bpchar 1 'Y'::bpchar
ad_infoprocess isactive bpchar 1 'Y'::bpchar
ad_inforelated isactive bpchar 1
ad_infowindow isactive bpchar 1 'Y'::bpchar
ad_language isactive bpchar 1 'N'::bpchar
ad_message isactive bpchar 1 'Y'::bpchar
ad_modelvalidator isactive bpchar 1
ad_process isactive bpchar 1 'Y'::bpchar
ad_process_para isactive bpchar 1 'Y'::bpchar
ad_ref_list isactive bpchar 1 'Y'::bpchar
ad_ref_table isactive bpchar 1 'Y'::bpchar
ad_reference isactive bpchar 1 'Y'::bpchar
ad_relationtype isactive bpchar 1 'Y'::bpchar
ad_role isactive bpchar 1 'Y'::bpchar
ad_rule isactive bpchar 1 'Y'::bpchar
ad_searchdefinition isactive bpchar 1 'Y'::bpchar
ad_statusline isactive bpchar 1 'Y'::bpchar
ad_statuslineusedin isactive bpchar 1 'Y'::bpchar
ad_style isactive bpchar 1 'Y'::bpchar
ad_styleline isactive bpchar 1 'Y'::bpchar
ad_sysconfig isactive bpchar 1 'Y'::bpchar
ad_tab isactive bpchar 1 'Y'::bpchar
ad_tab_customization isactive bpchar 1
ad_table isactive bpchar 1 'Y'::bpchar
ad_table_scriptvalidator isactive bpchar 1 'Y'::bpchar
ad_tableindex isactive bpchar 1
ad_toolbarbutton isactive bpchar 1 'Y'::bpchar
ad_userdef_field isactive bpchar 1 'Y'::bpchar
ad_userdef_info isactive bpchar 1 'Y'::bpchar
ad_userdef_info_column isactive bpchar 1 'Y'::bpchar
ad_userdef_info_related isactive bpchar 1 'Y'::bpchar
ad_userdef_proc isactive bpchar 1 'Y'::bpchar
ad_userdef_proc_parameter isactive bpchar 1 'Y'::bpchar
ad_userdef_tab isactive bpchar 1 'Y'::bpchar
ad_userdef_win isactive bpchar 1 'Y'::bpchar
ad_val_rule isactive bpchar 1 'Y'::bpchar
ad_viewcolumn isactive bpchar 1
ad_viewcomponent isactive bpchar 1
ad_window isactive bpchar 1 'Y'::bpchar
ad_zoomcondition isactive bpchar 1 'Y'::bpchar
ad_toolbarbutton isaddseparator bpchar 1 'N'::bpchar
ad_toolbarbutton isadvancedbutton bpchar 1 'N'::bpchar
ad_field isadvancedfield bpchar 1  √  'N'::bpchar
ad_tab isadvancedtab bpchar 1 'N'::bpchar
ad_tab isallowadvancedlookup bpchar 1  √  'Y'::bpchar
ad_userdef_tab isallowadvancedlookup bpchar 1  √  NULL::bpchar
ad_column isallowcopy bpchar 1 'Y'::bpchar
ad_field isallowcopy bpchar 1  √  NULL::bpchar
ad_column isallowlogging bpchar 1  √  'Y'::bpchar
ad_column isalwaysupdateable bpchar 1 'N'::bpchar
ad_field isalwaysupdateable bpchar 1  √  NULL::bpchar
ad_userdef_field isalwaysupdateable bpchar 1  √  NULL::bpchar
ad_column isautocomplete bpchar 1 'N'::bpchar
ad_infocolumn isautocomplete bpchar 1 'N'::bpchar
ad_process_para isautocomplete bpchar 1 'N'::bpchar
ad_userdef_field isautocomplete bpchar 1  √  NULL::bpchar
ad_userdef_info_column isautocomplete bpchar 1  √  NULL::bpchar
ad_tab_customization isautohideemptycolumn bpchar 1  √  NULL::bpchar
ad_language isbaselanguage bpchar 1 'N'::bpchar
ad_process isbetafunctionality bpchar 1 'N'::bpchar
ad_window isbetafunctionality bpchar 1 'N'::bpchar
ad_role iscanapproveowndoc bpchar 1 'Y'::bpchar
ad_role iscanexport bpchar 1 'Y'::bpchar
ad_role iscanreport bpchar 1 'Y'::bpchar
ad_field iscentrallymaintained bpchar 1 'Y'::bpchar
ad_infocolumn iscentrallymaintained bpchar 1 'Y'::bpchar
ad_process_para iscentrallymaintained bpchar 1 'Y'::bpchar
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar
ad_role ischangelog bpchar 1 'N'::bpchar
ad_table ischangelog bpchar 1 'N'::bpchar
ad_fieldgroup iscollapsedbydefault bpchar 1  √  'N'::bpchar
ad_tableindex iscreateconstraint bpchar 1 'N'::bpchar
ad_toolbarbutton iscustomization bpchar 1 'N'::bpchar
ad_language isdecimalpoint bpchar 1  √  null
ad_infowindow isdefault bpchar 1 'N'::bpchar
ad_searchdefinition isdefault bpchar 1 'N'::bpchar
ad_userdef_win isdefault bpchar 1 'N'::bpchar
ad_window isdefault bpchar 1 'N'::bpchar
ad_field isdefaultfocus bpchar 1 'N'::bpchar
ad_table isdeleteable bpchar 1 'Y'::bpchar
ad_relationtype isdirected bpchar 1 'N'::bpchar
ad_process isdirectprint bpchar 1  √  'N'::bpchar
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar
ad_field isdisplayed bpchar 1 'Y'::bpchar
ad_infocolumn isdisplayed bpchar 1 'Y'::bpchar
ad_userdef_field isdisplayed bpchar 1  √  null
ad_userdef_info_column isdisplayed bpchar 1  √  NULL::bpchar
ad_userdef_proc_parameter isdisplayed bpchar 1  √  null
ad_field isdisplayedgrid bpchar 1  √  'Y'::bpchar
ad_tab_customization isdisplayedgrid bpchar 1  √  NULL::bpchar
ad_userdef_field isdisplayedgrid bpchar 1  √  NULL::bpchar
ad_infowindow isdistinct bpchar 1 'N'::bpchar
ad_attribute isencrypted bpchar 1 'N'::bpchar
ad_column isencrypted bpchar 1 'N'::bpchar
ad_field isencrypted bpchar 1 'N'::bpchar
ad_process_para isencrypted bpchar 1 'N'::bpchar
ad_attribute isfieldonly bpchar 1 'N'::bpchar
ad_field isfieldonly bpchar 1 'N'::bpchar
ad_attribute isheading bpchar 1 'N'::bpchar
ad_field isheading bpchar 1 'N'::bpchar
ad_table ishighvolume bpchar 1 'N'::bpchar
ad_column ishtml bpchar 1  √  'N'::bpchar
ad_column isidentifier bpchar 1 'N'::bpchar
ad_infocolumn isidentifier bpchar 1 'N'::bpchar
ad_tab isinfotab bpchar 1  √  'N'::bpchar
ad_tab isinsertrecord bpchar 1 'Y'::bpchar
ad_column iskey bpchar 1 'N'::bpchar
ad_infocolumn iskey bpchar 1  √  NULL::bpchar
ad_tableindex iskey bpchar 1 'N'::bpchar
ad_infowindow isloadpagenum bpchar 1  √  'Y'::bpchar
ad_language isloginlocale bpchar 1  √  'N'::bpchar
ad_tab islookuponlyselection bpchar 1  √  'N'::bpchar
ad_userdef_tab islookuponlyselection bpchar 1  √  NULL::bpchar
ad_attribute ismandatory bpchar 1 'N'::bpchar
ad_column ismandatory bpchar 1 'N'::bpchar
ad_field ismandatory bpchar 1  √  null
ad_infocolumn ismandatory bpchar 1 'N'::bpchar
ad_process_para ismandatory bpchar 1 'N'::bpchar
ad_userdef_field ismandatory bpchar 1  √  NULL::bpchar
ad_userdef_info_column ismandatory bpchar 1  √  NULL::bpchar
ad_userdef_proc_parameter ismandatory bpchar 1  √  NULL::bpchar
ad_role ismanual bpchar 1 'Y'::bpchar
ad_role ismasterrole bpchar 1 'N'::bpchar
ad_role ismenuautoexpand bpchar 1 'N'::bpchar
ad_userdef_tab ismultirowonly bpchar 1 'N'::bpchar
ad_reference isorderbyvalue bpchar 1  √  'N'::bpchar
ad_column isparent bpchar 1 'N'::bpchar
ad_role ispersonalaccess bpchar 1 'N'::bpchar
ad_role ispersonallock bpchar 1 'N'::bpchar
ad_infocolumn isquerycriteria bpchar 1 'N'::bpchar
ad_userdef_info_column isquerycriteria bpchar 1  √  NULL::bpchar
ad_field isquickentry bpchar 1 'N'::bpchar
ad_field isquickform bpchar 1 'N'::bpchar
ad_tab_customization isquickform bpchar 1  √  'N'::bpchar
ad_process_para isrange bpchar 1 'N'::bpchar
ad_userdef_proc_parameter isrange bpchar 1  √  NULL::bpchar
ad_attribute isreadonly bpchar 1 'N'::bpchar
ad_field isreadonly bpchar 1 'N'::bpchar
ad_infocolumn isreadonly bpchar 1 'Y'::bpchar
ad_tab isreadonly bpchar 1 'N'::bpchar
ad_userdef_field isreadonly bpchar 1  √  null
ad_userdef_info_column isreadonly bpchar 1  √  NULL::bpchar
ad_userdef_tab isreadonly bpchar 1  √  null
ad_userdef_win isreadonly bpchar 1 'N'::bpchar
ad_process isreport bpchar 1 'Y'::bpchar
ad_attribute issameline bpchar 1 'N'::bpchar
ad_field issameline bpchar 1 'N'::bpchar
ad_userdef_field issameline bpchar 1  √  null
ad_column issecure bpchar 1 'N'::bpchar
ad_table issecurityenabled bpchar 1 'N'::bpchar
ad_column isselectioncolumn bpchar 1 'N'::bpchar
ad_field isselectioncolumn bpchar 1  √  NULL::bpchar
ad_process isserverprocess bpchar 1  √  null
ad_role isshowacct bpchar 1 'Y'::bpchar
ad_infowindow isshowindashboard bpchar 1 'Y'::bpchar
ad_userdef_info isshowindashboard bpchar 1  √  NULL::bpchar
ad_toolbarbutton isshowmore bpchar 1  √  'N'::bpchar
ad_tab issinglerow bpchar 1 'Y'::bpchar
ad_userdef_tab issinglerow bpchar 1  √  null
ad_tab issorttab bpchar 1 'N'::bpchar
ad_window issotrx bpchar 1 'Y'::bpchar
ad_statuslineusedin isstatusline bpchar 1 'Y'::bpchar
ad_column issyncdatabase bpchar 1  √  'N'::bpchar
ad_language issystemlanguage bpchar 1 'N'::bpchar
ad_column istoolbarbutton bpchar 1 'Y'::bpchar
ad_field istoolbarbutton bpchar 1  √  null
ad_userdef_field istoolbarbutton bpchar 1  √  null
ad_column istranslated bpchar 1 'N'::bpchar
ad_tab istranslationtab bpchar 1 'N'::bpchar
ad_viewcomponent isunionall bpchar 1 'N'::bpchar
ad_tableindex isunique bpchar 1 'N'::bpchar
ad_attribute isupdateable bpchar 1 'Y'::bpchar
ad_column isupdateable bpchar 1 'Y'::bpchar
ad_field isupdateable bpchar 1  √  NULL::bpchar
ad_userdef_field isupdateable bpchar 1  √  null
ad_userdef_proc isuserupdateable bpchar 1  √  NULL::bpchar
ad_userdef_win isuserupdateable bpchar 1 'Y'::bpchar
ad_role isuseuserorgaccess bpchar 1 'N'::bpchar
ad_infowindow isvalid bpchar 1 'N'::bpchar
ad_ref_table isvaluedisplayed bpchar 1 'N'::bpchar
ad_table isview bpchar 1 'N'::bpchar
ad_process jasperreport varchar 255  √  null
ad_toolbarbutton keystroke_keycode numeric 10  √  NULL::numeric
ad_toolbarbutton keystroke_modifiers numeric 10  √  NULL::numeric
ad_language languageiso bpchar 2  √  null
ad_infoprocess layouttype varchar 10 'B'::character varying
ad_styleline line numeric 10
ad_table loadseq numeric 10  √  null
ad_column mandatorylogic varchar 2000  √  null
ad_field mandatorylogic varchar 2000  √  NULL::character varying
ad_process_para mandatorylogic varchar 2000  √  NULL::character varying
ad_userdef_field mandatorylogic varchar 2000  √  NULL::character varying
ad_userdef_proc_parameter mandatorylogic varchar 2000  √  NULL::character varying
ad_infowindow maxqueryrecords numeric 10 (0)::numeric
ad_role maxqueryrecords numeric 10 0
ad_tab maxqueryrecords numeric 10  √  '0'::numeric
ad_modelvalidator modelvalidationclass varchar 255
ad_message msgtext varchar 2000
ad_message msgtip varchar 2000  √  null
ad_message msgtype bpchar 1
ad_attribute name varchar 60
ad_column name varchar 60
ad_element name varchar 60
ad_field name varchar 60
ad_fieldgroup name varchar 60
ad_infocolumn name varchar 60
ad_inforelated name varchar 60
ad_infowindow name varchar 60
ad_language name varchar 60
ad_modelvalidator name varchar 60
ad_process name varchar 60
ad_process_para name varchar 60
ad_ref_list name varchar 60
ad_reference name varchar 60
ad_relationtype name varchar 60
ad_role name varchar 60
ad_rule name varchar 60
ad_searchdefinition name varchar 60  √  null
ad_statusline name varchar 60
ad_style name varchar 60
ad_sysconfig name varchar 50
ad_tab name varchar 60
ad_table name varchar 60
ad_tableindex name varchar 50
ad_toolbarbutton name varchar 60
ad_userdef_field name varchar 60  √  null
ad_userdef_info name varchar 60  √  NULL::character varying
ad_userdef_info_column name varchar 60  √  NULL::character varying
ad_userdef_info_related name varchar 60  √  NULL::character varying
ad_userdef_proc name varchar 60  √  NULL::character varying
ad_userdef_proc_parameter name varchar 60  √  NULL::character varying
ad_userdef_tab name varchar 60  √  null
ad_userdef_win name varchar 60  √  null
ad_val_rule name varchar 60
ad_viewcomponent name varchar 50
ad_window name varchar 60
ad_zoomcondition name varchar 60
ad_field numlines numeric 10  √  (1)::numeric
ad_userdef_field numlines numeric 10  √  NULL::numeric
ad_field obscuretype bpchar 3  √  null
ad_infowindow orderbyclause varchar 2000  √  NULL::character varying
ad_ref_table orderbyclause varchar 2000  √  null
ad_tab orderbyclause varchar 2000  √  null
ad_userdef_tab orderbyclause varchar 2000  √  NULL::character varying
ad_infowindow otherclause varchar 2000  √  null
ad_viewcomponent otherclause varchar 2000  √  NULL::character varying
ad_role overwritepricelimit bpchar 1 'N'::bpchar
ad_column pa_dashboardcontent_id numeric 10  √  NULL::numeric
ad_userdef_field pa_dashboardcontent_id numeric 10  √  NULL::numeric
ad_infowindow pagingsize numeric 10 '0'::numeric
ad_tab parent_column_id numeric 10  √  NULL::numeric
ad_inforelated parentrelatedcolumn_id numeric 10  √  NULL::numeric
ad_column placeholder varchar 255  √  NULL::character varying
ad_element placeholder varchar 255  √  NULL::character varying
ad_field placeholder varchar 255  √  NULL::character varying
ad_infocolumn placeholder varchar 255  √  NULL::character varying
ad_process_para placeholder varchar 255  √  NULL::character varying
ad_userdef_field placeholder varchar 255  √  NULL::character varying
ad_userdef_info_column placeholder varchar 255  √  NULL::character varying
ad_userdef_proc_parameter placeholder varchar 255  √  NULL::character varying
ad_process_para placeholder2 varchar 255  √  NULL::character varying
ad_userdef_proc_parameter placeholder2 varchar 255  √  NULL::character varying
ad_element po_description varchar 255  √  null
ad_element po_help varchar 2000  √  null
ad_element po_name varchar 60  √  null
ad_element po_printname varchar 60  √  null
ad_searchdefinition po_window_id numeric 10  √  null
ad_table po_window_id numeric 10  √  null
ad_window predefinedcontextvariables varchar 4000  √  NULL::character varying
ad_role preferencetype bpchar 1 'C'::bpchar
ad_element printname varchar 60
ad_language printname varchar 60 NULL::character varying
ad_process procedurename varchar 60  √  null
ad_infowindow processing bpchar 1  √  null
ad_language processing bpchar 1  √  null
ad_tab processing bpchar 1  √  null
ad_table processing bpchar 1  √  NULL::bpchar
ad_tableindex processing bpchar 1  √  NULL::bpchar
ad_window processing bpchar 1  √  null
ad_process_para query varchar 2000  √  NULL::character varying
ad_searchdefinition query varchar 2000  √  null
ad_infocolumn queryfunction varchar 255  √  NULL::character varying
ad_userdef_info_column queryfunction varchar 2000  √  NULL::character varying
ad_infocolumn queryoperator varchar 10  √  NULL::character varying
ad_userdef_info_column queryoperator varchar 10  √  NULL::character varying
ad_column readonlylogic varchar 2000  √  null
ad_field readonlylogic varchar 2000  √  NULL::character varying
ad_process_para readonlylogic varchar 2000  √  null
ad_tab readonlylogic varchar 2000  √  null
ad_userdef_field readonlylogic varchar 2000  √  NULL::character varying
ad_userdef_proc_parameter readonlylogic varchar 2000  √  NULL::character varying
ad_userdef_tab readonlylogic varchar 2000  √  NULL::character varying
ad_attribute_value record_id numeric 10
ad_viewcomponent referenced_table_id numeric 10  √  NULL::numeric
ad_inforelated relatedcolumn_id numeric 10 (0)::numeric
ad_inforelated relatedinfo_id numeric 10 (0)::numeric
ad_table replicationtype bpchar 1 'L'::bpchar
ad_relationtype role_source varchar 50  √  null
ad_relationtype role_target varchar 50  √  null
ad_role roletype varchar 2  √  NULL::character varying
ad_rule ruletype bpchar 1  √  null
ad_rule script varchar 4000  √  null
ad_searchdefinition searchtype varchar 1
ad_infocolumn selectclause varchar 2000
ad_attribute seqno numeric 10  √  null
ad_column seqno numeric 10  √  null
ad_field seqno numeric 10  √  null
ad_indexcolumn seqno numeric 10  √  NULL::numeric
ad_infocolumn seqno numeric 10 0
ad_infoprocess seqno numeric 10
ad_inforelated seqno numeric 10
ad_infowindow seqno numeric 10  √  NULL::numeric
ad_modelvalidator seqno numeric 10  √  null
ad_process_para seqno numeric 10
ad_statuslineusedin seqno numeric 10  √  NULL::numeric
ad_tab seqno numeric 10
ad_table_scriptvalidator seqno numeric 10 0
ad_toolbarbutton seqno numeric 10  √  NULL::numeric
ad_userdef_field seqno numeric 10 (0)::numeric
ad_userdef_info seqno numeric 10 '0'::numeric
ad_userdef_info_column seqno numeric 10  √  null
ad_userdef_info_related seqno numeric 10  √  null
ad_userdef_proc_parameter seqno numeric 10  √  NULL::numeric
ad_userdef_tab seqno numeric 10  √  NULL::numeric
ad_viewcolumn seqno numeric 10  √  NULL::numeric
ad_viewcomponent seqno numeric 10  √  NULL::numeric
ad_zoomcondition seqno numeric 10  √  NULL::numeric
ad_field seqnogrid numeric 10  √  NULL::numeric
ad_userdef_field seqnogrid numeric 10 '0'::numeric
ad_column seqnoselection numeric 10  √  NULL::numeric
ad_infocolumn seqnoselection numeric 10  √  (0)::numeric
ad_userdef_info_column seqnoselection numeric 10  √  '0'::numeric
ad_process showhelp bpchar 1  √  'Y'::bpchar
ad_field sortno numeric 10  √  null
ad_userdef_field sortno numeric 10 0
ad_statusline sqlstatement varchar 2000
ad_process statistic_count numeric 10  √  null
ad_process statistic_seconds numeric 0  √  null
ad_role supervisor_id numeric 10  √  null
ad_tableindex tableindexdrop bpchar 1  √  NULL::bpchar
ad_table tablename varchar 40
ad_tab tablevel numeric 10
ad_styleline theme varchar 60  √  NULL::character varying
ad_language timepattern varchar 20  √  null
ad_window titlelogic varchar 255  √  NULL::character varying
ad_searchdefinition transactioncode varchar 8  √  null
ad_tab treedisplayedon bpchar 1 'B'::bpchar
ad_relationtype type bpchar 1 'I'::bpchar
ad_val_rule type bpchar 1  √  null
ad_attribute updated timestamp 29,6 now()
ad_column updated timestamp 29,6 now()
ad_element updated timestamp 29,6 now()
ad_field updated timestamp 29,6 now()
ad_fieldgroup updated timestamp 29,6 now()
ad_indexcolumn updated timestamp 29,6 statement_timestamp()
ad_infocolumn updated timestamp 29,6 now()
ad_infoprocess updated timestamp 29,6 statement_timestamp()
ad_inforelated updated timestamp 29,6
ad_infowindow updated timestamp 29,6 now()
ad_language updated timestamp 29,6 now()
ad_message updated timestamp 29,6 now()
ad_modelvalidator updated timestamp 29,6 statement_timestamp()
ad_process updated timestamp 29,6 now()
ad_process_para updated timestamp 29,6 now()
ad_ref_list updated timestamp 29,6 now()
ad_ref_table updated timestamp 29,6 now()
ad_reference updated timestamp 29,6 now()
ad_relationtype updated timestamp 29,6 statement_timestamp()
ad_role updated timestamp 29,6 now()
ad_rule updated timestamp 29,6 statement_timestamp()
ad_searchdefinition updated timestamp 29,6 statement_timestamp()
ad_statusline updated timestamp 29,6
ad_statuslineusedin updated timestamp 29,6
ad_style updated timestamp 29,6 statement_timestamp()
ad_styleline updated timestamp 29,6 statement_timestamp()
ad_sysconfig updated timestamp 29,6 statement_timestamp()
ad_tab updated timestamp 29,6 now()
ad_tab_customization updated timestamp 29,6 statement_timestamp()
ad_table updated timestamp 29,6 now()
ad_table_scriptvalidator updated timestamp 29,6 statement_timestamp()
ad_tableindex updated timestamp 29,6 statement_timestamp()
ad_toolbarbutton updated timestamp 29,6 statement_timestamp()
ad_userdef_field updated timestamp 29,6 now()
ad_userdef_info updated timestamp 29,6 statement_timestamp()
ad_userdef_info_column updated timestamp 29,6 statement_timestamp()
ad_userdef_info_related updated timestamp 29,6 statement_timestamp()
ad_userdef_proc updated timestamp 29,6
ad_userdef_proc_parameter updated timestamp 29,6
ad_userdef_tab updated timestamp 29,6 now()
ad_userdef_win updated timestamp 29,6 now()
ad_val_rule updated timestamp 29,6 now()
ad_viewcolumn updated timestamp 29,6 statement_timestamp()
ad_viewcomponent updated timestamp 29,6 statement_timestamp()
ad_window updated timestamp 29,6 now()
ad_zoomcondition updated timestamp 29,6 statement_timestamp()
ad_attribute updatedby numeric 10
ad_column updatedby numeric 10
ad_element updatedby numeric 10
ad_field updatedby numeric 10
ad_fieldgroup updatedby numeric 10
ad_indexcolumn updatedby numeric 10
ad_infocolumn updatedby numeric 10
ad_infoprocess updatedby numeric 10
ad_inforelated updatedby numeric 10
ad_infowindow updatedby numeric 10
ad_language updatedby numeric 10
ad_message updatedby numeric 10
ad_modelvalidator updatedby numeric 10
ad_process updatedby numeric 10
ad_process_para updatedby numeric 10
ad_ref_list updatedby numeric 10
ad_ref_table updatedby numeric 10
ad_reference updatedby numeric 10
ad_relationtype updatedby numeric 10
ad_role updatedby numeric 10
ad_rule updatedby numeric 10
ad_searchdefinition updatedby numeric 10
ad_statusline updatedby numeric 10
ad_statuslineusedin updatedby numeric 10
ad_style updatedby numeric 10
ad_styleline updatedby numeric 10
ad_sysconfig updatedby numeric 10
ad_tab updatedby numeric 10
ad_tab_customization updatedby numeric 10
ad_table updatedby numeric 10
ad_table_scriptvalidator updatedby numeric 10
ad_tableindex updatedby numeric 10
ad_toolbarbutton updatedby numeric 10
ad_userdef_field updatedby numeric 10
ad_userdef_info updatedby numeric 10
ad_userdef_info_column updatedby numeric 10
ad_userdef_info_related updatedby numeric 10
ad_userdef_proc updatedby numeric 10
ad_userdef_proc_parameter updatedby numeric 10
ad_userdef_tab updatedby numeric 10
ad_userdef_win updatedby numeric 10
ad_val_rule updatedby numeric 10
ad_viewcolumn updatedby numeric 10
ad_viewcomponent updatedby numeric 10
ad_window updatedby numeric 10
ad_zoomcondition updatedby numeric 10
ad_role userdiscount numeric 22,2  √  null
ad_role userlevel bpchar 3 ' O'::bpchar
ad_attribute_value v_date timestamp 29,6  √  null
ad_attribute_value v_number numeric 0  √  null
ad_attribute_value v_string varchar 2000  √  null
ad_reference validationtype bpchar 1
ad_ref_list validfrom timestamp 29,6  √  null
ad_ref_list validto timestamp 29,6  √  null
ad_message value varchar 255
ad_process value varchar 40
ad_ref_list value varchar 60
ad_rule value varchar 40
ad_sysconfig value varchar 4000
ad_attribute valuemax varchar 20  √  null
ad_column valuemax varchar 20  √  null
ad_process_para valuemax varchar 20  √  null
ad_userdef_proc_parameter valuemax varchar 20  √  NULL::character varying
ad_attribute valuemin varchar 20  √  null
ad_column valuemin varchar 20  √  null
ad_process_para valuemin varchar 20  √  null
ad_userdef_proc_parameter valuemin varchar 20  √  NULL::character varying
ad_column version numeric 0
ad_attribute vformat varchar 60  √  null
ad_column vformat varchar 255  √  null
ad_field vformat varchar 255  √  NULL::character varying
ad_process_para vformat varchar 255  √  null
ad_reference vformat varchar 40  √  null
ad_userdef_field vformat varchar 255  √  NULL::character varying
ad_userdef_proc_parameter vformat varchar 40  √  NULL::character varying
ad_infowindow whereclause varchar 2000  √  NULL::character varying
ad_ref_table whereclause varchar 2000  √  null
ad_tab whereclause varchar 2000  √  null
ad_userdef_tab whereclause varchar 2000  √  NULL::character varying
ad_viewcomponent whereclause varchar 2000  √  NULL::character varying
ad_zoomcondition whereclause varchar 2000  √  null
ad_window windowtype bpchar 1  √  null
ad_window winheight numeric 10  √  null
ad_window winwidth numeric 10  √  null
ad_process workflowvalue varchar 40  √  null
ad_field xposition numeric 10  √  (1)::numeric
ad_userdef_field xposition numeric 10  √  NULL::numeric
ad_zoomcondition zoomlogic varchar 2000  √  NULL::character varying