Tables


SchemaSpy Analysis of idempiere.adempiere

Generated on Tue Jan 02 08:57 CET 2018

XML Representation
Insertion Order Deletion Order
TABLES 851
VIEWS 152
COLUMNS 29139
Constraints 3430

Database Properties

Database Type: PostgreSQL - 9.6.6

Tables

Table / View Children Parents Columns Rows Type Comments
a_asset 16 16 69 0 Table
a_asset_acct 3 21 50 0 Table
a_asset_addition 0 15 52 0 Table
a_asset_change 0 17 79 0 Table
a_asset_change_amt 0 2 13 0 Table
a_asset_class 0 0 20 0 Table
a_asset_delivery 1 4 25 0 Table
a_asset_disposed 0 6 39 0 Table
a_asset_group 3 2 21 9 Table
a_asset_group_acct 0 20 53 0 Table
a_asset_group_trl 0 6 14 9 Table
a_asset_info_fin 0 2 22 0 Table
a_asset_info_ins 0 1 17 0 Table
a_asset_info_lic 0 1 17 0 Table
a_asset_info_oth 0 1 26 0 Table
a_asset_info_tax 0 1 16 0 Table
a_asset_product 0 4 15 0 Table
a_asset_retirement 0 2 13 0 Table
a_asset_reval 0 1 24 0 Table
a_asset_reval_entry 0 5 26 0 Table
a_asset_reval_index 0 0 13 0 Table
a_asset_split 0 4 26 0 Table
a_asset_spread 0 0 25 2 Table
a_asset_transfer 0 14 52 0 Table
a_asset_type 0 0 15 0 Table
a_asset_use 0 1 13 0 Table
a_depreciation 0 0 15 11 Table
a_depreciation_build 0 3 18 0 Table
a_depreciation_convention 0 0 15 6 Table
a_depreciation_entry 0 5 27 0 Table
a_depreciation_exp 0 7 37 0 Table
a_depreciation_forecast 0 2 15 0 Table
a_depreciation_method 0 0 14 3 Table
a_depreciation_table_detail 0 0 14 2579 Table
a_depreciation_table_header 0 0 14 122 Table
a_depreciation_workfile 1 2 44 0 Table
a_fundingmode 0 0 12 0 Table
a_fundingmode_acct 0 2 11 0 Table
a_registration 0 4 24 0 Table
a_registrationattribute 0 2 16 0 Table
a_registrationproduct 0 2 11 0 Table
a_registrationvalue 0 2 12 0 Table
ad_accesslog 0 2 17 0 Table
ad_alert 0 1 18 1 Table
ad_alertprocessor 0 2 19 1 Table
ad_alertprocessorlog 0 1 16 3 Table
ad_alertrecipient 0 3 12 1 Table
ad_alertrule 0 2 20 1 Table
ad_archive 0 3 18 0 Table
ad_attachment 0 1 14 3 Table
ad_attachmentnote 0 2 13 0 Table
ad_attribute 0 4 32 0 Table
ad_attribute_value 0 1 6 0 Table
ad_broadcastmessage 0 3 24 0 Table
ad_broadcastmessage_trl 0 6 12 0 Table
ad_changelog 0 3 21 2855 Table
ad_changelog_v 0 1 9 0 View
ad_chart 2 1 21 4 Table
ad_chart_trl 0 6 15 4 Table
ad_chartdatasource 0 3 22 6 Table
ad_client 0 3 40 4 Table
ad_clientinfo 0 23 35 4 Table
ad_clientshare 0 3 13 0 Table
ad_color 1 1 26 0 Table
ad_color_trl 0 6 12 0 Table
ad_column 5 11 53 24680 Table
ad_column_access 0 3 13 0 Table
ad_column_trl 0 2 12 24680 Table
ad_ctxhelp 0 7 19 0 Table
ad_ctxhelpmsg 0 1 12 0 Table
ad_ctxhelpmsg_trl 0 2 12 0 Table
ad_desktop 0 2 14 1 Table
ad_desktop_trl 0 2 14 1 Table
ad_desktopworkbench 0 2 12 1 Table
ad_document_action_access 0 3 11 4018 Table
ad_element 0 1 19 5576 Table
ad_element_trl 0 2 19 5576 Table
ad_entitytype 0 0 17 11 Table
ad_error 0 1 12 0 Table
ad_field 2 12 52 19580 Table
ad_field_trl 0 2 14 19580 Table
ad_field_v 0 9 65 0 View
ad_field_vt 0 10 66 0 View
ad_fieldgroup 0 1 13 69 Table
ad_fieldgroup_trl 0 2 12 69 Table
ad_find 0 1 15 0 Table
ad_form 1 2 18 41 Table
ad_form_access 0 2 11 206 Table
ad_form_trl 0 2 14 41 Table
ad_housekeeping 0 1 21 9 Table
ad_image 3 1 14 11 Table
ad_impformat 0 1 15 15 Table
ad_impformat_row 0 2 22 163 Table
ad_importtemplate 0 6 16 0 Table
ad_importtemplateaccess 0 6 14 0 Table
ad_indexcolumn 0 3 14 1300 Table
ad_infocolumn 0 6 32 113 Table
ad_infocolumn_trl 0 2 14 113 Table
ad_infoprocess 0 3 16 0 Table
ad_inforelated 0 8 17 0 Table
ad_infowindow 1 4 29 8 Table
ad_infowindow_access 0 2 10 64 Table
ad_infowindow_trl 0 2 14 8 Table
ad_issue 0 9 50 124 Table
ad_labelprinter 0 0 11 0 Table
ad_labelprinterfunction 0 1 16 0 Table
ad_language 55 3 22 109 Table
ad_ldapaccess 0 3 15 0 Table
ad_ldapprocessor 0 1 17 1 Table
ad_ldapprocessorlog 0 1 16 0 Table
ad_menu 0 10 24 751 Table
ad_menu_trl 0 2 13 751 Table
ad_message 0 3 14 1663 Table
ad_message_trl 0 2 13 1663 Table
ad_migrationscript 0 0 21 336 Table
ad_modelvalidator 0 1 15 3 Table
ad_modification 0 1 15 0 Table
ad_note 0 5 20 18 Table
ad_org 0 2 13 12 Table
ad_org_v 0 4 19 0 View
ad_orginfo 0 12 26 12 Table
ad_orgtype 13 1 12 3 Table
ad_package_exp 0 0 23 0 Table
ad_package_exp_common 0 10 32 0 Table
ad_package_exp_detail 0 16 42 0 Table
ad_package_imp 1 1 24 0 Table
ad_package_imp_backup 0 5 18 0 Table
ad_package_imp_detail 1 2 19 0 Table
ad_package_imp_inst 0 0 23 0 Table
ad_package_imp_proc 0 0 17 0 Table
ad_package_uuid_map 0 1 12 0 Table
ad_password_history 0 5 13 0 Table
ad_passwordrule 0 0 27 0 Table
ad_pinstance 12 3 22 175 Table
ad_pinstance_log 0 2 9 16 Table
ad_pinstance_para 0 1 19 69 Table
ad_preference 0 6 16 56 Table
ad_printcolor 2 0 12 20 Table
ad_printcolor_trl 0 6 12 20 Table
ad_printfont 2 0 12 66 Table
ad_printform 0 15 25 4 Table
ad_printformat 1 8 29 109 Table
ad_printformat_trl 0 2 13 109 Table
ad_printformatitem 1 6 63 3785 Table
ad_printformatitem_trl 0 2 14 3785 Table
ad_printgraph 1 7 19 0 Table
ad_printlabel 0 2 17 0 Table
ad_printlabelline 0 3 18 0 Table
ad_printlabelline_trl 0 2 12 0 Table
ad_printpaper 1 0 22 4 Table
ad_printtableformat 1 9 39 2 Table
ad_private_access 0 2 11 0 Table
ad_process 5 6 32 426 Table
ad_process_access 0 4 11 2258 Table
ad_process_para 0 6 33 1029 Table
ad_process_para_trl 0 2 14 1029 Table
ad_process_trl 0 2 14 426 Table
ad_recentitem 0 5 15 17 Table
ad_record_access 0 2 14 0 Table
ad_ref_list 0 4 16 1365 Table
ad_ref_list_trl 0 2 13 1365 Table
ad_ref_table 0 9 18 208 Table
ad_reference 0 3 16 515 Table
ad_reference_trl 0 2 14 515 Table
ad_registration 0 4 26 0 Table
ad_relationtype 0 2 17 5 Table
ad_replication 0 3 24 1 Table
ad_replication_log 0 2 13 0 Table
ad_replication_run 0 1 13 0 Table
ad_replicationdocument 0 3 14 1 Table
ad_replicationstrategy 1 2 15 2 Table
ad_replicationtable 0 3 14 473 Table
ad_reportview 1 2 15 102 Table
ad_reportview_col 0 2 13 0 Table
ad_reportview_column 0 6 10 0 Table
ad_role 1 6 53 8 Table
ad_role_included 0 2 11 0 Table
ad_role_orgaccess 0 2 10 24 Table
ad_rule 0 1 18 4 Table
ad_schedule 0 0 20 5 Table
ad_scheduler 0 5 28 10 Table
ad_scheduler_para 0 2 13 11 Table
ad_schedulerlog 0 1 16 10 Table
ad_schedulerrecipient 0 3 12 1 Table
ad_searchdefinition 0 4 20 2 Table
ad_sequence 0 2 27 1691 Table
ad_sequence_audit 0 4 12 0 Table
ad_sequence_no 0 3 11 0 Table
ad_session 2 1 17 270 Table
ad_sessioninfo_v 0 1 21 0 View
ad_statusline 0 6 13 4 Table
ad_statuslineusedin 0 8 15 13 Table
ad_storageprovider 0 0 15 0 Table
ad_style 0 0 11 1 Table
ad_styleline 0 1 14 1 Table
ad_sysconfig 0 1 14 100 Table
ad_system 0 0 43 1 Table
ad_tab 5 13 41 1064 Table
ad_tab_customization 0 2 13 0 Table
ad_tab_trl 0 2 15 1064 Table
ad_tab_v 0 6 39 0 View
ad_tab_vt 0 7 40 0 View
ad_table 12 6 31 950 Table
ad_table_access 0 4 15 1 Table
ad_table_scriptvalidator 0 2 13 0 Table
ad_table_trl 0 2 12 950 Table
ad_tableindex 0 3 20 1047 Table
ad_task 1 4 17 3 Table
ad_task_access 0 4 11 3 Table
ad_task_trl 0 2 14 3 Table
ad_taskinstance 0 3 10 0 Table
ad_toolbarbutton 0 2 24 55 Table
ad_toolbarbuttonrestrict 0 5 16 0 Table
ad_tree 0 1 18 39 Table
ad_treebar 0 2 13 22 Table
ad_treenode 0 1 12 530 Table
ad_treenodebp 0 1 12 25 Table
ad_treenodecmc 0 1 12 5 Table
ad_treenodecmm 0 1 12 3 Table
ad_treenodecms 0 1 12 5 Table
ad_treenodecmt 0 1 12 5 Table
ad_treenodemm 0 1 12 752 Table
ad_treenodepr 0 1 12 57 Table
ad_treenodeu1 0 1 12 0 Table
ad_treenodeu2 0 1 12 0 Table
ad_treenodeu3 0 1 12 0 Table
ad_treenodeu4 0 1 12 0 Table
ad_user 0 14 63 12 Table
ad_user_orgaccess 0 2 10 0 Table
ad_user_roles 0 4 10 23 Table
ad_user_roles_v 0 0 2 0 View
ad_user_substitute 0 2 15 0 Table
ad_userbpaccess 0 2 13 0 Table
ad_userdef_field 0 8 38 0 Table
ad_userdef_tab 0 2 18 0 Table
ad_userdef_win 0 4 19 0 Table
ad_usermail 0 3 21 1 Table
ad_userpreference 0 5 14 6 Table
ad_userquery 0 3 15 0 Table
ad_val_rule 2 3 14 281 Table
ad_viewcolumn 0 2 17 10 Table
ad_viewcomponent 0 3 19 1 Table
ad_wf_activity 0 7 25 9 Table
ad_wf_activityapprover 0 2 11 0 Table
ad_wf_activityresult 0 1 14 0 Table
ad_wf_block 0 1 12 0 Table
ad_wf_eventaudit 0 5 23 9 Table
ad_wf_nextcondition 0 3 17 1 Table
ad_wf_node 0 17 61 250 Table
ad_wf_node_para 0 3 15 1 Table
ad_wf_node_trl 0 2 14 250 Table
ad_wf_nodenext 0 5 16 196 Table
ad_wf_process 0 8 20 9 Table
ad_wf_processdata 0 1 12 0 Table
ad_wf_responsible 0 4 15 2 Table
ad_window 5 5 23 412 Table
ad_window_access 0 4 11 2013 Table
ad_window_trl 0 2 14 412 Table
ad_window_vt 0 4 13 0 View
ad_wizardprocess 0 2 13 0 Table
ad_workbench 0 4 16 1 Table
ad_workbench_trl 0 2 14 1 Table
ad_workbenchwindow 0 6 17 2 Table
ad_workflow 8 9 48 55 Table
ad_workflow_access 0 4 11 304 Table
ad_workflow_trl 0 2 14 55 Table
ad_workflowprocessor 0 2 22 1 Table
ad_workflowprocessorlog 0 1 16 16 Table
ad_zoomcondition 0 2 16 6 Table
asp_clientexception 0 9 19 0 Table
asp_clientlevel 0 2 12 0 Table
asp_field 0 2 12 0 Table
asp_form 0 2 12 0 Table
asp_level 0 1 15 0 Table
asp_module 0 0 13 0 Table
asp_process 0 2 12 0 Table
asp_process_para 0 2 12 0 Table
asp_ref_list 0 3 13 0 Table
asp_tab 0 2 14 0 Table
asp_task 0 2 12 0 Table
asp_window 0 2 12 0 Table
asp_workflow 0 2 12 0 Table
b_bid 0 4 16 0 Table
b_bidcomment 0 2 12 0 Table
b_buyer 0 1 12 0 Table
b_buyerfunds 0 4 14 0 Table
b_offer 0 4 16 0 Table
b_seller 0 1 13 0 Table
b_sellerfunds 0 4 14 0 Table
b_topic 0 2 22 0 Table
b_topiccategory 0 1 12 0 Table
b_topictype 0 3 16 0 Table
c_1099box 0 0 14 0 Table
c_acctprocessor 0 4 21 3 Table
c_acctprocessorlog 0 1 16 516 Table
c_acctschema 0 6 35 3 Table
c_acctschema_default 0 75 84 3 Table
c_acctschema_element 0 14 26 10 Table
c_acctschema_gl 0 11 22 3 Table
c_activity 55 0 14 2 Table
c_activity_trl 0 6 14 0 Table
c_addresstransaction 0 6 22 0 Table
c_addressvalidation 0 5 17 0 Table
c_addressvalidationcfg 0 4 19 0 Table
c_allocationhdr 1 3 25 3 Table
c_allocationline 1 7 23 3 Table
c_bank 1 1 15 2 Table
c_bankaccount 7 2 22 3 Table
c_bankaccount_acct 0 14 22 3 Table
c_bankaccount_processor 0 3 27 2 Table
c_bankaccountdoc 0 2 15 2 Table
c_bankstatement 0 1 31 2 Table
c_bankstatementline 0 6 42 2 Table
c_bankstatementloader 0 1 28 0 Table
c_bankstatementmatcher 0 0 13 0 Table
c_bp_bankaccount 4 4 36 1 Table
c_bp_customer_acct 0 5 13 23 Table
c_bp_edi 0 3 28 0 Table
c_bp_employee_acct 0 4 12 17 Table
c_bp_group 29 6 23 5 Table
c_bp_group_acct 0 15 24 5 Table
c_bp_relation 0 4 19 1 Table
c_bp_shippingacct 0 3 15 0 Table
c_bp_vendor_acct 0 5 13 23 Table
c_bp_withholding 0 2 13 0 Table
c_bpartner 116 20 74 23 Table
c_bpartner_location 47 5 22 19 Table
c_bpartner_product 0 2 18 1 Table
c_calendar 14 2 11 3 Table
c_campaign 58 1 17 4 Table
c_campaign_trl 0 6 13 2 Table
c_cash 1 8 30 3 Table
c_cashbook 1 1 13 4 Table
c_cashbook_acct 0 7 15 4 Table
c_cashline 6 6 23 5 Table
c_cashplan 0 7 26 0 Table
c_cashplanline 5 12 29 0 Table
c_channel 0 1 12 4 Table
c_charge 41 3 18 2 Table
c_charge_acct 0 4 12 2 Table
c_charge_trl 0 2 13 2 Table
c_chargetype 0 0 13 0 Table
c_chargetype_doctype 0 2 12 0 Table
c_city 10 4 16 1 Table
c_commission 1 3 20 1 Table
c_commissionamt 1 2 14 0 Table
c_commissiondetail 1 4 18 0 Table
c_commissionline 1 7 25 1 Table
c_commissionrun 1 1 16 0 Table
c_contactactivity 0 3 18 1 Table
c_conversion_rate 0 5 16 4 Table
c_conversiontype 26 0 13 4 Table
c_country 11 5 34 247 Table
c_country_trl 0 2 14 247 Table
c_countrygroup 0 4 15 0 Table
c_countrygroup_trl 0 6 13 0 Table
c_countrygroupcountry 0 6 13 0 Table
c_currency 55 2 19 174 Table
c_currency_acct 0 6 14 0 Table
c_currency_trl 0 2 13 174 Table
c_cycle 1 1 12 4 Table
c_cyclephase 0 2 10 10 Table
c_cyclestep 1 1 13 4 Table
c_depositbatch 0 2 20 0 Table
c_depositbatchline 0 2 15 0 Table
c_doctype 41 8 41 144 Table
c_doctype_trl 0 2 14 144 Table
c_doctypecounter 0 2 17 1 Table
c_dunning 27 0 14 2 Table
c_dunning_header_v 0 35 289 0 View
c_dunning_header_vt 0 36 289 0 View
c_dunning_line_v 0 25 163 0 View
c_dunning_line_vt 0 26 163 0 View
c_dunninglevel 13 3 28 2 Table
c_dunninglevel_trl 0 2 13 2 Table
c_dunningrun 2 2 16 0 Table
c_dunningrunentry 4 7 20 0 Table
c_dunningrunline 2 4 23 0 Table
c_element 2 3 16 3 Table
c_elementvalue 3 5 30 489 Table
c_elementvalue_trl 0 2 13 489 Table
c_greeting 49 0 13 1 Table
c_greeting_trl 0 2 13 1 Table
c_interorg_acct 0 5 12 0 Table
c_invoice 34 26 68 9 Table
c_invoice_candidate_v 0 3 8 0 View
c_invoice_header_v 0 48 330 0 View
c_invoice_header_vt 0 49 330 0 View
c_invoice_linetax_v 0 1 244 0 View
c_invoice_linetax_vt 0 2 244 0 View
c_invoice_v 0 14 59 0 View
c_invoice_v1 0 13 51 0 View
c_invoicebatch 0 3 20 0 Table
c_invoicebatchline 0 15 35 0 Table
c_invoiceline 5 23 51 27 Table
c_invoiceline_v 0 11 27 0 View
c_invoicepayschedule 2 2 18 2 Table
c_invoiceschedule 19 0 20 1 Table
c_invoicetax 0 3 15 8 Table
c_job 0 1 14 4 Table
c_jobassignment 0 2 14 0 Table
c_jobcategory 0 0 12 4 Table
c_jobremuneration 0 2 14 0 Table
c_landedcost 0 5 16 0 Table
c_landedcostallocation 0 5 16 0 Table
c_location 22 6 24 39 Table
c_nonbusinessday 0 4 13 1 Table
c_onlinetrxhistory 0 1 14 0 Table
c_opportunity 0 7 24 1 Table
c_order 43 38 92 7 Table
c_order_header_v 0 62 473 0 View
c_order_header_vt 0 63 473 0 View
c_order_linetax_v 0 1 378 0 View
c_order_linetax_vt 0 2 378 0 View
c_orderlandedcost 0 2 15 0 Table
c_orderlandedcostallocation 0 2 15 0 Table
c_orderline 17 25 59 25 Table
c_orderpayschedule 0 2 18 0 Table
c_ordersource 0 4 13 0 Table
c_ordertax 0 3 15 7 Table
c_orgassignment 0 2 13 0 Table
c_payment 26 23 98 2 Table
c_payment_v 0 14 78 0 View
c_paymentallocate 0 3 17 0 Table
c_paymentbatch 6 1 15 0 Table
c_paymentprocessor 0 3 36 2 Table
c_paymentterm 52 0 30 7 Table
c_paymentterm_trl 0 2 14 5 Table
c_paymenttransaction 0 21 79 0 Table
c_payschedule 0 1 17 2 Table
c_payselection 4 1 18 1 Table
c_payselection_check_v 0 29 202 0 View
c_payselection_check_vt 0 30 202 0 View
c_payselection_remittance_v 0 18 79 0 View
c_payselection_remittance_vt 0 19 79 0 View
c_payselectioncheck 4 4 23 1 Table
c_payselectionline 2 3 23 1 Table
c_period 8 3 16 228 Table
c_periodcontrol 0 1 14 6240 Table
c_phase 7 2 16 13 Table
c_pos 4 10 26 1 Table
c_poskey 0 6 22 163 Table
c_poskeylayout 0 2 16 5 Table
c_pospayment 0 3 30 0 Table
c_postendertype 0 0 16 0 Table
c_project 62 16 48 4 Table
c_project_acct 0 4 12 2 Table
c_project_details_v 0 29 132 0 View
c_project_details_vt 0 30 132 0 View
c_project_header_v 0 42 311 0 View
c_project_header_vt 0 43 311 0 View
c_projectissue 9 6 23 0 Table
c_projectissuema 0 2 11 0 Table
c_projectline 3 9 31 1 Table
c_projectphase 12 4 27 0 Table
c_projecttask 13 3 20 0 Table
c_projecttype 7 0 13 4 Table
c_recurring 0 6 26 1 Table
c_recurring_run 0 6 16 0 Table
c_recurringgroup 0 4 13 0 Table
c_region 10 3 13 357 Table
c_region_trl 0 6 12 357 Table
c_remuneration 0 0 18 0 Table
c_revenuerecognition 12 0 14 2 Table
c_revenuerecognition_plan 0 6 17 0 Table
c_revenuerecognition_run 0 2 12 0 Table
c_rfq 4 7 38 1 Table
c_rfq_topic 2 1 13 1 Table
c_rfq_topicsubscriber 0 4 15 2 Table
c_rfq_topicsubscriberonly 0 3 13 0 Table
c_rfqline 2 3 18 2 Table
c_rfqlineqty 4 2 19 2 Table
c_rfqresponse 5 6 31 0 Table
c_rfqresponse_v 0 6 29 0 View
c_rfqresponse_vt 0 7 29 0 View
c_rfqresponseline 4 2 18 0 Table
c_rfqresponseline_v 0 8 31 0 View
c_rfqresponseline_vt 0 9 30 0 View
c_rfqresponselineqty 4 2 14 0 Table
c_rfqresponselineqty_v 0 4 16 0 View
c_rfqresponselineqty_vt 0 5 16 0 View
c_salesdashboard 0 0 10 0 View
c_salesregion 19 1 15 4 Table
c_salesregion_trl 0 6 13 2 Table
c_salesstage 0 0 15 1 Table
c_salesstage_trl 0 6 13 1 Table
c_servicelevel 0 2 16 0 Table
c_servicelevelline 0 1 14 0 Table
c_subacct 4 1 14 0 Table
c_subscription 0 3 17 0 Table
c_subscription_delivery 0 1 10 0 Table
c_subscriptiontype 12 0 13 0 Table
c_task 0 2 16 9 Table
c_tax 11 10 31 8 Table
c_tax_acct 0 7 15 8 Table
c_tax_trl 0 2 14 8 Table
c_taxbase 0 0 15 0 Table
c_taxcategory 12 0 13 3 Table
c_taxcategory_trl 0 2 13 3 Table
c_taxdeclaration 0 0 16 0 Table
c_taxdeclarationacct 0 3 14 0 Table
c_taxdeclarationline 0 7 22 0 Table
c_taxdefinition 0 10 29 0 Table
c_taxgroup 27 0 13 0 Table
c_taxpostal 0 1 12 0 Table
c_taxprovider 0 5 16 0 Table
c_taxprovidercfg 0 4 13 0 Table
c_taxtype 0 0 13 0 Table
c_uom 54 2 17 14 Table
c_uom_conversion 0 5 14 1 Table
c_uom_trl 0 2 14 14 Table
c_userremuneration 0 2 18 0 Table
c_validcombination 1 16 29 198 Table
c_withholding 0 2 23 0 Table
c_withholding_acct 0 3 11 0 Table
c_year 2 3 13 19 Table
cm_accesscontainer 0 2 10 0 Table
cm_accesslistbpgroup 0 2 10 0 Table
cm_accesslistrole 0 2 10 0 Table
cm_accessmedia 0 2 10 0 Table
cm_accessnewschannel 0 2 10 0 Table
cm_accessprofile 0 0 13 0 Table
cm_accessstage 0 2 10 0 Table
cm_ad 0 2 26 0 Table
cm_ad_cat 0 1 13 0 Table
cm_broadcastserver 0 1 15 0 Table
cm_chat 0 2 15 0 Table
cm_chatentry 0 4 18 0 Table
cm_chattype 0 1 13 0 Table
cm_chattypeupdate 0 2 11 0 Table
cm_chatupdate 0 2 11 0 Table
cm_container 0 3 35 5 Table
cm_container_element 0 1 15 6 Table
cm_container_element_trl 0 2 15 6 Table
cm_container_trl 0 2 17 5 Table
cm_container_url 0 1 13 0 Table
cm_containerttable 0 2 16 0 Table
cm_cstage 0 3 37 5 Table
cm_cstage_element 0 1 15 7 Table
cm_cstage_element_trl 0 2 15 7 Table
cm_cstage_trl 0 2 17 5 Table
cm_cstagettable 0 2 16 0 Table
cm_media 0 2 18 3 Table
cm_media_server 0 1 19 1 Table
cm_mediadeploy 0 2 14 0 Table
cm_newschannel 0 2 15 0 Table
cm_newsitem 0 1 16 0 Table
cm_template 0 1 22 4 Table
cm_template_ad_cat 0 2 12 0 Table
cm_templatetable 0 2 15 0 Table
cm_webaccesslog 0 4 27 0 Table
cm_webproject 0 4 21 1 Table
cm_webproject_domain 0 2 15 1 Table
cm_wikitoken 0 1 16 0 Table
cust_hs_client_registration 2 0 31 1 Table
dd_networkdistribution 0 1 20 2 Table
dd_networkdistributionline 0 4 18 10 Table
dd_order 4 17 64 0 Table
dd_order_header_v 0 11 53 0 View
dd_order_header_vt 0 12 53 0 View
dd_orderline 2 15 43 0 Table
dual 0 0 1 1 Table
exp_format 0 1 19 10 Table
exp_formatline 0 3 21 43 Table
exp_processor 0 1 18 2 Table
exp_processor_type 0 0 14 2 Table
exp_processorparameter 0 1 15 7 Table
fact_acct 4 27 47 137 Table
fact_acct_balance 0 7 31 0 View
fact_acct_summary 0 19 34 0 Table
fact_reconciliation 0 1 11 0 Table
gl_budget 7 0 13 1 Table
gl_budgetcontrol 0 2 17 0 Table
gl_category 6 0 14 34 Table
gl_category_trl 0 6 12 34 Table
gl_distribution 0 16 45 1 Table
gl_distributionline 0 15 39 2 Table
gl_fund 0 1 16 0 Table
gl_fundrestriction 0 2 13 0 Table
gl_journal 1 9 36 1 Table
gl_journalbatch 0 5 28 1 Table
gl_journalgenerator 0 5 19 2 Table
gl_journalgeneratorline 0 4 22 6 Table
gl_journalgeneratorsource 0 3 15 8 Table
gl_journalline 1 23 43 2 Table
gl_journalline_acct_v 0 12 37 0 View
hr_attribute 0 8 28 0 Table
hr_concept 0 5 30 0 Table
hr_concept_acct 0 7 17 0 Table
hr_concept_category 0 1 14 0 Table
hr_contract 0 3 18 0 Table
hr_department 0 1 13 0 Table
hr_employee 0 5 22 0 Table
hr_job 0 3 17 0 Table
hr_list 0 4 18 0 Table
hr_listline 0 1 21 0 Table
hr_listtype 0 0 12 0 Table
hr_listversion 0 2 15 0 Table
hr_movement 0 18 39 0 Table
hr_payroll 0 3 18 0 Table
hr_payrollconcept 0 3 17 0 Table
hr_period 0 4 23 0 Table
hr_process 0 13 32 0 Table
hr_year 0 2 16 0 Table
i_asset 0 13 83 0 Table
i_bankstatement 0 8 59 0 Table
i_bpartner 0 8 51 0 Table
i_conversion_rate 0 4 25 2 Table
i_elementvalue 0 4 31 0 Table
i_fajournal 0 27 72 0 Table
i_fixedasset 0 9 48 0 Table
i_gljournal 0 26 70 0 Table
i_hr_movement 0 4 26 0 Table
i_inoutlineconfirm 0 1 19 0 Table
i_inventory 0 8 38 0 Table
i_invoice 0 22 64 0 Table
i_movement 0 12 44 0 Table
i_order 0 26 68 0 Table
i_payment 0 7 71 0 Table
i_pricelist 0 6 34 0 Table
i_product 0 5 55 0 Table
i_productplanning 0 12 52 0 Table
i_reportline 0 4 30 0 Table
imp_processor 0 1 24 2 Table
imp_processor_type 0 0 14 2 Table
imp_processorlog 0 1 17 0 Table
imp_processorparameter 0 1 15 6 Table
k_category 0 0 12 1 Table
k_categoryvalue 0 1 12 0 Table
k_comment 0 2 14 0 Table
k_entry 0 3 19 0 Table
k_entrycategory 0 3 11 0 Table
k_entryrelated 0 2 11 0 Table
k_index 0 4 17 0 Table
k_indexlog 0 0 12 0 Table
k_indexstop 0 3 14 0 Table
k_source 0 0 11 1 Table
k_synonym 0 1 12 0 Table
k_topic 0 1 15 1 Table
k_type 0 0 14 2 Table
m_attribute 0 1 15 4 Table
m_attributeinstance 0 3 13 5 Table
m_attributesearch 0 0 11 1 Table
m_attributeset 23 2 28 4 Table
m_attributesetexclude 0 2 12 0 Table
m_attributesetinstance 40 2 15 4 Table
m_attributeuse 0 2 11 5 Table
m_attributevalue 0 1 13 9 Table
m_bom 0 2 17 1 Table
m_bomalternative 0 1 12 1 Table
m_bomproduct 0 6 23 0 Table
m_bp_price 0 3 22 0 Table
m_changenotice 4 0 16 1 Table
m_changerequest 1 3 19 0 Table
m_commodityshipment 0 2 14 0 Table
m_cost 0 7 23 305 Table
m_costdetail 2 15 33 36 Table
m_costelement 6 0 14 11 Table
m_costhistory 1 4 21 54 Table
m_costmovement_v 0 14 35 0 View
m_costqueue 0 5 16 16 Table
m_costtype 5 0 12 3 Table
m_demand 0 2 16 0 Table
m_demanddetail 0 4 13 0 Table
m_demandline 0 3 14 0 Table
m_discountschema 21 0 19 5 Table
m_discountschemabreak 0 3 16 1 Table
m_discountschemaline 0 5 40 11 Table
m_distributionlist 0 0 14 1 Table
m_distributionlistline 0 3 15 3 Table
m_distributionrun 0 2 15 1 Table
m_distributionrunline 0 3 16 1 Table
m_edi 0 3 27 0 Table
m_edi_info 0 1 10 0 Table
m_forecast 2 3 17 4 Table
m_forecastline 0 5 17 50 Table
m_freight 0 7 18 1 Table
m_freightcategory 16 0 13 2 Table
m_inout 20 26 77 9 Table
m_inout_candidate_v 0 4 12 0 View
m_inout_header_v 0 34 236 0 View
m_inout_header_vt 0 35 236 0 View
m_inout_line_v 0 27 191 0 View
m_inout_line_vt 0 28 191 0 View
m_inout_lineconfirm_v 0 10 40 0 View
m_inout_lineconfirm_vt 0 11 40 0 View
m_inoutconfirm 6 3 25 1 Table
m_inoutconfirm_v 0 8 34 0 View
m_inoutconfirm_vt 0 9 34 0 View
m_inoutline 21 19 39 27 Table
m_inoutlineconfirm 3 4 20 1 Table
m_inoutlinema 0 2 13 0 Table
m_inoutlinema_returned 0 2 14 0 View
m_inoutlinema_v 0 5 14 0 View
m_inoutlinema_vt 0 5 14 0 View
m_inventory 3 13 35 3 Table
m_inventoryline 4 6 25 1 Table
m_inventorylinema 0 2 13 0 Table
m_locator 48 4 17 13 Table
m_locatortype 0 4 15 0 Table
m_lot 11 2 16 0 Table
m_lotctl 0 0 16 1 Table
m_lotctlexclude 0 2 12 0 Table
m_matchinv 1 5 23 18 Table
m_matchpo 0 6 26 35 Table
m_movement 5 16 45 1 Table
m_movement_candidate_v 0 4 12 0 View
m_movementconfirm 0 2 19 0 Table
m_movementline 6 8 24 1 Table
m_movementlineconfirm 0 3 18 0 Table
m_movementlinema 0 2 13 0 Table
m_movementlinema_v 0 5 15 0 View
m_movementlinema_vt 0 5 15 0 View
m_operationresource 0 3 18 0 Table
m_package 1 11 72 1 Table
m_packageline 0 4 15 1 Table
m_packagelines_avail_v 0 3 9 0 View
m_packagemps 1 3 23 0 Table
m_parttype 0 0 11 0 Table
m_perpetualinv 0 2 20 0 Table
m_pricelist 45 2 20 5 Table
m_pricelist_trl 0 6 13 5 Table
m_pricelist_version 6 3 16 7 Table
m_pricelist_version_trl 0 6 12 7 Table
m_product 87 16 70 55 Table
m_product_acct 0 26 34 55 Table
m_product_bom 0 2 15 20 Table
m_product_category 17 3 19 14 Table
m_product_category_acct 0 26 37 14 Table
m_product_category_trl 0 6 13 14 Table
m_product_po 0 6 32 29 Table
m_product_qualitytest 0 2 12 0 Table
m_product_stock_v 0 2 17 0 View
m_product_substituterelated_v 0 3 18 0 View
m_product_trl 0 2 14 55 Table
m_productdownload 0 1 12 1 Table
m_production 3 14 38 0 Table
m_productionline 5 5 21 0 Table
m_productionlinema 0 2 12 0 Table
m_productionplan 1 3 16 0 Table
m_productoperation 0 1 16 0 Table
m_productprice 0 2 14 88 Table
m_productpricevendorbreak 0 3 16 0 Table
m_promotion 2 1 13 0 Table
m_promotiondistribution 0 2 16 0 Table
m_promotiongroup 0 0 11 0 Table
m_promotiongroupline 0 2 11 0 Table
m_promotionline 0 2 13 0 Table
m_promotionprecondition 0 6 21 0 Table
m_promotionreward 0 4 20 0 Table
m_qualitytest 0 0 12 0 Table
m_qualitytestresult 0 2 14 0 Table
m_relatedproduct 0 2 13 1 Table
m_replenish 0 4 16 19 Table
m_requisition 1 4 27 1 Table
m_requisitionline 1 7 21 1 Table
m_rma 15 8 30 1 Table
m_rmaline 6 6 23 1 Table
m_rmatax 0 3 15 0 Table
m_rmatype 0 0 12 1 Table
m_sernoctl 0 0 16 1 Table
m_sernoctlexclude 0 2 12 0 Table
m_shipper 13 3 14 3 Table
m_shippercfg 0 1 19 0 Table
m_shipperlabels 0 2 14 0 Table
m_shipperlabelscfg 0 1 17 0 Table
m_shipperpackaging 0 2 14 0 Table
m_shipperpackagingcfg 0 1 15 0 Table
m_shipperpickuptypes 0 2 13 0 Table
m_shipperpickuptypescfg 0 1 14 0 Table
m_shippingprocessor 0 1 14 0 Table
m_shippingprocessorcfg 0 0 19 0 Table
m_shippingtransaction 0 23 89 0 Table
m_shippingtransactionline 0 4 23 0 Table
m_storage 0 3 16 0 View
m_storageonhand 0 3 14 20 Table
m_storagereservation 0 3 14 0 Table
m_substitute 0 4 12 0 Table
m_transaction 3 9 21 28 Table
m_transaction_v 0 14 24 0 View
m_transactionallocation 0 10 22 0 Table
m_warehouse 59 5 19 13 Table
m_warehouse_acct 0 6 14 13 Table
pa_achievement 0 1 17 0 Table
pa_benchmark 0 0 13 0 Table
pa_benchmarkdata 0 1 14 0 Table
pa_colorschema 0 5 20 2 Table
pa_dashboardcontent 3 6 28 9 Table
pa_dashboardcontent_access 0 7 12 0 Table
pa_dashboardcontent_trl 0 2 14 9 Table
pa_dashboardpreference 0 3 16 32 Table
pa_documentstatus 0 10 23 6 Table
pa_documentstatus_trl 0 2 12 6 Table
pa_goal 1 5 29 4 Table
pa_goalrestriction 0 7 17 0 Table
pa_hierarchy 0 8 20 0 Table
pa_measure 0 6 22 4 Table
pa_measurecalc 0 2 20 6 Table
pa_ratio 0 1 13 1 Table
pa_ratioelement 0 4 20 3 Table
pa_report 0 8 23 3 Table
pa_reportcolumn 0 15 55 17 Table
pa_reportcolumnset 0 0 12 3 Table
pa_reportcube 0 1 31 0 Table
pa_reportline 0 5 26 113 Table
pa_reportlineset 0 0 12 3 Table
pa_reportsource 0 11 36 93 Table
pa_sla_criteria 0 0 14 2 Table
pa_sla_goal 0 2 21 1 Table
pa_sla_measure 0 2 17 1 Table
pp_cost_collector 3 20 47 0 Table
pp_cost_collectorma 0 2 12 0 Table
pp_mrp 0 15 41 56 Table
pp_order 17 17 66 2 Table
pp_order_bom 4 5 26 2 Table
pp_order_bom_header_v 0 13 63 0 View
pp_order_bom_header_vt 0 14 63 0 View
pp_order_bom_trl 0 2 14 2 Table
pp_order_bomline 5 9 44 4 Table
pp_order_bomline_trl 0 2 13 4 Table
pp_order_bomline_v 0 9 45 0 View
pp_order_bomline_vt 0 10 46 0 View
pp_order_cost 0 7 24 0 Table
pp_order_header_v 0 13 66 0 View
pp_order_header_vt 0 14 66 0 View
pp_order_node 2 16 70 2 Table
pp_order_node_asset 0 4 13 0 Table
pp_order_node_product 0 4 17 0 Table
pp_order_node_trl 0 2 14 2 Table
pp_order_node_v 0 5 44 0 View
pp_order_node_vt 0 6 44 0 View
pp_order_nodenext 0 6 19 0 Table
pp_order_workflow 3 9 47 2 Table
pp_order_workflow_header_v 0 11 71 0 View
pp_order_workflow_header_vt 0 12 72 0 View
pp_order_workflow_trl 0 2 14 2 Table
pp_product_bom 13 4 25 7 Table
pp_product_bom_trl 0 2 14 7 Table
pp_product_bomline 5 5 32 21 Table
pp_product_bomline_trl 0 2 13 21 Table
pp_product_bomline_v 0 6 31 0 View
pp_product_bomline_vt 0 7 31 0 View
pp_product_planning 0 7 34 219 Table
pp_wf_node_asset 0 2 12 0 Table
pp_wf_node_product 0 3 17 0 Table
qm_specification 0 4 18 0 Table
qm_specificationline 0 2 17 0 Table
r_category 1 1 13 3 Table
r_categoryupdates 0 2 11 1 Table
r_contactinterest 0 2 12 1 Table
r_group 1 3 15 2 Table
r_groupupdates 0 2 11 1 Table
r_interestarea 0 0 13 2 Table
r_issueknown 0 3 21 0 Table
r_issueproject 0 2 16 0 Table
r_issuerecommendation 0 0 12 0 Table
r_issuesource 0 3 13 0 Table
r_issuestatus 0 0 11 0 Table
r_issuesystem 0 1 14 0 Table
r_issueuser 0 1 12 0 Table
r_mailtext 13 0 15 2 Table
r_mailtext_trl 0 2 16 2 Table
r_request 4 27 65 1 Table
r_request_v 0 22 64 0 View
r_requestaction 0 20 46 2 Table
r_requestprocessor 0 3 24 3 Table
r_requestprocessor_route 0 3 14 1 Table
r_requestprocessorlog 0 1 16 232 Table
r_requesttype 1 1 25 3 Table
r_requesttypeupdates 0 2 11 1 Table
r_requestupdate 0 2 17 1 Table
r_requestupdates 0 2 11 0 Table
r_resolution 1 0 12 3 Table
r_standardresponse 1 0 11 1 Table
r_status 1 3 23 4 Table
r_statuscategory 0 0 13 1 Table
rv_allocation 0 8 38 0 View
rv_asset_customer 0 5 23 0 View
rv_asset_delivery 0 6 28 0 View
rv_asset_summonth 0 4 23 0 View
rv_bpartner 0 22 148 0 View
rv_bpartneropen 0 11 33 0 View
rv_c_invoice 0 32 167 0 View
rv_c_invoice_customerprodqtr 0 2 14 0 View
rv_c_invoice_customervendqtr 0 1 13 0 View
rv_c_invoice_day 0 0 12 0 View
rv_c_invoice_month 0 0 12 0 View
rv_c_invoice_prodmonth 0 1 13 0 View
rv_c_invoice_productmonth 0 1 13 0 View
rv_c_invoice_productqtr 0 1 13 0 View
rv_c_invoice_prodweek 0 1 13 0 View
rv_c_invoice_vendormonth 0 2 13 0 View
rv_c_invoice_week 0 0 12 0 View
rv_c_invoiceline 0 33 131 0 View
rv_c_invoicetax 0 25 136 0 View
rv_c_rfq_unanswered 0 5 20 0 View
rv_c_rfqresponse 0 9 33 0 View
rv_cash_detail 0 7 24 0 View
rv_click_month 0 1 8 0 View
rv_click_unprocessed 0 2 18 0 View
rv_commissionrundetail 0 66 283 0 View
rv_cost 0 16 92 0 View
rv_costdetail 0 26 106 0 View
rv_costsummary 0 4 19 0 View
rv_dd_orderdetail 0 15 48 0 View
rv_fact_acct 0 43 190 0 View
rv_fact_acct_day 0 13 31 0 View
rv_fact_acct_period 0 13 30 0 View
rv_fact_adaxa 0 0 43 0 View
rv_fact_simple 0 1 17 0 View
rv_inoutconfirm 0 6 21 0 View
rv_inoutdetails 0 29 125 0 View
rv_inoutlineconfirm 0 11 29 0 View
rv_m_forecast 0 7 21 0 View
rv_m_forecast_period 0 6 12 0 View
rv_m_product_whereused_v 0 2 12 0 View
rv_m_requisition 0 6 30 0 View
rv_m_transaction 0 23 105 0 View
rv_m_transaction_sum 0 3 8 0 View
rv_openitem 0 16 69 0 View
rv_openitemtodate 0 9 24 0 View
rv_orderdetail 0 37 158 0 View
rv_payment 0 14 89 0 View
rv_pp_mrp 0 3 43 0 View
rv_pp_operation_activity 0 2 19 0 View
rv_pp_order 0 12 59 0 View
rv_pp_order_bomline 0 6 23 0 View
rv_pp_order_receipt_issue 0 7 23 0 View
rv_pp_order_storage 0 8 28 0 View
rv_pp_order_transactions 0 3 24 0 View
rv_pp_order_workflow 0 4 29 0 View
rv_pp_product_bomline 0 6 29 0 View
rv_printformatdetail 0 12 67 0 View
rv_projectcycle 0 8 41 0 View
rv_projectlineissue 0 7 32 0 View
rv_requestupdates 0 1 13 0 View
rv_requestupdates_only 0 1 9 0 View
rv_requestupdates_v 0 1 9 0 View
rv_storage 0 17 96 0 View
rv_storage_per_product 0 3 17 0 View
rv_t_1099extract 0 2 40 0 View
rv_transaction 0 55 215 0 View
rv_unposted 0 1 18 0 View
rv_unprocessed 0 1 17 0 View
rv_warehouseprice 0 4 26 0 View
s_expensetype 12 3 16 1 Table
s_resource 24 3 24 11 Table
s_resourceassignment 2 1 16 2 Table
s_resourcetype 0 3 29 3 Table
s_resourceunavailable 0 1 13 2 Table
s_timeexpense 0 3 21 1 Table
s_timeexpenseline 1 14 38 4 Table
s_timetype 0 0 12 0 Table
s_training 0 3 19 1 Table
s_training_class 0 2 13 0 Table
t_1099extract 0 3 32 0 Table
t_aging 0 7 45 0 Table
t_alter_column 0 0 5 0 Table
t_bankregister 0 3 14 0 Table
t_bom_indented 0 3 25 0 Table
t_bomline 0 6 30 0 Table
t_bomline_costs 0 8 39 0 View
t_cashflow 0 11 30 9 Table
t_distributionrundetail 0 7 18 0 Table
t_inventoryvalue 0 7 24 0 Table
t_invoicegl 0 5 25 0 Table
t_invoicegl_v 0 34 126 0 View
t_mrp_crp 0 1 12 0 Table
t_reconciliation 0 2 11 0 Table
t_replenish 0 6 21 0 Table
t_report 0 2 30 0 Table
t_reportstatement 0 1 11 0 Table
t_rv_reconciliation 0 44 192 0 View
t_selection 0 0 3 0 Table
t_selection2 0 0 3 0 Table
t_spool 0 1 3 0 Table
t_transaction 0 15 29 0 Table
t_trialbalance 0 16 44 0 Table
test 0 8 30 1 Table
u_blacklistcheque 0 0 11 0 Table
u_posterminal 0 15 37 1 Table
u_rolemenu 0 2 11 74 Table
u_web_properties 0 0 11 143 Table
u_webmenu 0 1 20 143 Table
w_advertisement 0 4 28 1 Table
w_basket 0 3 14 0 Table
w_basketline 0 2 16 0 Table
w_click 1 2 19 0 Table
w_clickcount 1 1 13 1 Table
w_counter 0 2 19 0 Table
w_countercount 0 1 13 1 Table
w_mailmsg 0 1 17 0 Table
w_mailmsg_trl 0 2 15 0 Table
w_store 0 5 43 1 Table
w_store_trl 0 2 20 1 Table
ws_webservice 0 0 13 2 Table
ws_webservice_para 0 1 13 7 Table
ws_webservicefieldinput 0 4 17 8 Table
ws_webservicefieldoutput 0 2 11 0 Table
ws_webservicemethod 0 1 14 9 Table
ws_webservicetype 0 3 16 2 Table
ws_webservicetypeaccess 0 2 11 2 Table
x_packagelineweight 0 5 9 0 View