SchemaSpy Analysis of idempiere11.adempiere - ConstraintsImport Export Generated by
Quality Systems & Solutions
485 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aaccumdepreciation_iasset i_asset.a_accumdepreciation_acct c_validcombination.c_validcombination_id Restrict delete 
aasset_iasset i_asset.a_asset_acct c_validcombination.c_validcombination_id Restrict delete 
account_gljournalline gl_journalline.account_id c_elementvalue.c_elementvalue_id Restrict delete 
account_ifajournal i_fajournal.account_id c_elementvalue.c_elementvalue_id Restrict delete 
ad_org_c_acctschema c_acctschema.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_user_org ad_user.ad_org_id ad_org.ad_org_id Restrict delete 
adcolumn_adimpformatrow ad_impformat_row.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_expformatline exp_formatline.ad_column_id ad_column.ad_column_id Restrict delete 
adcolumn_ielementvalue i_elementvalue.ad_column_id ad_column.ad_column_id Null on delete 
adepreciation_iasset i_asset.a_depreciation_acct c_validcombination.c_validcombination_id Restrict delete 
adimpformat_adimpformatrow ad_impformat_row.ad_impformat_id ad_impformat.ad_impformat_id Cascade on delete 
adorg_adimporttemplate ad_importtemplate.ad_org_id ad_org.ad_org_id Restrict 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_cinvoice c_invoice.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cinvoiceline c_invoiceline.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_corder c_order.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_corderline c_orderline.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_cpayment c_payment.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_gljournalline gl_journalline.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_igljournal i_gljournal.ad_org_id ad_org.ad_org_id Null on delete 
adorg_iinvoice i_invoice.ad_org_id ad_org.ad_org_id Null on delete 
adorg_iorder i_order.ad_org_id ad_org.ad_org_id Null on delete 
adorg_minventory m_inventory.ad_org_id ad_org.ad_org_id Restrict delete 
adorg_pareportsource pa_reportsource.org_id ad_org.ad_org_id Restrict delete 
adorg_vc c_validcombination.ad_org_id ad_org.ad_org_id Restrict delete 
adorgdoc_ifajournal i_fajournal.ad_orgdoc_id ad_org.ad_org_id Restrict delete 
adorgdoc_igljournal i_gljournal.ad_orgdoc_id ad_org.ad_org_id Null on delete 
adorgonly_cacctschema c_acctschema.ad_orgonly_id ad_org.ad_org_id Restrict delete 
adorgtrx_aduser ad_user.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cinvoice c_invoice.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cinvoiceline c_invoiceline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_corder c_order.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_corderline c_orderline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cpayment c_payment.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_cproject c_project.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_gljournalline gl_journalline.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_ifajournal i_fajournal.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_igljournal i_gljournal.ad_orgtrx_id ad_org.ad_org_id Null on delete 
adorgtrx_iinvoice i_invoice.ad_orgtrx_id ad_org.ad_org_id Null on delete 
adorgtrx_imovement i_movement.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_iorder i_order.ad_orgtrx_id ad_org.ad_org_id Null on delete 
adorgtrx_minventory m_inventory.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_pareportsource pa_reportsource.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
adorgtrx_vc c_validcombination.ad_orgtrx_id ad_org.ad_org_id Restrict delete 
aduser_cinvoice c_invoice.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_corder c_order.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_cproject c_project.ad_user_id ad_user.ad_user_id Null on delete 
aduser_ibpartner i_bpartner.ad_user_id ad_user.ad_user_id Null on delete 
aduser_iinvoice i_invoice.ad_user_id ad_user.ad_user_id Null on delete 
aduser_imovement i_movement.ad_user_id ad_user.ad_user_id Restrict delete 
aduser_iorder i_order.ad_user_id ad_user.ad_user_id Null on delete 
aduser_sr_cinvoice c_invoice.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_sr_corder c_order.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_sr_cproject c_project.salesrep_id ad_user.ad_user_id Restrict delete 
aduser_supervisor ad_user.supervisor_id ad_user.ad_user_id Restrict delete 
aduserbill_corder c_order.bill_user_id ad_user.ad_user_id Restrict delete 
adusersalesrep_cbpartner c_bpartner.salesrep_id ad_user.ad_user_id Null on delete 
adusersalesrep_iinvoice i_invoice.salesrep_id ad_user.ad_user_id Null on delete 
adusersalesrep_iorder i_order.salesrep_id ad_user.ad_user_id Null on delete 
aliasvalidcombination_gljourna gl_journalline.alias_validcombination_id c_validcombination.c_validcombination_id Restrict delete 
basepricelist m_pricelist.basepricelist_id m_pricelist.m_pricelist_id Restrict delete 
bplocation_aduser ad_user.bp_location_id c_location.c_location_id Restrict delete 
c_acctschema_gl_journal gl_journal.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
c_bplocation_cinvoice c_invoice.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
c_buspartner_locationorg c_bpartner_location.ad_org_id ad_org.ad_org_id Restrict delete 
c_buspartner_m_product_po m_product_po.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
c_conversion_rateorg c_conversion_rate.ad_org_id ad_org.ad_org_id Restrict delete 
c_country_c_tax c_tax.c_country_id c_country.c_country_id Restrict delete 
c_country_location c_location.c_country_id c_country.c_country_id Restrict delete 
c_countryorg c_country.ad_org_id ad_org.ad_org_id Restrict delete 
c_countryto_c_tax c_tax.to_country_id c_country.c_country_id Restrict delete 
c_currency_c_acctschema c_acctschema.c_currency_id c_currency.c_currency_id Restrict delete 
c_currencyconvrateto c_conversion_rate.c_currency_id_to c_currency.c_currency_id Restrict delete 
c_currencyorg c_currency.ad_org_id ad_org.ad_org_id Restrict delete 
c_doctype_corder c_order.c_doctype_id c_doctype.c_doctype_id Restrict delete 
c_elementorg c_element.ad_org_id ad_org.ad_org_id Restrict delete 
c_location_warehouse m_warehouse.c_location_id c_location.c_location_id Restrict delete 
c_period_journal gl_journal.c_period_id c_period.c_period_id Restrict delete 
c_period_journalbatch gl_journalbatch.c_period_id c_period.c_period_id Restrict delete 
c_periodorg c_period.ad_org_id ad_org.ad_org_id Restrict delete 
c_region_c_tax c_tax.c_region_id c_region.c_region_id Restrict delete 
c_region_location c_location.c_region_id c_region.c_region_id Restrict delete 
c_regionorg c_region.ad_org_id ad_org.ad_org_id Restrict delete 
c_regionto_c_tax c_tax.to_region_id c_region.c_region_id Restrict delete 
c_uom_m_product_po m_product_po.c_uom_id c_uom.c_uom_id Restrict delete 
c_uomorg c_uom.ad_org_id ad_org.ad_org_id Restrict delete 
cacctschema_cvalidcombination c_validcombination.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_iasset i_asset.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_ifajournal i_fajournal.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_ifixedasset i_fixedasset.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_igljournal i_gljournal.c_acctschema_id c_acctschema.c_acctschema_id Null on delete 
cactivity_cinvoice c_invoice.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cinvoiceline c_invoiceline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_corder c_order.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_corderline c_orderline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_cpayment c_payment.c_activity_id c_activity.c_activity_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_gljournal i_gljournal.c_activity_id c_activity.c_activity_id Null on delete 
cactivity_gljournalline gl_journalline.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_ifajournal i_fajournal.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_iinvoice i_invoice.c_activity_id c_activity.c_activity_id Null on delete 
cactivity_iorder i_order.c_activity_id c_activity.c_activity_id Null on delete 
cactivity_minventory m_inventory.c_activity_id c_activity.c_activity_id Restrict delete 
cactivity_pareportsource pa_reportsource.c_activity_id c_activity.c_activity_id Restrict delete 
cbankaccount_cbankstatement c_bankstatement.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_celementvalue c_elementvalue.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_cpayment c_payment.c_bankaccount_id c_bankaccount.c_bankaccount_id Restrict delete 
cbankaccount_ibankstatement i_bankstatement.c_bankaccount_id c_bankaccount.c_bankaccount_id Null on delete 
cbankaccount_ipayment i_payment.c_bankaccount_id c_bankaccount.c_bankaccount_id Null on delete 
cbankstatement_ibankstatement i_bankstatement.c_bankstatement_id c_bankstatement.c_bankstatement_id Null on delete 
cbankstmtline_ibankstmt i_bankstatement.c_bankstatementline_id c_bankstatementline.c_bankstatementline_id Null on delete 
cbolocation_iorder i_order.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Null on delete 
cbpartner_aduser ad_user.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_cbankstatementline c_bankstatementline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cbplocation c_bpartner_location.c_bpartner_id c_bpartner.c_bpartner_id Cascade on delete 
cbpartner_ccharge c_charge.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cinvoice c_invoice.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_corder c_order.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_cpayment c_payment.c_bpartner_id c_bpartner.c_bpartner_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_gljournalline gl_journalline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_iasset i_asset.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_ibankstatement i_bankstatement.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_ibpartner i_bpartner.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_ifajournal i_fajournal.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_igljournal i_gljournal.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_iinvoice i_invoice.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_imovement i_movement.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_iorder i_order.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_ipayment i_payment.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_ipricelist i_pricelist.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_iproduct i_product.c_bpartner_id c_bpartner.c_bpartner_id Null on delete 
cbpartner_mshipper m_shipper.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_pareportsource pa_reportsource.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_soline c_orderline.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartner_vc c_validcombination.c_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerbill_corder c_order.bill_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnerlocation_corder c_order.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_iasset i_asset.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocation_ibpartner i_bpartner.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Null on delete 
cbpartnerlocation_soline c_orderline.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbpartnerlocbillto_iorder i_order.billto_id c_bpartner_location.c_bpartner_location_id Null on delete 
cbpartnerpay_corder c_order.pay_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_cproject c_project.c_bpartnersr_id c_bpartner.c_bpartner_id Restrict delete 
cbpartnersr_ifixedasset i_fixedasset.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 
cbpgroup_ibpartner i_bpartner.c_bp_group_id c_bp_group.c_bp_group_id Null on delete 
cbplocation_aduser ad_user.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_cproject c_project.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocation_iinvoice i_invoice.c_bpartner_location_id c_bpartner_location.c_bpartner_location_id Null on delete 
cbplocationbill_corder c_order.bill_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbplocationpay_corder c_order.pay_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
cbstatement_cbstatementline c_bankstatementline.c_bankstatement_id c_bankstatement.c_bankstatement_id Cascade on delete 
ccampaign_aduser ad_user.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cinvoice c_invoice.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cinvoiceline c_invoiceline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_corder c_order.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_corderline c_orderline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cpayment c_payment.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_cproject c_project.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_gljournalline gl_journalline.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_ifajournal i_fajournal.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_igljournal i_gljournal.c_campaign_id c_campaign.c_campaign_id Null on delete 
ccampaign_iinvoice i_invoice.c_campaign_id c_campaign.c_campaign_id Null on delete 
ccampaign_imovement i_movement.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_iorder i_order.c_campaign_id c_campaign.c_campaign_id Null on delete 
ccampaign_minventory m_inventory.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccampaign_pareportsource pa_reportsource.c_campaign_id c_campaign.c_campaign_id Restrict delete 
ccharge_cbankstmtlime c_bankstatementline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoice c_invoice.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cinvoiceline c_invoiceline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_corder c_order.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_corderline c_orderline.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_cpayment c_payment.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_ibankstmt i_bankstatement.c_charge_id c_charge.c_charge_id Null on delete 
ccharge_iinventory i_inventory.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_iinvoice i_invoice.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_iorder i_order.c_charge_id c_charge.c_charge_id Restrict delete 
ccharge_ipayment i_payment.c_charge_id c_charge.c_charge_id Null on delete 
ccharge_minventoryline m_inventoryline.c_charge_id c_charge.c_charge_id Restrict delete 
cconversionrate_iconvrate i_conversion_rate.c_conversion_rate_id c_conversion_rate.c_conversion_rate_id Null on delete 
cconversiontype_cconvrate c_conversion_rate.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_cinvoice c_invoice.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_corder c_order.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_cpayment c_payment.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_gljournal gl_journal.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_gljournalline gl_journalline.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconversiontype_igljournal i_gljournal.c_conversiontype_id c_conversiontype.c_conversiontype_id Null on delete 
cconversiontype_minventory m_inventory.c_conversiontype_id c_conversiontype.c_conversiontype_id Restrict delete 
cconvtype_iconvrate i_conversion_rate.c_conversiontype_id c_conversiontype.c_conversiontype_id Null on delete 
ccountry_ccountry c_country.c_country_id c_country.c_country_id Restrict delete 
ccountry_cregion c_region.c_country_id c_country.c_country_id Restrict delete 
ccountry_iinvoice i_invoice.c_country_id c_country.c_country_id Null on delete 
ccountry_iorder i_order.c_country_id c_country.c_country_id Null on delete 
ccountry_ipartner i_bpartner.c_country_id c_country.c_country_id Null on delete 
ccurrency_cbankaccount c_bankaccount.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cbankstmtline c_bankstatementline.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cconversionrate c_conversion_rate.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ccountry c_country.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_celementvalue c_elementvalue.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cinvoice c_invoice.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_corder c_order.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_corderline c_orderline.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cpayment c_payment.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_cproject c_project.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_gljournal gl_journal.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_gljournalbatch gl_journalbatch.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_gljournalline gl_journalline.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ibankstatement i_bankstatement.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_iconvrate i_conversion_rate.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_iconvrateto i_conversion_rate.c_currency_id_to c_currency.c_currency_id Null on delete 
ccurrency_ifajournal i_fajournal.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ifixedasset i_fixedasset.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_igljournal i_gljournal.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_iinvoice i_invoice.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_iorder i_order.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_ipayment i_payment.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_ipricelist i_pricelist.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_iproduct i_product.c_currency_id c_currency.c_currency_id Null on delete 
ccurrency_minventory m_inventory.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_mpricelist m_pricelist.c_currency_id c_currency.c_currency_id Restrict delete 
ccurrency_mproductpo m_product_po.c_currency_id c_currency.c_currency_id Restrict delete 
cdoctype_cbankstatement c_bankstatement.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_cinvoice c_invoice.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_cpayment c_payment.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_gljournal gl_journal.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_gljournalbatch gl_journalbatch.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_ifajournal i_fajournal.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_igljournal i_gljournal.c_doctype_id c_doctype.c_doctype_id Null on delete 
cdoctype_iinventory i_inventory.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_iinvoice i_invoice.c_doctype_id c_doctype.c_doctype_id Null on delete 
cdoctype_imovement i_movement.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_iorder i_order.c_doctype_id c_doctype.c_doctype_id Null on delete 
cdoctype_ipayment i_payment.c_doctype_id c_doctype.c_doctype_id Null on delete 
cdoctype_minventory m_inventory.c_doctype_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_shipment c_doctype.c_doctypeshipment_id c_doctype.c_doctype_id Restrict delete 
cdoctypedifference_cdoctype c_doctype.c_doctypedifference_id c_doctype.c_doctype_id Restrict delete 
cdoctypetarget_cinvoice c_invoice.c_doctypetarget_id c_doctype.c_doctype_id Restrict delete 
cdoctypetarget_corder c_order.c_doctypetarget_id c_doctype.c_doctype_id Restrict delete 
celemenrvalueuser1_cinvline c_invoiceline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser1_corderline c_orderline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_cinvline c_invoiceline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_corder c_order.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celemenrvalueuser2_corderline c_orderline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celement_celementvalue c_elementvalue.c_element_id c_element.c_element_id Cascade on delete 
celement_ielementvalue i_elementvalue.c_element_id c_element.c_element_id Null on delete 
celementvalue_ielementvalue i_elementvalue.c_elementvalue_id c_elementvalue.c_elementvalue_id Null on delete 
celementvalue_ireportline i_reportline.c_elementvalue_id c_elementvalue.c_elementvalue_id Null on delete 
celementvalue_pareportsource pa_reportsource.c_elementvalue_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueaccount_vc c_validcombination.account_id c_elementvalue.c_elementvalue_id Cascade on delete 
celementvalueuser1_cinvoice c_invoice.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_corder c_order.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_cpayment c_payment.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_minvent m_inventory.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser1_vc c_validcombination.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_cinvoice c_invoice.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_cpayment c_payment.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_minvent m_inventory.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celementvalueuser2_vc c_validcombination.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
celvalueaccount_igljournal i_gljournal.account_id c_elementvalue.c_elementvalue_id Null on delete 
celvalueuser2_igljournal i_gljournal.user2_id c_elementvalue.c_elementvalue_id Null on delete 
cevalueparent_ielementvalue i_elementvalue.parentelementvalue_id c_elementvalue.c_elementvalue_id Null on delete 
cevalueuser1_igljournal i_gljournal.user1_id c_elementvalue.c_elementvalue_id Null on delete 
cgreeting_aduser ad_user.c_greeting_id c_greeting.c_greeting_id Restrict delete 
cgreeting_cbpartner c_bpartner.c_greeting_id c_greeting.c_greeting_id Restrict delete 
cgreeting_ibpartner i_bpartner.c_greeting_id c_greeting.c_greeting_id Null on delete 
cinvliceline_iinvoice i_invoice.c_invoiceline_id c_invoiceline.c_invoiceline_id Null on delete 
cinvoice_cbankstatementline c_bankstatementline.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_cinvoiceline c_invoiceline.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cinvoicetax c_invoicetax.c_invoice_id c_invoice.c_invoice_id Cascade on delete 
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ibankstatement i_bankstatement.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_iinvoice i_invoice.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_ipayment i_payment.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoiceline_minoutlineconfirm m_inoutlineconfirm.c_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
clocation_aduser ad_user.c_location_id c_location.c_location_id Restrict delete 
clocation_cbplocation c_bpartner_location.c_location_id c_location.c_location_id Restrict delete 
clocation_iasset i_asset.c_location_id c_location.c_location_id Restrict delete 
clocation_iinvoice i_invoice.c_location_id c_location.c_location_id Null on delete 
clocation_iorder i_order.c_location_id c_location.c_location_id Null on delete 
clocation_pareportsource pa_reportsource.c_location_id c_location.c_location_id Restrict delete 
clocfrom_gljournalline gl_journalline.c_locfrom_id c_location.c_location_id Restrict delete 
clocfrom_ifajournal i_fajournal.c_locfrom_id c_location.c_location_id Restrict delete 
clocfrom_igljournal i_gljournal.c_locfrom_id c_location.c_location_id Null on delete 
clocto_gljournalline gl_journalline.c_locto_id c_location.c_location_id Restrict delete 
clocto_ifajournal i_fajournal.c_locto_id c_location.c_location_id Restrict delete 
clocto_igljournal i_gljournal.c_locto_id c_location.c_location_id Null on delete 
columnorg ad_column.ad_org_id ad_org.ad_org_id Restrict delete 
convoiceline_ref c_invoiceline.ref_invoiceline_id c_invoiceline.c_invoiceline_id Restrict delete 
corder_cinvoice c_invoice.c_order_id c_order.c_order_id Restrict delete 
corder_corderline c_orderline.c_order_id c_order.c_order_id Restrict delete 
corder_cordertax c_ordertax.c_order_id c_order.c_order_id Cascade on delete 
corder_cpayment c_payment.c_order_id c_order.c_order_id Restrict delete 
corder_iorder i_order.c_order_id c_order.c_order_id Null on delete 
corder_ref c_order.ref_order_id c_order.c_order_id Restrict delete 
corderline_cinvoiceline c_invoiceline.c_orderline_id c_orderline.c_orderline_id Restrict delete 
corderline_iorder i_order.c_orderline_id c_orderline.c_orderline_id Null on delete 
corderline_ref c_orderline.ref_orderline_id c_orderline.c_orderline_id Restrict delete 
cpayment_cbankstmtline c_bankstatementline.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_cinvoice c_invoice.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_corder c_order.c_payment_id c_payment.c_payment_id Restrict delete 
cpayment_ibankstatement i_bankstatement.c_payment_id c_payment.c_payment_id Null on delete 
cpayment_ipayment i_payment.c_payment_id c_payment.c_payment_id Null on delete 
cpaymentterm_cbpartner c_bpartner.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cinvoice c_invoice.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_cproject c_project.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cpaymentterm_iinvoice i_invoice.c_paymentterm_id c_paymentterm.c_paymentterm_id Null on delete 
cpaymentterm_iorder i_order.c_paymentterm_id c_paymentterm.c_paymentterm_id Null on delete 
cpaymentterm_soheader c_order.c_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cperiod_cacctschema c_acctschema.c_period_id c_period.c_period_id Restrict delete 
cperiod_ifajournal i_fajournal.c_period_id c_period.c_period_id Restrict delete 
cperiod_igljournal i_gljournal.c_period_id c_period.c_period_id Null on delete 
cpopaymentterm_cbpartner c_bpartner.po_paymentterm_id c_paymentterm.c_paymentterm_id Restrict delete 
cproject_cinvoice c_invoice.c_project_id c_project.c_project_id Restrict delete 
cproject_cinvoiceline c_invoiceline.c_project_id c_project.c_project_id Restrict delete 
cproject_corder c_order.c_project_id c_project.c_project_id Restrict delete 
cproject_corderline c_orderline.c_project_id c_project.c_project_id Restrict delete 
cproject_cpayment c_payment.c_project_id c_project.c_project_id Restrict delete 
cproject_gljournalline gl_journalline.c_project_id c_project.c_project_id Restrict delete 
cproject_ifajournal i_fajournal.c_project_id c_project.c_project_id Restrict delete 
cproject_igljournal i_gljournal.c_project_id c_project.c_project_id Null on delete 
cproject_iinvoice i_invoice.c_project_id c_project.c_project_id Null on delete 
cproject_imovement i_movement.c_project_id c_project.c_project_id Restrict delete 
cproject_iorder i_order.c_project_id c_project.c_project_id Null on delete 
cproject_minventory m_inventory.c_project_id c_project.c_project_id Restrict delete 
cproject_pareportsource pa_reportsource.c_project_id c_project.c_project_id Restrict delete 
cproject_vc c_validcombination.c_project_id c_project.c_project_id Restrict delete 
createdby_adimporttemplate ad_importtemplate.createdby ad_user.ad_user_id Restrict delete 
cregion_ibpartner i_bpartner.c_region_id c_region.c_region_id Null on delete 
cregion_iinvoice i_invoice.c_region_id c_region.c_region_id Null on delete 
cregion_iorder i_order.c_region_id c_region.c_region_id Null on delete 
csalesregion_bpartnerlocation c_bpartner_location.c_salesregion_id c_salesregion.c_salesregion_id Null on delete 
csalesregion_gljournalline gl_journalline.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregion_ifajournal i_fajournal.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregion_igljournal i_gljournal.c_salesregion_id c_salesregion.c_salesregion_id Null on delete 
csalesregion_pareportsource pa_reportsource.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
csalesregion_vc c_validcombination.c_salesregion_id c_salesregion.c_salesregion_id Restrict delete 
ctax_cinvoiceline c_invoiceline.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_cinvoicetax c_invoicetax.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_corderline c_orderline.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_cordertax c_ordertax.c_tax_id c_tax.c_tax_id Restrict delete 
ctax_iinvoice i_invoice.c_tax_id c_tax.c_tax_id Null on delete 
ctax_iorder i_order.c_tax_id c_tax.c_tax_id Null on delete 
ctax_parent c_tax.parent_tax_id c_tax.c_tax_id Restrict delete 
cuom_cinvoiceline c_invoiceline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_corderline c_orderline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_gljournalline gl_journalline.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_ifajournal i_fajournal.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_ifixedasset i_fixedasset.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_igljournal i_gljournal.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_iorder i_order.c_uom_id c_uom.c_uom_id Null on delete 
cuom_ipricelist i_pricelist.c_uom_id c_uom.c_uom_id Restrict delete 
cuom_iproduct i_product.c_uom_id c_uom.c_uom_id Null on delete 
cuom_mproduct m_product.c_uom_id c_uom.c_uom_id Restrict delete 
cvalidcombination_ifajournal i_fajournal.c_validcombination_id c_validcombination.c_validcombination_id Restrict delete 
cvalidcombination_igljournal i_gljournal.c_validcombination_id c_validcombination.c_validcombination_id Null on delete 
cvc_gljournalline gl_journalline.c_validcombination_id c_validcombination.c_validcombination_id Restrict delete 
dropshipbpartner_corder c_order.dropship_bpartner_id c_bpartner.c_bpartner_id Restrict delete 
dropshiplocation_corder c_order.dropship_location_id c_bpartner_location.c_bpartner_location_id Restrict delete 
dropshipuser_corder c_order.dropship_user_id ad_user.ad_user_id Restrict delete 
expembeddedformat_expformatlin exp_formatline.exp_embeddedformat_id exp_format.exp_format_id Restrict delete 
expformat_expformatline exp_formatline.exp_format_id exp_format.exp_format_id Restrict delete 
glbudget_gljournal gl_journal.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glbudget_ifajournal i_fajournal.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glbudget_igljournal i_gljournal.gl_budget_id gl_budget.gl_budget_id Null on delete 
glbudget_pareportline pa_reportline.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glcategory_cdoctype c_doctype.gl_category_id gl_category.gl_category_id Restrict delete 
glcategory_gljournal gl_journal.gl_category_id gl_category.gl_category_id Restrict delete 
glcategory_gljournalbatch gl_journalbatch.gl_category_id gl_category.gl_category_id Restrict delete 
glcategory_ifajournal i_fajournal.gl_category_id gl_category.gl_category_id Restrict delete 
glcategory_igljournal i_gljournal.gl_category_id gl_category.gl_category_id Null on delete 
gljourbelline_igljournal i_gljournal.gl_journalline_id gl_journalline.gl_journalline_id Null on delete 
gljournal_gljournalline gl_journalline.gl_journal_id gl_journal.gl_journal_id Cascade on delete 
gljournal_ifajournal i_fajournal.gl_journal_id gl_journal.gl_journal_id Restrict delete 
gljournal_igljournal i_gljournal.gl_journal_id gl_journal.gl_journal_id Null on delete 
gljournalbatch_gljournal gl_journal.gl_journalbatch_id gl_journalbatch.gl_journalbatch_id Cascade on delete 
gljournalbatch_ifajournal i_fajournal.gl_journalbatch_id gl_journalbatch.gl_journalbatch_id Restrict delete 
gljournalbatch_igljournal i_gljournal.gl_journalbatch_id gl_journalbatch.gl_journalbatch_id Null on delete 
gljournalline_ifajournal i_fajournal.gl_journalline_id gl_journalline.gl_journalline_id Restrict delete 
linkorder_corder c_order.link_order_id c_order.c_order_id Null on delete 
linkorderline_corderline c_orderline.link_orderline_id c_orderline.c_orderline_id Null on delete 
m_product_productpo m_product_po.m_product_id m_product.m_product_id Cascade on delete 
m_productpo_org m_product_po.ad_org_id ad_org.ad_org_id Restrict delete 
m_warehouse_locator m_locator.m_warehouse_id m_warehouse.m_warehouse_id Cascade on delete 
m_warehouse_org m_warehouse.ad_org_id ad_org.ad_org_id Restrict delete 
m_wh_locator_org m_locator.ad_org_id ad_org.ad_org_id Restrict delete 
mattributesetinstance_iasset i_asset.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_cinvoiceline c_invoiceline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_corderline c_orderline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_minventoryline m_inventoryline.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mattrsetinst_mproduct m_product.m_attributesetinstance_id m_attributesetinstance.m_attributesetinstance_id Restrict delete 
mcostingline_iinventory i_inventory.m_costingline_id m_inventoryline.m_inventoryline_id Restrict delete 
minoutlineconfirm_import i_inoutlineconfirm.m_inoutlineconfirm_id m_inoutlineconfirm.m_inoutlineconfirm_id Cascade on delete 
minventory_iinventory i_inventory.m_inventory_id m_inventory.m_inventory_id Null on delete 
minventory_minventoryline m_inventoryline.m_inventory_id m_inventory.m_inventory_id Cascade on delete 
minventoryline_iinventory i_inventory.m_inventoryline_id m_inventoryline.m_inventoryline_id Null on delete 
minventoryline_minoutlineconfi m_inoutlineconfirm.m_inventoryline_id m_inventoryline.m_inventoryline_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 
mlocator_iasset i_asset.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_ifixedasset i_fixedasset.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_iinventory i_inventory.m_locator_id m_locator.m_locator_id Null on delete 
mlocator_imovement i_movement.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_minventoryline m_inventoryline.m_locator_id m_locator.m_locator_id Restrict delete 
mlocator_mproduct m_product.m_locator_id m_locator.m_locator_id Restrict delete 
mlocatorto_imovement i_movement.m_locatorto_id m_locator.m_locator_id Restrict delete 
mpricelist_cbpartner c_bpartner.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_cbpgroup c_bp_group.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_cinvoice c_invoice.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelist_iinvoice i_invoice.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_iorder i_order.m_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelist_ipricelist i_pricelist.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelist_soheader c_order.m_pricelist_id m_pricelist.m_pricelist_id Restrict delete 
mpricelistpo_cbpgroup c_bp_group.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mpricelistpo_cbuspartner c_bpartner.po_pricelist_id m_pricelist.m_pricelist_id Null on delete 
mproduct_cinvoiceline c_invoiceline.m_product_id m_product.m_product_id Restrict delete 
mproduct_corderline c_orderline.m_product_id m_product.m_product_id Restrict delete 
mproduct_gljournalline gl_journalline.m_product_id m_product.m_product_id Restrict delete 
mproduct_iasset i_asset.m_product_id m_product.m_product_id Restrict delete 
mproduct_ifajournal i_fajournal.m_product_id m_product.m_product_id Restrict delete 
mproduct_ifixedasset i_fixedasset.m_product_id m_product.m_product_id Restrict delete 
mproduct_iinventory i_inventory.m_product_id m_product.m_product_id Null on delete 
mproduct_imovement i_movement.m_product_id m_product.m_product_id Restrict delete 
mproduct_iorder i_order.m_product_id m_product.m_product_id Null on delete 
mproduct_ipricelist i_pricelist.m_product_id m_product.m_product_id Restrict delete 
mproduct_iproduct i_product.m_product_id m_product.m_product_id Null on delete 
mproduct_minventoryline m_inventoryline.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_ogljournal i_gljournal.m_product_id m_product.m_product_id Null on delete 
mproduct_pareportsource pa_reportsource.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 
mproductcategory_iproduct i_product.m_product_category_id m_product_category.m_product_category_id Null on delete 
mreservelocator_mwarehouse m_warehouse.m_reservelocator_id m_locator.m_locator_id Restrict delete 
mshipper_corder c_order.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_corderline c_orderline.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_imovement i_movement.m_shipper_id m_shipper.m_shipper_id Restrict delete 
mshipper_iorder i_order.m_shipper_id m_shipper.m_shipper_id Null on delete 
mwarehouse_corder c_order.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_corderline c_orderline.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_cproject c_project.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehouse_iinventory i_inventory.m_warehouse_id m_warehouse.m_warehouse_id Null on delete 
mwarehouse_iorder i_order.m_warehouse_id m_warehouse.m_warehouse_id Null on delete 
mwarehouse_minventory m_inventory.m_warehouse_id m_warehouse.m_warehouse_id Restrict delete 
mwarehousesource_mwarehouse m_warehouse.m_warehousesource_id m_warehouse.m_warehouse_id Restrict delete 
nproduct_iinvoice i_invoice.m_product_id m_product.m_product_id Null on delete 
pareportline_ireportline i_reportline.pa_reportline_id pa_reportline.pa_reportline_id Null on delete 
pareportline_oper1 pa_reportline.oper_1_id pa_reportline.pa_reportline_id Null on delete 
pareportline_oper2 pa_reportline.oper_2_id pa_reportline.pa_reportline_id Null on delete 
pareportline_parent pa_reportline.parent_id pa_reportline.pa_reportline_id Null on delete 
pareportline_pareportsource pa_reportsource.pa_reportline_id pa_reportline.pa_reportline_id Cascade on delete 
pareportlineset_ireportline i_reportline.pa_reportlineset_id pa_reportlineset.pa_reportlineset_id Null on delete 
pareportlineset_line pa_reportline.pa_reportlineset_id pa_reportlineset.pa_reportlineset_id Cascade on delete 
pareportsource_ireportline i_reportline.pa_reportsource_id pa_reportsource.pa_reportsource_id Null on delete 
quotationorder_corder c_order.quotationorder_id c_order.c_order_id Restrict delete 
refpayment_cpayment c_payment.ref_payment_id c_payment.c_payment_id Restrict delete 
relatedinvoice_cinvoice c_invoice.relatedinvoice_id c_invoice.c_invoice_id Restrict delete 
reversal_cinvoice c_invoice.reversal_id c_invoice.c_invoice_id Restrict delete 
reversal_cpayment c_payment.reversal_id c_payment.c_payment_id Restrict delete 
reversal_gljournal gl_journal.reversal_id gl_journal.gl_journal_id Restrict delete 
reversal_gljournalbatch gl_journalbatch.reversal_id gl_journalbatch.gl_journalbatch_id Restrict delete 
reversal_minventory m_inventory.reversal_id m_inventory.m_inventory_id Restrict delete 
reversalline_minventoryline m_inventoryline.reversalline_id m_inventoryline.m_inventoryline_id Restrict delete 
rinterestarea_ibpartner i_bpartner.r_interestarea_id r_interestarea.r_interestarea_id Restrict delete 
salesrep_aduser ad_user.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_csalesregion c_salesregion.salesrep_id ad_user.ad_user_id Restrict delete 
salesrep_mproduct m_product.salesrep_id ad_user.ad_user_id Restrict delete 
socampaign_vc c_validcombination.c_campaign_id c_campaign.c_campaign_id Restrict delete 
sresourceassign_cinvoiceline c_invoiceline.s_resourceassignment_id s_resourceassignment.s_resourceassignment_id Restrict delete 
sresourceassign_corderline c_orderline.s_resourceassignment_id s_resourceassignment.s_resourceassignment_id Restrict delete 
updatedby_adimporttemplate ad_importtemplate.updatedby ad_user.ad_user_id Restrict delete 
user1_gljournalline gl_journalline.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
user1_ifajournal i_fajournal.user1_id c_elementvalue.c_elementvalue_id Restrict delete 
user2_gljournalline gl_journalline.user2_id c_elementvalue.c_elementvalue_id Restrict delete 
user2_ifajournal i_fajournal.user2_id c_elementvalue.c_elementvalue_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected