SchemaSpy Analysis of idempiere11.adempiere - ConstraintsInvoice Dunning Generated by
Quality Systems & Solutions
23 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
adprintformat_cdunninglevel c_dunninglevel.dunning_printformat_id ad_printformat.ad_printformat_id Restrict delete 
adprintformatinv_cbpartner c_bpartner.invoice_printformat_id ad_printformat.ad_printformat_id Restrict delete 
cbpartner_cdunningrunentry c_dunningrunentry.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_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 
cdunning_cbpartner c_bpartner.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunning_cdunninglevel c_dunninglevel.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunning_cdunningrun c_dunningrun.c_dunning_id c_dunning.c_dunning_id Restrict delete 
cdunninglevel_cdunningrun c_dunningrun.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunninglevel_cdunningrunentry c_dunningrunentry.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunninglevel_cinvoice c_invoice.c_dunninglevel_id c_dunninglevel.c_dunninglevel_id Restrict delete 
cdunningrun_cdunningrunentry c_dunningrunentry.c_dunningrun_id c_dunningrun.c_dunningrun_id Cascade on delete 
cdunningrunentry_line c_dunningrunline.c_dunningrunentry_id c_dunningrunentry.c_dunningrunentry_id Cascade on delete 
cinvoice_cdunningrunline c_dunningrunline.c_invoice_id c_invoice.c_invoice_id Null on delete 
cinvoice_cpayment c_payment.c_invoice_id c_invoice.c_invoice_id Restrict delete 
cinvoice_ref c_invoice.ref_invoice_id c_invoice.c_invoice_id Restrict delete 
cpayment_cdunningrunline c_dunningrunline.c_payment_id c_payment.c_payment_id Null on delete 
cpayment_cinvoice c_invoice.c_payment_id c_payment.c_payment_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 

Check Constraints:

Table Constraint Name Constraint
None detected