SchemaSpy Analysis of idempiere9.adempiere - ConstraintsGeneral Ledger Generated by
Quality Systems & Solutions
34 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
aliasvalidcombination_gljourna gl_journalline.alias_validcombination_id c_validcombination.c_validcombination_id Restrict delete 
c_acctschema_gl_journal gl_journal.c_acctschema_id c_acctschema.c_acctschema_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 
cacctschema_cvalidcombination c_validcombination.c_acctschema_id c_acctschema.c_acctschema_id Cascade on delete 
cacctschema_glbudgetcontrol gl_budgetcontrol.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_gldist gl_distribution.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_glfund gl_fund.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cacctschema_qssjournalgenerato gl_journalgenerator.c_acctschema_id c_acctschema.c_acctschema_id Restrict delete 
cdoctype_gldistribution gl_distribution.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_invoice c_doctype.c_doctypeinvoice_id c_doctype.c_doctype_id Restrict delete 
cdoctype_proforma c_doctype.c_doctypeproforma_id c_doctype.c_doctype_id Restrict delete 
cdoctype_qssjournalgenerator gl_journalgenerator.c_doctype_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 
cperiod_cacctschema c_acctschema.c_period_id c_period.c_period_id Restrict delete 
cvc_gljournalline gl_journalline.c_validcombination_id c_validcombination.c_validcombination_id Restrict delete 
glbudget_glbudgetcontrol gl_budgetcontrol.gl_budget_id gl_budget.gl_budget_id Restrict delete 
glbudget_gljournal gl_journal.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_gljournalgenerators gl_journalgeneratorsource.gl_category_id gl_category.gl_category_id Restrict delete 
glcategory_qssjournalgenerator gl_journalgenerator.gl_category_id gl_category.gl_category_id Restrict delete 
gldistribution_gldistline gl_distributionline.gl_distribution_id gl_distribution.gl_distribution_id Cascade on delete 
glfund_glfundrestriction gl_fundrestriction.gl_fund_id gl_fund.gl_fund_id Cascade on delete 
gljournal_gljournalline gl_journalline.gl_journal_id gl_journal.gl_journal_id Cascade on delete 
gljournalbatch_gljournal gl_journal.gl_journalbatch_id gl_journalbatch.gl_journalbatch_id Cascade on delete 
qssjournalgenerator_qssjournal gl_journalgeneratorline.gl_journalgenerator_id gl_journalgenerator.gl_journalgenerator_id Restrict delete 
qssjournalgeneratorline_qssjou gl_journalgeneratorsource.gl_journalgeneratorline_id gl_journalgeneratorline.gl_journalgeneratorline_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 

Check Constraints:

Table Constraint Name Constraint
None detected