SchemaSpy Analysis of idempiere11.adempiere - ConstraintsAccounting Dimensions Generated by
Quality Systems & Solutions
148 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
ac_client_fact_acct fact_acct.ad_client_id ad_client.ad_client_id Restrict delete 
account_factacctsummary fact_acct_summary.account_id c_elementvalue.c_elementvalue_id Restrict delete 
ad_org_fact_acct fact_acct.ad_org_id ad_org.ad_org_id Restrict delete 
ad_org_mproduct m_product.ad_org_id ad_org.ad_org_id Restrict delete 
ad_orgtrx_fact_acct fact_acct.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adclient_adorg ad_org.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_cbpartner c_bpartner.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_celementvalue c_elementvalue.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_clocation c_location.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_cproject c_project.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_mproduct m_product.ad_client_id ad_client.ad_client_id Restrict delete 
adclient_vc c_validcombination.ad_client_id ad_client.ad_client_id Restrict delete 
adorg_adorginfo ad_orginfo.ad_org_id ad_org.ad_org_id Cascade on delete 
adorg_cbpartner c_bpartner.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cbpartnerorg c_bpartner.ad_orgbp_id ad_org.ad_org_id Restrict delete 
adorg_celementvalue c_elementvalue.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_clocation c_location.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cproject c_project.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_gldist gl_distribution.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_gldistline gl_distributionline.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_minout m_inout.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_minventory m_inventory.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_mmovement m_movement.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_mproduction m_production.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_vc c_validcombination.ad_org_id ad_org.ad_org_id Restrict delete 
adorgorg_gldist gl_distribution.org_id ad_org.ad_org_id Restrict delete 
adorgorg_gldistline gl_distributionline.org_id ad_org.ad_org_id Restrict delete 
adorgparent_adorginfo ad_orginfo.parent_org_id ad_org.ad_org_id Null on delete 
adorgtrx_cproject c_project.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_factacctsummary fact_acct_summary.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_gldist gl_distribution.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_gldistline gl_distributionline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_minout m_inout.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_minventory m_inventory.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_mmovement m_movement.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_mproduction m_production.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_vc c_validcombination.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtype_adorginfo ad_orginfo.ad_orgtype_id ad_orgtype.ad_orgtype_id Restrict delete 
adprintcolor_adorgtype ad_orgtype.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_cbpgroup c_bp_group.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_cchannel c_channel.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
adprintcolor_mproductcategory m_product_category.ad_printcolor_id ad_printcolor.ad_printcolor_id Restrict delete 
c_buspartner_fact_acct fact_acct.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
c_location_ad_orginfo ad_orginfo.c_location_id c_location.c_location_id Restrict delete 
c_locationfrom_fact_acct fact_acct.c_locfrom_id c_location.c_location_id Restrict delete 
c_locationto_fact_acct fact_acct.c_locto_id c_location.c_location_id Restrict delete 
c_project_fact_acct fact_acct.c_project_id c_project.c_project_id Restrict delete 
c_salesregion_factacct fact_acct.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
cactivity_cproject c_project.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cvalidcombination c_validcombination.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_factacct fact_acct.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_factacctsummary fact_acct_summary.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_gldist gl_distribution.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_gldistline gl_distributionline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_minout m_inout.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_minventory m_inventory.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_mmovement m_movement.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_mproduction m_production.c_activity_id c_activity.c_activity_id Restrict delete 
cbpartner_cpbartnerparent c_bpartner.bpartner_parent_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cproject c_project.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_factacctsummary fact_acct_summary.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_gldist gl_distribution.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_gldistline gl_distributionline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_minout m_inout.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mmovement m_movement.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_mproduction m_production.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_vc c_validcombination.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbpgroup_cbpartner c_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_factacctsummary fact_acct_summary.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_gldist gl_distribution.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_gldistline gl_distributionline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_minout m_inout.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_minventory m_inventory.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_mmovement m_movement.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_mproduction m_production.c_campaign_id c_campaign.c_campaign_id Restrict delete 
cchannel_ccampaign c_campaign.c_channel_id c_channel.c_channel_id Restrict delete 
celementvalue_factacct fact_acct.account_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueaccount_vc c_validcombination.account_id c_elementvalue.c_elementvalue_id Cascade on delete 
celementvalueuser1_factacct fact_acct.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_minout m_inout.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_minvent m_inventory.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_mmove m_movement.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_mprod m_production.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_vc c_validcombination.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_factacct fact_acct.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_minout m_inout.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_minvent m_inventory.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_mmove m_movement.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_mprod m_production.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_vc c_validcombination.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueacct_gldist gl_distribution.account_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueacct_gldistline gl_distributionline.account_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueuser1_gldist gl_distribution.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueuser1_gldistline gl_distributionline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueuser2_gldist gl_distribution.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
cevalueuser2_gldistline gl_distributionline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
clocfrom_factacctsummary fact_acct_summary.c_locfrom_id c_location.c_location_id Restrict delete 
clocfrom_gldist gl_distribution.c_locfrom_id c_location.c_location_id Restrict delete 
clocfrom_gldistline gl_distributionline.c_locfrom_id c_location.c_location_id Restrict delete 
clocto_factacctsummary fact_acct_summary.c_locto_id c_location.c_location_id Restrict delete 
clocto_gldist gl_distribution.c_locto_id c_location.c_location_id Restrict delete 
clocto_gldistline gl_distributionline.c_locto_id c_location.c_location_id Restrict delete 
cproject_cprojectphase c_projectphase.c_project_id c_project.c_project_id Restrict delete 
cproject_factacctsummary fact_acct_summary.c_project_id c_project.c_project_id Restrict delete 
cproject_gldist gl_distribution.c_project_id c_project.c_project_id Restrict delete 
cproject_gldistline gl_distributionline.c_project_id c_project.c_project_id Restrict delete 
cproject_minout m_inout.c_project_id c_project.c_project_id Restrict delete 
cproject_minventory m_inventory.c_project_id c_project.c_project_id Restrict delete 
cproject_mmovement m_movement.c_project_id c_project.c_project_id Restrict delete 
cproject_mproduction m_production.c_project_id c_project.c_project_id Restrict delete 
cproject_vc c_validcombination.c_project_id c_project.c_project_id Restrict delete 
cprojectphase_cprojecttask c_projecttask.c_projectphase_id c_projectphase.c_projectphase_id Cascade on delete 
cprojectphase_factacct fact_acct.c_projectphase_id c_projectphase.c_projectphase_id Null on delete 
cprojectphase_factacctsummary fact_acct_summary.c_projectphase_id c_projectphase.c_projectphase_id Restrict delete 
cprojectphase_mproduction m_production.c_projectphase_id c_projectphase.c_projectphase_id Restrict delete 
cprojecttask_factacct fact_acct.c_projecttask_id c_projecttask.c_projecttask_id Null on delete 
cprojecttask_factacctsummary fact_acct_summary.c_projecttask_id c_projecttask.c_projecttask_id Restrict delete 
cprojecttask_mproduction m_production.c_projecttask_id c_projecttask.c_projecttask_id Restrict delete 
csalesregion_factacctsummary fact_acct_summary.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregion_gldistline gl_distributionline.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregion_vc c_validcombination.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregopn_gldist gl_distribution.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
dropshipbpartner_minout m_inout.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
gldistribution_gldistline gl_distributionline.gl_distribution_id gl_distribution.gl_distribution_id Cascade on delete 
m_product_fact_acct fact_acct.m_product_id m_product.m_product_id Restrict delete 
minout_ref m_inout.ref_inout_id m_inout.m_inout_id Restrict delete 
mlocationfrom_vc c_validcombination.c_locfrom_id c_location.c_location_id Restrict delete 
mlocationto_vc c_validcombination.c_locto_id c_location.c_location_id Restrict delete 
mproduct_cprojectphase c_projectphase.m_product_id m_product.m_product_id Restrict delete 
mproduct_cprojecttask c_projecttask.m_product_id m_product.m_product_id Restrict delete 
mproduct_factacctsummary fact_acct_summary.m_product_id m_product.m_product_id Restrict delete 
mproduct_gldist gl_distribution.m_product_id m_product.m_product_id Restrict delete 
mproduct_gldistline gl_distributionline.m_product_id m_product.m_product_id Restrict delete 
mproduct_mproductcategory m_product.m_product_category_id m_product_category.m_product_category_id Restrict delete 
mproduct_mproduction m_production.m_product_id m_product.m_product_id Restrict delete 
mproduct_vc c_validcombination.m_product_id m_product.m_product_id Restrict delete 
mproductcat_parentcat m_product_category.m_product_category_parent_id m_product_category.m_product_category_id Restrict delete 
returnbpartner_minout m_inout.returnbpartner_id c_bpartner.c_bpartner_id Restrict delete 
reversal_minout m_inout.reversal_id m_inout.m_inout_id Restrict delete 
reversal_minventory m_inventory.reversal_id m_inventory.m_inventory_id Restrict delete 
reversal_mmovement m_movement.reversal_id m_movement.m_movement_id Restrict delete 
reversal_mproduction m_production.reversal_id m_production.m_production_id Restrict delete 
so_campaign_fact_acct fact_acct.c_campaign_id c_campaign.c_campaign_id Restrict delete 
socampaign_vc c_validcombination.c_campaign_id c_campaign.c_campaign_id Restrict delete 
user1_factacctsummary fact_acct_summary.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
user2_factacctsummary fact_acct_summary.user2_id c_elementvalue.c_elementvalue_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected