Tables


SchemaSpy Analysis of idempiere.adempiere

Generated on Mon Oct 14 02:05 IST 2019

XML Representation
Insertion Order Deletion Order
TABLES 857
VIEWS 155
COLUMNS 29310
Constraints 3432

Database Properties

Database Type: PostgreSQL - 9.5.3

Tables

Table / View Children Parents Columns Rows Type Comments
a_asset 50 16 69 0 Table
a_asset_acct 3 21 50 0 Table
a_asset_addition 2 15 52 0 Table
a_asset_change 1 17 79 0 Table
a_asset_change_amt 0 2 13 0 Table
a_asset_class 3 0 20 0 Table
a_asset_delivery 1 4 25 0 Table
a_asset_disposed 1 6 39 0 Table
a_asset_group 11 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 1 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 1 0 25 2 Table
a_asset_transfer 0 14 52 0 Table
a_asset_type 3 0 15 0 Table
a_asset_use 0 1 13 0 Table
a_depreciation 4 0 15 11 Table
a_depreciation_build 0 3 18 0 Table
a_depreciation_convention 4 0 15 6 Table
a_depreciation_entry 1 5 27 0 Table
a_depreciation_exp 0 7 37 0 Table
a_depreciation_forecast 0 2 15 0 Table
a_depreciation_method 4 0 14 3 Table
a_depreciation_table_detail 0 0 14 2579 Table
a_depreciation_table_header 4 0 14 122 Table
a_depreciation_workfile 1 2 44 0 Table
a_fundingmode 2 0 12 0 Table
a_fundingmode_acct 0 2 11 0 Table
a_registration 1 4 24 0 Table
a_registrationattribute 2 2 16 0 Table
a_registrationproduct 0 2 11 0 Table
a_registrationvalue 0 2 12 0 Table
acct_element_access 0 1 9 0 Table
ad_accesslog 0 2 17 0 Table
ad_alert 2 1 18 1 Table
ad_alertprocessor 2 2 19 1 Table
ad_alertprocessorlog 0 1 16 7 Table
ad_alertrecipient 0 3 12 1 Table
ad_alertrule 0 2 20 1 Table
ad_archive 0 3 18 4 Table
ad_attachment 2 1 16 698 Table
ad_attachmentnote 0 2 13 0 Table
ad_attribute 1 4 32 0 Table
ad_attribute_value 0 1 6 0 Table
ad_broadcastmessage 2 3 24 0 Table
ad_broadcastmessage_trl 0 6 12 0 Table
ad_changelog 0 3 21 243682 Table
ad_changelog_v 0 1 9 0 View
ad_chart 6 1 21 4 Table
ad_chart_trl 0 6 15 4 Table
ad_chartdatasource 0 3 22 6 Table
ad_client 104 3 40 9 Table
ad_clientinfo 0 23 37 8 Table
ad_clientshare 0 3 13 0 Table
ad_color 5 1 26 0 Table
ad_color_trl 0 6 12 0 Table
ad_column 34 10 52 24766 Table
ad_column_access 0 3 13 0 Table
ad_column_trl 0 2 12 24766 Table
ad_ctxhelp 8 7 19 0 Table
ad_ctxhelpmsg 1 1 12 0 Table
ad_ctxhelpmsg_trl 0 2 12 0 Table
ad_desktop 2 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 13178 Table
ad_element 4 1 19 5615 Table
ad_element_trl 0 2 19 5615 Table
ad_entitytype 48 0 17 11 Table
ad_error 0 1 12 0 Table
ad_field 6 12 52 19025 Table
ad_field_trl 0 2 14 19025 Table
ad_field_v 0 8 64 0 View
ad_field_vt 0 9 65 0 View
ad_fieldgroup 2 1 13 69 Table
ad_fieldgroup_trl 0 2 12 69 Table
ad_find 0 1 15 0 Table
ad_form 13 2 18 42 Table
ad_form_access 0 2 11 757 Table
ad_form_trl 0 2 14 42 Table
ad_housekeeping 0 1 21 9 Table
ad_image 19 1 14 11 Table
ad_impformat 3 1 15 22 Table
ad_impformat_row 0 2 22 258 Table
ad_importtemplate 1 6 16 0 Table
ad_importtemplateaccess 0 6 14 0 Table
ad_indexcolumn 0 3 14 1257 Table
ad_infocolumn 4 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 10 4 29 8 Table
ad_infowindow_access 0 2 10 192 Table
ad_infowindow_trl 0 2 14 8 Table
ad_issue 0 9 50 201007 Table
ad_labelprinter 2 0 11 0 Table
ad_labelprinterfunction 1 1 16 0 Table
ad_language 128 3 22 109 Table
ad_ldapaccess 0 3 15 0 Table
ad_ldapprocessor 2 1 17 1 Table
ad_ldapprocessorlog 0 1 16 0 Table
ad_menu 3 10 24 749 Table
ad_menu_trl 0 2 13 749 Table
ad_message 7 3 14 1660 Table
ad_message_trl 0 2 13 1660 Table
ad_migrationscript 0 0 21 287 Table
ad_modelvalidator 1 1 15 3 Table
ad_modification 0 1 15 0 Table
ad_note 0 5 20 112 Table
ad_org 171 3 14 20 Table
ad_org_v 0 4 19 0 View
ad_orginfo 0 12 29 11 Table
ad_orgtype 15 1 12 3 Table
ad_package_exp 1 0 23 2 Table
ad_package_exp_common 0 10 32 0 Table
ad_package_exp_detail 0 16 42 13 Table
ad_package_imp 2 1 24 18 Table
ad_package_imp_backup 0 5 18 347 Table
ad_package_imp_detail 1 2 19 1028 Table
ad_package_imp_inst 0 0 23 11 Table
ad_package_imp_proc 1 0 17 16 Table
ad_package_uuid_map 0 1 12 0 Table
ad_password_history 0 3 13 78 Table
ad_passwordrule 1 0 27 0 Table
ad_pinstance 23 3 22 18246 Table
ad_pinstance_log 0 2 9 2152 Table
ad_pinstance_para 0 1 19 46702 Table
ad_preference 0 6 16 491 Table
ad_printcolor 21 0 12 20 Table
ad_printcolor_trl 0 6 12 20 Table
ad_printfont 8 0 12 66 Table
ad_printform 0 15 25 9 Table
ad_printformat 23 8 29 228 Table
ad_printformat_trl 0 2 13 228 Table
ad_printformatitem 8 6 63 10077 Table
ad_printformatitem_trl 0 2 14 10077 Table
ad_printgraph 2 7 19 0 Table
ad_printlabel 1 2 17 0 Table
ad_printlabelline 1 3 18 0 Table
ad_printlabelline_trl 0 2 12 0 Table
ad_printpaper 3 0 22 4 Table
ad_printtableformat 2 9 39 2 Table
ad_private_access 0 2 11 0 Table
ad_process 30 6 32 422 Table
ad_process_access 0 4 11 7334 Table
ad_process_para 5 6 33 1031 Table
ad_process_para_trl 0 2 14 1031 Table
ad_process_trl 0 2 14 422 Table
ad_recentitem 0 5 15 930 Table
ad_record_access 0 2 14 0 Table
ad_ref_list 3 4 16 1418 Table
ad_ref_list_trl 0 2 13 1417 Table
ad_ref_table 0 9 18 209 Table
ad_reference 25 3 16 517 Table
ad_reference_trl 0 2 14 517 Table
ad_registration 0 4 26 0 Table
ad_relationtype 0 2 17 5 Table
ad_replication 1 3 24 1 Table
ad_replication_log 0 2 13 0 Table
ad_replication_run 1 1 13 0 Table
ad_replicationdocument 0 3 14 1 Table
ad_replicationstrategy 5 2 15 2 Table
ad_replicationtable 1 3 14 473 Table
ad_reportview 7 2 15 102 Table
ad_reportview_col 0 2 13 0 Table
ad_reportview_column 0 6 10 0 Table
ad_role 36 6 53 29 Table
ad_role_included 0 2 11 0 Table
ad_role_orgaccess 0 2 10 65 Table
ad_rule 5 1 18 4 Table
ad_schedule 5 0 20 5 Table
ad_scheduler 3 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 6 2 27 2585 Table
ad_sequence_audit 0 4 12 0 Table
ad_sequence_no 0 3 11 0 Table
ad_session 5 1 17 7862 Table
ad_sessioninfo_v 0 1 21 0 View
ad_statusline 1 6 13 4 Table
ad_statuslineusedin 0 8 15 13 Table
ad_storageprovider 2 0 15 0 Table
ad_style 5 0 11 1 Table
ad_styleline 0 1 14 1 Table
ad_sysconfig 0 1 14 93 Table
ad_system 2 0 43 1 Table
ad_tab 19 13 41 1060 Table
ad_tab_customization 0 2 13 3 Table
ad_tab_trl 0 2 15 1060 Table
ad_tab_v 0 6 39 0 View
ad_tab_vt 0 7 40 0 View
ad_table 75 6 31 951 Table
ad_table_access 0 4 15 1 Table
ad_table_scriptvalidator 0 2 13 0 Table
ad_table_trl 0 2 12 951 Table
ad_tableindex 1 3 20 1031 Table
ad_task 10 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 1 2 24 55 Table
ad_toolbarbuttonrestrict 0 5 16 0 Table
ad_tree 36 1 17 79 Table
ad_treebar 0 2 13 84 Table
ad_treenode 0 1 12 2206 Table
ad_treenodebp 0 1 12 1242 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 750 Table
ad_treenodepr 0 1 12 401 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 201 14 63 365 Table
ad_user_orgaccess 0 2 10 13 Table
ad_user_roles 0 4 10 131 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 7 37 0 Table
ad_userdef_tab 1 2 18 0 Table
ad_userdef_win 1 4 19 0 Table
ad_usermail 0 3 21 307 Table
ad_userpreference 0 5 14 40 Table
ad_userquery 0 3 15 3 Table
ad_val_rule 10 3 14 282 Table
ad_viewcolumn 0 2 17 10 Table
ad_viewcomponent 1 3 19 1 Table
ad_wf_activity 3 7 25 60837 Table
ad_wf_activityapprover 0 2 11 0 Table
ad_wf_activityresult 0 1 14 0 Table
ad_wf_block 2 1 12 0 Table
ad_wf_eventaudit 0 5 23 60837 Table
ad_wf_nextcondition 0 3 17 6 Table
ad_wf_node 15 17 61 261 Table
ad_wf_node_para 0 3 15 1 Table
ad_wf_node_trl 0 2 14 261 Table
ad_wf_nodenext 1 5 16 209 Table
ad_wf_process 4 8 20 21715 Table
ad_wf_processdata 0 1 12 0 Table
ad_wf_responsible 7 4 15 6 Table
ad_window 31 5 23 411 Table
ad_window_access 0 4 11 7307 Table
ad_window_trl 0 2 14 411 Table
ad_window_vt 0 4 13 0 View
ad_wizardprocess 0 2 13 0 Table
ad_workbench 6 4 16 1 Table
ad_workbench_trl 0 2 14 1 Table
ad_workbenchwindow 0 6 17 2 Table
ad_workflow 30 9 48 56 Table
ad_workflow_access 0 4 11 1087 Table
ad_workflow_trl 0 2 14 56 Table
ad_workflowprocessor 3 2 22 1 Table
ad_workflowprocessorlog 0 1 16 73 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 7 1 15 0 Table
asp_module 2 0 13 0 Table
asp_process 1 2 12 0 Table
asp_process_para 0 2 12 0 Table
asp_ref_list 0 3 13 0 Table
asp_tab 1 2 14 0 Table
asp_task 0 2 12 0 Table
asp_window 1 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 2 1 12 0 Table
b_buyerfunds 1 4 14 0 Table
b_offer 0 4 16 0 Table
b_seller 2 1 13 0 Table
b_sellerfunds 1 4 14 0 Table
b_topic 3 2 22 0 Table
b_topiccategory 1 1 12 0 Table
b_topictype 2 3 16 0 Table
c_1099box 3 0 14 0 Table
c_acctprocessor 1 4 21 7 Table
c_acctprocessorlog 0 1 16 876 Table
c_acctschema 52 6 35 11 Table
c_acctschema_default 0 77 86 10 Table
c_acctschema_element 0 14 26 57 Table
c_acctschema_gl 0 11 22 10 Table
c_activity 98 0 14 7 Table
c_activity_trl 0 6 14 0 Table
c_addresstransaction 0 6 22 0 Table
c_addressvalidation 2 5 17 0 Table
c_addressvalidationcfg 1 4 19 0 Table
c_allocationhdr 3 3 25 6485 Table
c_allocationline 3 8 26 9462 Table
c_application 1 0 11 0 Table
c_bank 4 1 15 34 Table
c_bankaccount 28 2 22 36 Table
c_bankaccount_acct 0 14 22 73 Table
c_bankaccount_processor 0 3 27 2 Table
c_bankaccountdoc 0 2 15 1 Table
c_bankstatement 2 1 31 34 Table
c_bankstatementline 1 7 43 1882 Table
c_bankstatementloader 0 1 28 0 Table
c_bankstatementmatcher 0 0 13 0 Table
c_bp_bankaccount 8 4 35 88 Table
c_bp_customer_acct 0 6 14 2005 Table
c_bp_edi 1 3 28 0 Table
c_bp_employee_acct 0 4 12 0 Table
c_bp_group 40 6 23 14 Table
c_bp_group_acct 0 17 26 17 Table
c_bp_relation 0 4 19 1 Table
c_bp_shippingacct 2 3 15 0 Table
c_bp_vendor_acct 0 6 14 2005 Table
c_bp_withholding 0 2 13 0 Table
c_bpartner 239 20 76 1237 Table
c_bpartner_location 84 5 22 1169 Table
c_bpartner_product 0 2 18 12 Table
c_calendar 22 2 11 8 Table
c_campaign 100 1 17 9 Table
c_campaign_trl 0 6 13 2 Table
c_cash 2 8 30 3 Table
c_cashbook 11 1 13 9 Table
c_cashbook_acct 0 7 15 7 Table
c_cashline 9 6 23 5 Table
c_cashplan 1 7 26 0 Table
c_cashplanline 7 12 29 0 Table
c_channel 1 1 12 9 Table
c_charge 73 3 18 5 Table
c_charge_acct 0 4 12 3 Table
c_charge_trl 0 2 13 3 Table
c_chargetype 2 0 13 1 Table
c_chargetype_doctype 0 2 12 0 Table
c_city 12 4 16 40 Table
c_commission 3 3 20 1 Table
c_commissionamt 2 2 14 0 Table
c_commissiondetail 1 4 18 0 Table
c_commissionline 2 7 25 1 Table
c_commissionrun 2 1 16 0 Table
c_component 1 0 11 0 Table
c_contactactivity 0 3 18 8 Table
c_conversion_rate 1 5 16 7 Table
c_conversiontype 40 0 13 4 Table
c_country 27 5 34 247 Table
c_country_trl 0 2 14 247 Table
c_countrygroup 4 4 15 0 Table
c_countrygroup_trl 0 6 13 0 Table
c_countrygroupcountry 0 6 13 0 Table
c_currency 118 2 19 174 Table
c_currency_acct 0 6 14 0 Table
c_currency_trl 0 2 13 174 Table
c_cycle 2 1 12 9 Table
c_cyclephase 0 2 10 10 Table
c_cyclestep 2 1 13 4 Table
c_depositbatch 2 2 20 0 Table
c_depositbatchline 0 2 15 0 Table
c_doctype 91 8 41 379 Table
c_doctype_trl 0 2 14 379 Table
c_doctypecounter 0 2 17 1 Table
c_dunning 31 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 17 3 28 2 Table
c_dunninglevel_trl 0 2 13 2 Table
c_dunningrun 3 2 16 0 Table
c_dunningrunentry 5 7 20 0 Table
c_dunningrunline 2 4 23 0 Table
c_element 5 3 16 8 Table
c_elementvalue 82 5 30 1363 Table
c_elementvalue_trl 0 2 13 1363 Table
c_greeting 53 0 13 1 Table
c_greeting_trl 0 2 13 1 Table
c_interorg_acct 0 5 12 0 Table
c_invoice 64 26 93 7349 Table
c_invoice_candidate_v 0 3 8 0 View
c_invoice_header_v 0 48 344 0 View
c_invoice_header_vt 0 49 330 0 View
c_invoice_linetax_v 0 1 249 0 View
c_invoice_linetax_vt 0 2 244 0 View
c_invoice_v 0 14 60 0 View
c_invoice_v1 0 13 51 0 View
c_invoicebatch 1 3 20 0 Table
c_invoicebatchline 0 15 35 0 Table
c_invoiceline 24 28 73 10356 Table
c_invoiceline_v 0 11 28 0 View
c_invoicepayschedule 3 2 18 0 Table
c_invoiceschedule 20 0 20 1 Table
c_invoicetax 0 3 15 8738 Table
c_job 4 1 14 8 Table
c_jobassignment 0 2 14 0 Table
c_jobcategory 1 0 12 8 Table
c_jobremuneration 0 2 14 0 Table
c_landedcost 0 5 16 0 Table
c_landedcostallocation 0 5 16 0 Table
c_location 55 6 24 1816 Table
c_nonbusinessday 0 4 13 1 Table
c_oem 1 0 11 0 Table
c_onlinetrxhistory 0 1 14 0 Table
c_opportunity 4 8 29 312 Table
c_order 74 38 95 404 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 1 2 15 0 Table
c_orderlandedcostallocation 0 2 15 0 Table
c_orderline 32 25 59 674 Table
c_orderpayschedule 0 2 18 0 Table
c_ordersource 2 4 13 0 Table
c_ordertax 0 3 15 436 Table
c_orgassignment 0 2 13 0 Table
c_payment 47 24 106 5998 Table
c_payment_v 0 14 78 0 View
c_paymentallocate 0 4 24 2088 Table
c_paymentbatch 8 1 15 0 Table
c_paymentprocessor 5 3 36 2 Table
c_paymentterm 64 0 30 16 Table
c_paymentterm_trl 0 2 14 9 Table
c_paymenttransaction 1 21 77 0 Table
c_payschedule 2 1 17 2 Table
c_payselection 7 1 18 5 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 5 4 22 5 Table
c_payselectionline 2 3 23 2 Table
c_period 25 3 16 432 Table
c_periodcontrol 0 1 14 7296 Table
c_phase 11 2 16 19 Table
c_pos 5 10 26 0 Table
c_poskey 0 6 22 0 Table
c_poskeylayout 5 2 16 0 Table
c_pospayment 0 3 28 0 Table
c_postendertype 3 0 16 0 Table
c_productsmapped 0 3 13 232 Table
c_project 110 16 48 772 Table
c_project_acct 0 4 12 1256 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_project_new 1 0 11 0 Table
c_projectissue 14 6 23 0 Table
c_projectissuema 0 2 11 0 Table
c_projectline 3 9 31 7 Table
c_projectphase 23 4 27 6 Table
c_projecttask 23 3 20 6 Table
c_projecttype 10 0 13 7 Table
c_recurring 1 6 26 1 Table
c_recurring_run 0 6 16 0 Table
c_recurringgroup 1 4 13 0 Table
c_region 20 3 13 393 Table
c_region_trl 0 6 12 393 Table
c_remuneration 2 0 18 0 Table
c_revenuerecognition 14 0 14 2 Table
c_revenuerecognition_plan 2 6 17 0 Table
c_revenuerecognition_run 0 2 12 0 Table
c_rfq 6 7 38 1 Table
c_rfq_topic 4 1 13 1 Table
c_rfq_topicsubscriber 1 4 15 2 Table
c_rfq_topicsubscriberonly 0 3 13 0 Table
c_rfqline 4 3 18 2 Table
c_rfqlineqty 5 2 19 2 Table
c_rfqresponse 6 6 31 0 Table
c_rfqresponse_v 0 6 29 0 View
c_rfqresponse_vt 0 7 29 0 View
c_rfqresponseline 5 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 33 1 15 9 Table
c_salesregion_trl 0 6 13 2 Table
c_salesstage 4 0 15 6 Table
c_salesstage_trl 0 6 13 6 Table
c_servicelevel 1 2 16 0 Table
c_servicelevelline 0 1 14 0 Table
c_subacct 8 1 14 0 Table
c_subscription 1 3 17 0 Table
c_subscription_delivery 0 1 10 0 Table
c_subscriptiontype 14 0 13 0 Table
c_task 1 2 16 11 Table
c_tax 28 10 32 68 Table
c_tax_acct 0 7 15 151 Table
c_tax_trl 0 2 14 68 Table
c_taxbase 1 0 15 0 Table
c_taxcategory 20 0 13 24 Table
c_taxcategory_trl 0 2 13 24 Table
c_taxdeclaration 2 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 29 0 13 0 Table
c_taxpostal 0 1 12 0 Table
c_taxprovider 4 5 16 0 Table
c_taxprovidercfg 1 4 13 0 Table
c_taxtype 1 0 13 0 Table
c_tier 1 0 11 0 Table
c_uom 97 2 17 14 Table
c_uom_conversion 0 5 14 0 Table
c_uom_trl 0 2 14 14 Table
c_userremuneration 0 2 18 0 Table
c_validcombination 253 16 29 3861 Table
c_withholding 2 2 23 0 Table
c_withholding_acct 0 3 11 0 Table
c_year 7 3 13 36 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 6 0 13 0 Table
cm_accessstage 0 2 10 0 Table
cm_ad 0 2 26 0 Table
cm_ad_cat 2 1 13 0 Table
cm_broadcastserver 1 1 15 0 Table
cm_chat 2 2 15 2 Table
cm_chatentry 2 4 18 3 Table
cm_chattype 2 1 13 0 Table
cm_chattypeupdate 0 2 11 0 Table
cm_chatupdate 0 2 11 0 Table
cm_container 7 3 35 5 Table
cm_container_element 1 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 5 3 37 5 Table
cm_cstage_element 1 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 4 2 18 3 Table
cm_media_server 1 1 19 1 Table
cm_mediadeploy 0 2 14 0 Table
cm_newschannel 2 2 15 0 Table
cm_newsitem 0 1 16 0 Table
cm_template 4 1 22 4 Table
cm_template_ad_cat 0 2 12 0 Table
cm_templatetable 2 2 15 0 Table
cm_webaccesslog 0 4 27 0 Table
cm_webproject 12 4 21 1 Table
cm_webproject_domain 0 2 15 1 Table
cm_wikitoken 0 1 16 0 Table
datatypestable 0 0 3 0 Table
dd_networkdistribution 3 1 20 2 Table
dd_networkdistributionline 0 4 18 10 Table
dd_order 7 17 64 0 Table
dd_order_header_v 0 11 53 0 View
dd_order_header_vt 0 12 53 0 View
dd_orderline 4 15 43 0 Table
dual 0 0 1 1 Table
exp_format 2 1 19 10 Table
exp_formatline 0 3 21 43 Table
exp_processor 2 1 18 2 Table
exp_processor_type 1 0 14 2 Table
exp_processorparameter 0 1 15 7 Table
fact_acct 7 27 47 66584 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 15 0 13 1 Table
gl_budgetcontrol 0 2 17 0 Table
gl_category 17 0 14 94 Table
gl_category_trl 0 6 12 94 Table
gl_distribution 1 16 45 1 Table
gl_distributionline 0 15 39 2 Table
gl_fund 1 1 16 0 Table
gl_fundrestriction 0 2 13 0 Table
gl_journal 6 10 36 5236 Table
gl_journalbatch 7 5 28 34 Table
gl_journalgenerator 1 5 19 2 Table
gl_journalgeneratorline 1 4 22 6 Table
gl_journalgeneratorsource 0 3 15 8 Table
gl_journalline 4 23 46 19050 Table
gl_journalline_acct_v 0 12 37 0 View
hr_attribute 0 8 28 0 Table
hr_concept 5 5 30 0 Table
hr_concept_acct 0 7 17 0 Table
hr_concept_category 2 1 14 0 Table
hr_contract 1 3 18 0 Table
hr_department 7 1 13 0 Table
hr_employee 3 5 22 0 Table
hr_job 6 3 17 0 Table
hr_list 2 4 18 0 Table
hr_listline 0 1 21 0 Table
hr_listtype 1 0 12 0 Table
hr_listversion 1 2 15 0 Table
hr_movement 1 18 39 0 Table
hr_payroll 8 3 18 0 Table
hr_payrollconcept 0 3 17 0 Table
hr_period 1 4 23 0 Table
hr_process 3 13 32 0 Table
hr_year 1 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 195 Table
i_fajournal 0 27 72 0 Table
i_fixedasset 1 9 48 0 Table
i_gljournal 0 26 70 21 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 20 Table
i_movement 0 12 44 0 Table
i_order 0 26 68 0 Table
i_payment 0 7 71 24 Table
i_pricelist 0 6 34 0 Table
i_product 0 5 55 96 Table
i_productplanning 0 12 52 0 Table
i_reportline 0 4 30 0 Table
imp_processor 2 1 24 2 Table
imp_processor_type 1 0 14 2 Table
imp_processorlog 0 1 17 0 Table
imp_processorparameter 0 1 15 6 Table
k_category 2 0 12 1 Table
k_categoryvalue 1 1 12 0 Table
k_comment 0 2 14 0 Table
k_entry 4 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 1 0 11 1 Table
k_synonym 0 1 12 0 Table
k_topic 1 1 15 1 Table
k_type 1 0 14 2 Table
m_attribute 4 1 15 4 Table
m_attributeinstance 0 3 13 5 Table
m_attributesearch 1 0 11 1 Table
m_attributeset 28 2 27 4 Table
m_attributesetexclude 0 2 12 0 Table
m_attributesetinstance 86 2 15 4 Table
m_attributeuse 0 2 11 5 Table
m_attributevalue 1 1 13 9 Table
m_bom 2 2 17 1 Table
m_bomalternative 1 1 12 1 Table
m_bomproduct 0 6 23 0 Table
m_bp_price 0 3 22 0 Table
m_changenotice 15 0 16 1 Table
m_changerequest 2 3 19 0 Table
m_commodityshipment 0 2 14 0 Table
m_cost 0 7 23 559 Table
m_costdetail 3 15 33 3462 Table
m_costelement 15 0 14 16 Table
m_costhistory 1 4 21 171 Table
m_costmovement_v 0 14 35 0 View
m_costqueue 0 5 16 16 Table
m_costtype 10 0 12 8 Table
m_demand 1 2 16 0 Table
m_demanddetail 0 4 13 0 Table
m_demandline 1 3 14 0 Table
m_discountschema 28 0 19 12 Table
m_discountschemabreak 0 3 16 1 Table
m_discountschemaline 0 5 40 11 Table
m_distributionlist 3 0 14 1 Table
m_distributionlistline 1 3 15 3 Table
m_distributionrun 2 2 15 1 Table
m_distributionrunline 1 3 16 1 Table
m_edi 1 3 27 0 Table
m_edi_info 0 1 10 0 Table
m_forecast 5 3 17 4 Table
m_forecastline 3 5 17 50 Table
m_freight 0 7 18 1 Table
m_freightcategory 19 0 13 2 Table
m_inout 30 26 77 961 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 7 3 25 0 Table
m_inoutconfirm_v 0 8 34 0 View
m_inoutconfirm_vt 0 9 34 0 View
m_inoutline 41 19 39 1616 Table
m_inoutlineconfirm 4 4 20 0 Table
m_inoutlinema 0 2 13 27 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 8 13 35 4 Table
m_inventoryline 15 6 25 2 Table
m_inventorylinema 0 2 13 2 Table
m_locator 75 4 17 27 Table
m_locatortype 1 4 15 0 Table
m_lot 12 2 16 0 Table
m_lotctl 3 0 16 1 Table
m_lotctlexclude 0 2 12 0 Table
m_matchinv 4 5 23 21 Table
m_matchpo 1 6 26 27 Table
m_movement 9 16 45 0 Table
m_movement_candidate_v 0 4 12 0 View
m_movementconfirm 1 2 19 0 Table
m_movementline 13 8 24 0 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 4 11 72 1 Table
m_packageline 0 4 15 1 Table
m_packagelines_avail_v 0 3 9 0 View
m_packagemps 3 3 23 0 Table
m_parttype 1 0 11 0 Table
m_perpetualinv 1 2 20 0 Table
m_pricelist 68 2 20 24 Table
m_pricelist_trl 0 6 13 24 Table
m_pricelist_version 13 3 16 21 Table
m_pricelist_version_trl 0 6 12 21 Table
m_product 212 16 71 395 Table
m_product_acct 0 26 34 661 Table
m_product_bom 0 2 15 0 Table
m_product_category 33 3 19 22 Table
m_product_category_acct 0 26 37 13 Table
m_product_category_trl 0 6 13 22 Table
m_product_po 0 6 33 334 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 342 Table
m_productdownload 1 1 12 0 Table
m_production 7 14 38 0 Table
m_productionline 11 5 21 0 Table
m_productionlinema 0 2 12 0 Table
m_productionplan 2 3 16 0 Table
m_productoperation 2 1 16 0 Table
m_productprice 0 2 14 476 Table
m_productpricevendorbreak 0 3 16 0 Table
m_promotion 7 1 13 0 Table
m_promotiondistribution 2 2 16 0 Table
m_promotiongroup 2 0 11 0 Table
m_promotiongroupline 0 2 11 0 Table
m_promotionline 1 2 13 0 Table
m_promotionprecondition 0 6 21 0 Table
m_promotionreward 0 4 20 0 Table
m_qualitytest 2 0 12 0 Table
m_qualitytestresult 0 2 14 0 Table
m_relatedproduct 0 2 13 0 Table
m_replenish 0 4 16 0 Table
m_requisition 3 4 27 0 Table
m_requisitionline 3 7 21 0 Table
m_rma 22 8 30 0 Table
m_rmaline 9 6 23 0 Table
m_rmatax 0 3 15 0 Table
m_rmatype 1 0 12 1 Table
m_sernoctl 2 0 16 1 Table
m_sernoctlexclude 0 2 12 0 Table
m_shipper 28 3 14 3 Table
m_shippercfg 4 1 19 0 Table
m_shipperlabels 2 2 14 0 Table
m_shipperlabelscfg 1 1 17 0 Table
m_shipperpackaging 2 2 14 0 Table
m_shipperpackagingcfg 1 1 15 0 Table
m_shipperpickuptypes 2 2 13 0 Table
m_shipperpickuptypescfg 1 1 14 0 Table
m_shippingprocessor 3 1 14 0 Table
m_shippingprocessorcfg 2 0 19 0 Table
m_shippingtransaction 1 23 89 0 Table
m_shippingtransactionline 0 4 23 0 Table
m_storage 0 3 16 0 View
m_storageonhand 0 3 14 29 Table
m_storagereservation 0 3 14 9 Table
m_substitute 0 4 12 0 Table
m_transaction 6 9 21 29 Table
m_transaction_v 0 14 24 0 View
m_transactionallocation 0 10 22 0 Table
m_warehouse 98 5 19 28 Table
m_warehouse_acct 0 6 14 22 Table
pa_achievement 0 1 17 0 Table
pa_benchmark 2 0 13 0 Table
pa_benchmarkdata 0 1 14 0 Table
pa_colorschema 1 5 20 2 Table
pa_dashboardcontent 3 6 28 8 Table
pa_dashboardcontent_access 0 7 12 0 Table
pa_dashboardcontent_trl 0 2 14 8 Table
pa_dashboardpreference 0 3 16 420 Table
pa_goal 4 5 29 4 Table
pa_goalrestriction 0 7 17 0 Table
pa_hierarchy 1 8 20 0 Table
pa_measure 2 6 22 4 Table
pa_measurecalc 2 2 20 6 Table
pa_ratio 3 1 13 1 Table
pa_ratioelement 0 4 20 3 Table
pa_report 0 8 23 5 Table
pa_reportcolumn 2 15 55 17 Table
pa_reportcolumnset 2 0 12 3 Table
pa_reportcube 2 1 31 0 Table
pa_reportline 6 5 26 278 Table
pa_reportlineset 3 0 12 6 Table
pa_reportsource 1 11 36 226 Table
pa_sla_criteria 1 0 14 2 Table
pa_sla_goal 1 2 21 1 Table
pa_sla_measure 0 2 17 1 Table
pp_cost_collector 9 20 47 0 Table
pp_cost_collectorma 0 2 12 0 Table
pp_mrp 0 15 41 80 Table
pp_order 27 17 66 2 Table
pp_order_bom 6 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 8 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 9 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 8 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 21 4 25 7 Table
pp_product_bom_trl 0 2 14 0 Table
pp_product_bomline 6 5 32 0 Table
pp_product_bomline_trl 0 2 13 0 Table
pp_product_bomline_v 0 6 31 0 View
pp_product_bomline_vt 0 7 31 0 View
pp_product_planning 1 7 34 219 Table
pp_wf_node_asset 0 2 12 0 Table
pp_wf_node_product 0 3 17 0 Table
qm_specification 1 4 18 0 Table
qm_specificationline 0 2 17 0 Table
r_category 4 1 13 5 Table
r_categoryupdates 0 2 11 3 Table
r_contactinterest 0 2 12 0 Table
r_group 4 3 15 4 Table
r_groupupdates 0 2 11 3 Table
r_interestarea 3 0 13 2 Table
r_issueknown 1 3 21 0 Table
r_issueproject 2 2 16 0 Table
r_issuerecommendation 1 0 12 0 Table
r_issuesource 0 3 13 0 Table
r_issuestatus 1 0 11 0 Table
r_issuesystem 2 1 14 0 Table
r_issueuser 2 1 12 0 Table
r_mailtext 27 0 15 4 Table
r_mailtext_trl 0 2 16 4 Table
r_request 10 27 65 11 Table
r_request_v 0 22 64 0 View
r_requestaction 0 20 46 21 Table
r_requestprocessor 2 3 24 9 Table
r_requestprocessor_route 0 3 14 2 Table
r_requestprocessorlog 0 1 16 585 Table
r_requesttype 10 1 25 7 Table
r_requesttypeupdates 0 2 11 5 Table
r_requestupdate 0 2 17 10 Table
r_requestupdates 0 2 11 2 Table
r_resolution 3 0 12 7 Table
r_standardresponse 2 0 11 2 Table
r_status 5 3 23 12 Table
r_statuscategory 2 0 13 5 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 168 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 98 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 0 18 0 View
rv_unprocessed 0 0 17 0 View
rv_warehouseprice 0 4 26 0 View
s_expensetype 13 3 16 1 Table
s_resource 36 3 24 11 Table
s_resourceassignment 5 1 16 2 Table
s_resourcetype 1 3 29 3 Table
s_resourceunavailable 0 1 13 2 Table
s_timeexpense 1 3 21 1 Table
s_timeexpenseline 2 14 38 4 Table
s_timetype 1 0 12 0 Table
s_training 1 3 19 1 Table
s_training_class 0 2 13 0 Table
sales_opp_balance_qty 0 3 12 0 View
t_1099extract 0 3 32 0 Table
t__client_activity 0 0 3 2 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 0 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 871 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 2 1 20 143 Table
w_advertisement 0 4 28 1 Table
w_basket 1 3 14 0 Table
w_basketline 0 2 16 0 Table
w_click 1 2 19 0 Table
w_clickcount 3 1 13 1 Table
w_counter 0 2 19 0 Table
w_countercount 2 1 13 1 Table
w_mailmsg 2 1 17 0 Table
w_mailmsg_trl 0 2 15 0 Table
w_store 2 5 43 1 Table
w_store_trl 0 2 20 1 Table
ws_webservice 2 0 13 2 Table
ws_webservice_para 0 1 13 53 Table
ws_webservicefieldinput 0 4 17 42 Table
ws_webservicefieldoutput 0 2 11 12 Table
ws_webservicemethod 1 1 14 9 Table
ws_webservicetype 4 3 16 21 Table
ws_webservicetypeaccess 0 2 11 21 Table
x_packagelineweight 0 5 9 0 View
xx_crm_opportunities_all_v 0 2 18 0 View
xx_crm_opportunities_v 0 2 16 0 View