SchemaSpy Analysis of openpetra_trunk.public - ConstraintsOpenPetra Version 3 Database | Generated by SchemaSpy |
1325 Foreign Key Constraints: |
|
Constraint Name | Child Column | Parent Column | Delete Rule |
---|---|---|---|
a_account_fk1 | a_account.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_account_fk2 | a_account.a_budget_type_code_c | a_budget_type.a_budget_type_code_c | Restrict delete |
a_account_fk3 | a_account.a_foreign_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_account_fk4 | a_account.p_banking_details_key_i | p_banking_details.p_banking_details_key_i | Restrict delete |
a_account_fkcr | a_account.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_account_fkmd | a_account.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_account_hierarchy_detail_fk1 | a_account_hierarchy_detail.a_ledger_number_i a_account_hierarchy_detail.a_account_hierarchy_code_c |
a_account_hierarchy.a_ledger_number_i a_account_hierarchy.a_account_hierarchy_code_c |
Restrict delete |
a_account_hierarchy_detail_fk2 | a_account_hierarchy_detail.a_ledger_number_i a_account_hierarchy_detail.a_reporting_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_account_hierarchy_detail_fk3 | a_account_hierarchy_detail.a_ledger_number_i a_account_hierarchy_detail.a_account_code_to_report_to_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_account_hierarchy_detail_fkcr | a_account_hierarchy_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_account_hierarchy_detail_fkmd | a_account_hierarchy_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_account_hierarchy_fk1 | a_account_hierarchy.a_ledger_number_i a_account_hierarchy.a_root_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_account_hierarchy_fkcr | a_account_hierarchy.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_account_hierarchy_fkmd | a_account_hierarchy.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_account_property_code_fkcr | a_account_property_code.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_account_property_code_fkmd | a_account_property_code.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_account_property_fk1 | a_account_property.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_account_property_fk2 | a_account_property.a_ledger_number_i a_account_property.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_account_property_fk3 | a_account_property.a_property_code_c | a_account_property_code.a_property_code_c | Restrict delete |
a_account_property_fkcr | a_account_property.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_account_property_fkmd | a_account_property.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_accounting_period_fk1 | a_accounting_period.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_accounting_period_fkcr | a_accounting_period.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_accounting_period_fkmd | a_accounting_period.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_accounting_system_param_fk1 | a_accounting_system_parameter.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_accounting_system_parameter_fkcr | a_accounting_system_parameter.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_accounting_system_parameter_fkmd | a_accounting_system_parameter.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_attribute_fk1 | a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_analysis_attribute_fk2 | a_analysis_attribute.a_analysis_type_code_c | a_analysis_type.a_analysis_type_code_c | Restrict delete |
a_analysis_attribute_fk3 | a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_analysis_attribute_fkcr | a_analysis_attribute.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_attribute_fkmd | a_analysis_attribute.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_store_table_fkcr | a_analysis_store_table.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_store_table_fkmd | a_analysis_store_table.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_type_fkcr | a_analysis_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_analysis_type_fkmd | a_analysis_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_anal_attrib_fk1 | a_ap_anal_attrib.a_ledger_number_i a_ap_anal_attrib.a_ap_number_i a_ap_anal_attrib.a_detail_number_i |
a_ap_document_detail.a_ledger_number_i a_ap_document_detail.a_ap_number_i a_ap_document_detail.a_detail_number_i |
Restrict delete |
a_ap_anal_attrib_fk2 | a_ap_anal_attrib.a_ledger_number_i a_ap_anal_attrib.a_account_code_c a_ap_anal_attrib.a_analysis_type_code_c |
a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c a_analysis_attribute.a_analysis_type_code_c |
Restrict delete |
a_ap_anal_attrib_fk3 | a_ap_anal_attrib.a_ledger_number_i a_ap_anal_attrib.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ap_anal_attrib_fk4 | a_ap_anal_attrib.a_ledger_number_i a_ap_anal_attrib.a_analysis_type_code_c a_ap_anal_attrib.a_analysis_attribute_value_c |
a_freeform_analysis.a_ledger_number_i a_freeform_analysis.a_analysis_type_code_c a_freeform_analysis.a_analysis_value_c |
Restrict delete |
a_ap_anal_attrib_fkcr | a_ap_anal_attrib.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_anal_attrib_fkmd | a_ap_anal_attrib.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_detail_fk1 | a_ap_document_detail.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ap_document_detail_fk2 | a_ap_document_detail.a_ledger_number_i a_ap_document_detail.a_ap_number_i |
a_ap_document.a_ledger_number_i a_ap_document.a_ap_number_i |
Restrict delete |
a_ap_document_detail_fk3 | a_ap_document_detail.a_ledger_number_i a_ap_document_detail.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_ap_document_detail_fk4 | a_ap_document_detail.a_ledger_number_i a_ap_document_detail.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ap_document_detail_fkcr | a_ap_document_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_detail_fkmd | a_ap_document_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_fk1 | a_ap_document.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ap_document_fk2 | a_ap_document.p_partner_key_n | a_ap_supplier.p_partner_key_n | Restrict delete |
a_ap_document_fk3 | a_ap_document.a_ledger_number_i a_ap_document.a_ap_account_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ap_document_fkcr | a_ap_document.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_fkmd | a_ap_document.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_payment_fk1 | a_ap_document_payment.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ap_document_payment_fk2 | a_ap_document_payment.a_ledger_number_i a_ap_document_payment.a_ap_number_i |
a_ap_document.a_ledger_number_i a_ap_document.a_ap_number_i |
Restrict delete |
a_ap_document_payment_fk3 | a_ap_document_payment.a_ledger_number_i a_ap_document_payment.a_payment_number_i |
a_ap_payment.a_ledger_number_i a_ap_payment.a_payment_number_i |
Restrict delete |
a_ap_document_payment_fkcr | a_ap_document_payment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_document_payment_fkmd | a_ap_document_payment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_payment_fk1 | a_ap_payment.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ap_payment_fk2 | a_ap_payment.s_user_id_c | s_user.s_user_id_c | Restrict delete |
a_ap_payment_fk3 | a_ap_payment.a_ledger_number_i a_ap_payment.a_bank_account_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ap_payment_fkcr | a_ap_payment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_payment_fkmd | a_ap_payment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_supplier_fk1 | a_ap_supplier.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
a_ap_supplier_fk2 | a_ap_supplier.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_ap_supplier_fkcr | a_ap_supplier.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ap_supplier_fkmd | a_ap_supplier.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_article_fk1 | a_ar_article.a_ar_category_code_c | a_ar_category.a_ar_category_code_c | Restrict delete |
a_ar_article_fk2 | a_ar_article.a_tax_type_code_c | a_tax_type.a_tax_type_code_c | Restrict delete |
a_ar_article_fkcr | a_ar_article.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_article_fkmd | a_ar_article.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_article_price_fkcr | a_ar_article_price.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_article_price_fkmd | a_ar_article_price.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_category_fkcr | a_ar_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_category_fkmd | a_ar_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_default_discount_fkcr | a_ar_default_discount.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_default_discount_fkmd | a_ar_default_discount.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_discount_fkcr | a_ar_discount.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_discount_fkmd | a_ar_discount.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_discount_per_category_fkcr | a_ar_discount_per_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_discount_per_category_fkmd | a_ar_discount_per_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_detail_discount_fk1 | a_ar_invoice_detail_discount.a_ledger_number_i a_ar_invoice_detail_discount.a_invoice_key_i a_ar_invoice_detail_discount.a_detail_number_i |
a_ar_invoice_detail.a_ledger_number_i a_ar_invoice_detail.a_invoice_key_i a_ar_invoice_detail.a_detail_number_i |
Restrict delete |
a_ar_invoice_detail_discount_fk2 | a_ar_invoice_detail_discount.a_ar_discount_code_c a_ar_invoice_detail_discount.a_ar_discount_date_valid_from_d |
a_ar_discount.a_ar_discount_code_c a_ar_discount.a_ar_date_valid_from_d |
Restrict delete |
a_ar_invoice_detail_discount_fkcr | a_ar_invoice_detail_discount.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_detail_discount_fkmd | a_ar_invoice_detail_discount.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_detail_fk1 | a_ar_invoice_detail.a_ledger_number_i a_ar_invoice_detail.a_invoice_key_i |
a_ar_invoice.a_ledger_number_i a_ar_invoice.a_key_i |
Restrict delete |
a_ar_invoice_detail_fk2 | a_ar_invoice_detail.a_ledger_number_i a_ar_invoice_detail.a_tax_type_code_c a_ar_invoice_detail.a_tax_rate_code_c a_ar_invoice_detail.a_tax_valid_from_d |
a_tax_table.a_ledger_number_i a_tax_table.a_tax_type_code_c a_tax_table.a_tax_rate_code_c a_tax_table.a_tax_valid_from_d |
Restrict delete |
a_ar_invoice_detail_fk3 | a_ar_invoice_detail.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_ar_invoice_detail_fk4 | a_ar_invoice_detail.a_ar_article_code_c | a_ar_article.a_ar_article_code_c | Restrict delete |
a_ar_invoice_detail_fk5 | a_ar_invoice_detail.a_ar_article_code_c a_ar_invoice_detail.a_ar_article_price_d |
a_ar_article_price.a_ar_article_code_c a_ar_article_price.a_ar_date_valid_from_d |
Restrict delete |
a_ar_invoice_detail_fkcr | a_ar_invoice_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_detail_fkmd | a_ar_invoice_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_discount_fk1 | a_ar_invoice_discount.a_ledger_number_i a_ar_invoice_discount.a_invoice_key_i |
a_ar_invoice.a_ledger_number_i a_ar_invoice.a_key_i |
Restrict delete |
a_ar_invoice_discount_fk2 | a_ar_invoice_discount.a_ar_discount_code_c a_ar_invoice_discount.a_ar_discount_date_valid_from_d |
a_ar_discount.a_ar_discount_code_c a_ar_discount.a_ar_date_valid_from_d |
Restrict delete |
a_ar_invoice_discount_fkcr | a_ar_invoice_discount.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_discount_fkmd | a_ar_invoice_discount.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_fk1 | a_ar_invoice.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
a_ar_invoice_fk2 | a_ar_invoice.a_ledger_number_i a_ar_invoice.a_special_tax_type_code_c a_ar_invoice.a_special_tax_rate_code_c a_ar_invoice.a_special_tax_valid_from_d |
a_tax_table.a_ledger_number_i a_tax_table.a_tax_type_code_c a_tax_table.a_tax_rate_code_c a_tax_table.a_tax_valid_from_d |
Restrict delete |
a_ar_invoice_fk3 | a_ar_invoice.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_ar_invoice_fkcr | a_ar_invoice.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ar_invoice_fkmd | a_ar_invoice.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_batch_fk1 | a_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_batch_fkcr | a_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_batch_fkmd | a_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_fk1 | a_budget.a_ledger_number_i a_budget.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_budget_fk2 | a_budget.a_ledger_number_i a_budget.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_budget_fk3 | a_budget.a_budget_type_code_c | a_budget_type.a_budget_type_code_c | Restrict delete |
a_budget_fk4 | a_budget.a_ledger_number_i a_budget.a_year_i a_budget.a_revision_i |
a_budget_revision.a_ledger_number_i a_budget_revision.a_year_i a_budget_revision.a_revision_i |
Restrict delete |
a_budget_fkcr | a_budget.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_fkmd | a_budget.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_period_fk1 | a_budget_period.a_budget_sequence_i | a_budget.a_budget_sequence_i | Restrict delete |
a_budget_period_fkcr | a_budget_period.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_period_fkmd | a_budget_period.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_revision_fkcr | a_budget_revision.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_revision_fkmd | a_budget_revision.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_type_fk1 | a_budget_type.a_budget_process_to_call_c | s_file.s_file_name_c | Restrict delete |
a_budget_type_fkcr | a_budget_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_budget_type_fkmd | a_budget_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_corporate_exchange_rate_fk1 | a_corporate_exchange_rate.a_from_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_corporate_exchange_rate_fk2 | a_corporate_exchange_rate.a_to_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_corporate_exchange_rate_fkcr | a_corporate_exchange_rate.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_corporate_exchange_rate_fkmd | a_corporate_exchange_rate.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_cost_centre_fk1 | a_cost_centre.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_cost_centre_fk2 | a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_type_c |
a_cost_centre_types.a_ledger_number_i a_cost_centre_types.a_cost_centre_type_c |
Restrict delete |
a_cost_centre_fk3 | a_cost_centre.a_key_focus_area_c | a_key_focus_area.a_key_focus_area_c | Restrict delete |
a_cost_centre_fkcr | a_cost_centre.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_cost_centre_fkmd | a_cost_centre.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_cost_centre_types_fk1 | a_cost_centre_types.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_cost_centre_types_fkcr | a_cost_centre_types.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_cost_centre_types_fkmd | a_cost_centre_types.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_crdt_note_invoice_link_fk1 | a_crdt_note_invoice_link.a_ledger_number_i a_crdt_note_invoice_link.a_credit_note_number_i |
a_ap_document.a_ledger_number_i a_ap_document.a_ap_number_i |
Restrict delete |
a_crdt_note_invoice_link_fk2 | a_crdt_note_invoice_link.a_ledger_number_i a_crdt_note_invoice_link.a_invoice_number_i |
a_ap_document.a_ledger_number_i a_ap_document.a_ap_number_i |
Restrict delete |
a_crdt_note_invoice_link_fkcr | a_crdt_note_invoice_link.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_crdt_note_invoice_link_fkmd | a_crdt_note_invoice_link.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_currency_fk1 | a_currency.p_country_code_c | p_country.p_country_code_c | Restrict delete |
a_currency_fkcr | a_currency.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_currency_fkmd | a_currency.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_currency_language_fk1 | a_currency_language.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_currency_language_fk2 | a_currency_language.p_language_code_c | p_language.p_language_code_c | Restrict delete |
a_currency_language_fkcr | a_currency_language.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_currency_language_fkmd | a_currency_language.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_daily_exchange_rate_fk1 | a_daily_exchange_rate.a_from_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_daily_exchange_rate_fk2 | a_daily_exchange_rate.a_to_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_daily_exchange_rate_fkcr | a_daily_exchange_rate.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_daily_exchange_rate_fkmd | a_daily_exchange_rate.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_email_destination_fk1 | a_email_destination.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
a_email_destination_fkcr | a_email_destination.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_email_destination_fkmd | a_email_destination.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_account_fk1 | a_ep_account.a_banking_details_key_i | p_banking_details.p_banking_details_key_i | Restrict delete |
a_ep_account_fk2 | a_ep_account.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ep_account_fk3 | a_ep_account.a_ledger_number_i a_ep_account.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ep_account_fk4 | a_ep_account.a_ledger_number_i a_ep_account.a_motivation_group_code_c a_ep_account.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
a_ep_account_fkcr | a_ep_account.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_account_fkmd | a_ep_account.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_document_payment_fk1 | a_ep_document_payment.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ep_document_payment_fk2 | a_ep_document_payment.a_ledger_number_i a_ep_document_payment.a_ap_number_i |
a_ap_document.a_ledger_number_i a_ap_document.a_ap_number_i |
Restrict delete |
a_ep_document_payment_fk3 | a_ep_document_payment.a_ledger_number_i a_ep_document_payment.a_payment_number_i |
a_ep_payment.a_ledger_number_i a_ep_payment.a_payment_number_i |
Restrict delete |
a_ep_document_payment_fkcr | a_ep_document_payment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_document_payment_fkmd | a_ep_document_payment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_match_fk1 | a_ep_match.a_ledger_number_i a_ep_match.a_motivation_group_code_c a_ep_match.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
a_ep_match_fk10 | a_ep_match.a_key_ministry_key_n | p_unit.p_partner_key_n | Restrict delete |
a_ep_match_fk2 | a_ep_match.p_recipient_key_n | p_partner.p_partner_key_n | Restrict delete |
a_ep_match_fk3 | a_ep_match.p_mailing_code_c | p_mailing.p_mailing_code_c | Restrict delete |
a_ep_match_fk4 | a_ep_match.a_recipient_ledger_number_n | p_partner.p_partner_key_n | Restrict delete |
a_ep_match_fk5 | a_ep_match.a_ledger_number_i a_ep_match.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_ep_match_fk6 | a_ep_match.a_method_of_giving_code_c | a_method_of_giving.a_method_of_giving_code_c | Restrict delete |
a_ep_match_fk7 | a_ep_match.a_method_of_payment_code_c | a_method_of_payment.a_method_of_payment_code_c | Restrict delete |
a_ep_match_fk8 | a_ep_match.p_donor_key_n | p_partner.p_partner_key_n | Restrict delete |
a_ep_match_fk9 | a_ep_match.a_ledger_number_i a_ep_match.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ep_match_fkcr | a_ep_match.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_match_fkmd | a_ep_match.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_payment_fk1 | a_ep_payment.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ep_payment_fk2 | a_ep_payment.s_user_id_c | s_user.s_user_id_c | Restrict delete |
a_ep_payment_fk3 | a_ep_payment.a_ledger_number_i a_ep_payment.a_bank_account_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ep_payment_fkcr | a_ep_payment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_payment_fkmd | a_ep_payment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_statement_fk1 | a_ep_statement.a_bank_account_key_i | p_banking_details.p_banking_details_key_i | Restrict delete |
a_ep_statement_fk2 | a_ep_statement.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_ep_statement_fk3 | a_ep_statement.a_ledger_number_i a_ep_statement.a_bank_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_ep_statement_fkcr | a_ep_statement.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_statement_fkmd | a_ep_statement.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_transaction_fk1 | a_ep_transaction.a_statement_key_i | a_ep_statement.a_statement_key_i | Restrict delete |
a_ep_transaction_fk2 | a_ep_transaction.a_ep_match_key_i | a_ep_match.a_ep_match_key_i | Restrict delete |
a_ep_transaction_fkcr | a_ep_transaction.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ep_transaction_fkmd | a_ep_transaction.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_fees_payable_fk1 | a_fees_payable.a_ledger_number_i a_fees_payable.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_fees_payable_fk2 | a_fees_payable.a_ledger_number_i a_fees_payable.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_fees_payable_fk3 | a_fees_payable.a_ledger_number_i a_fees_payable.a_dr_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_fees_payable_fkcr | a_fees_payable.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_fees_payable_fkmd | a_fees_payable.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_fees_receivable_fk1 | a_fees_receivable.a_ledger_number_i a_fees_receivable.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_fees_receivable_fk2 | a_fees_receivable.a_ledger_number_i a_fees_receivable.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_fees_receivable_fk3 | a_fees_receivable.a_ledger_number_i a_fees_receivable.a_dr_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_fees_receivable_fkcr | a_fees_receivable.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_fees_receivable_fkmd | a_fees_receivable.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_form_element_fk1 | a_form_element.a_form_code_c a_form_element.a_form_name_c |
a_form.a_form_code_c a_form.a_form_name_c |
Restrict delete |
a_form_element_fk2 | a_form_element.a_form_code_c a_form_element.a_form_element_type_code_c |
a_form_element_type.a_form_code_c a_form_element_type.a_form_element_type_code_c |
Restrict delete |
a_form_element_fkcr | a_form_element.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_form_element_fkmd | a_form_element.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_form_element_type_fkcr | a_form_element_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_form_element_type_fkmd | a_form_element_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_form_fkcr | a_form.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_form_fkmd | a_form.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_freeform_analysis_fk1 | a_freeform_analysis.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_freeform_analysis_fk2 | a_freeform_analysis.a_analysis_type_code_c | a_analysis_type.a_analysis_type_code_c | Restrict delete |
a_freeform_analysis_fkcr | a_freeform_analysis.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_freeform_analysis_fkmd | a_freeform_analysis.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_frequency_fkcr | a_frequency.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_frequency_fkmd | a_frequency.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_general_ledger_master_fk1 | a_general_ledger_master.a_ledger_number_i a_general_ledger_master.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_general_ledger_master_fk2 | a_general_ledger_master.a_ledger_number_i a_general_ledger_master.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_general_ledger_master_fkcr | a_general_ledger_master.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_general_ledger_master_fkmd | a_general_ledger_master.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_general_ledger_master_period_fkcr | a_general_ledger_master_period.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_general_ledger_master_period_fkmd | a_general_ledger_master_period.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_batch_fk1 | a_gift_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_gift_batch_fk2 | a_gift_batch.a_ledger_number_i a_gift_batch.a_bank_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_gift_batch_fk3 | a_gift_batch.a_ledger_number_i a_gift_batch.a_bank_cost_centre_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_gift_batch_fk4 | a_gift_batch.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_gift_batch_fkcr | a_gift_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_batch_fkmd | a_gift_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_detail_fk1 | a_gift_detail.a_ledger_number_i a_gift_detail.a_batch_number_i a_gift_detail.a_gift_transaction_number_i |
a_gift.a_ledger_number_i a_gift.a_batch_number_i a_gift.a_gift_transaction_number_i |
Restrict delete |
a_gift_detail_fk2 | a_gift_detail.a_ledger_number_i a_gift_detail.a_motivation_group_code_c a_gift_detail.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
a_gift_detail_fk3 | a_gift_detail.p_recipient_key_n | p_partner.p_partner_key_n | Restrict delete |
a_gift_detail_fk4 | a_gift_detail.p_mailing_code_c | p_mailing.p_mailing_code_c | Restrict delete |
a_gift_detail_fk5 | a_gift_detail.a_recipient_ledger_number_n | p_partner.p_partner_key_n | Restrict delete |
a_gift_detail_fk6 | a_gift_detail.a_ledger_number_i a_gift_detail.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_gift_detail_fkcr | a_gift_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_detail_fkmd | a_gift_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_fk1 | a_gift.a_ledger_number_i a_gift.a_batch_number_i |
a_gift_batch.a_ledger_number_i a_gift_batch.a_batch_number_i |
Restrict delete |
a_gift_fk2 | a_gift.a_method_of_giving_code_c | a_method_of_giving.a_method_of_giving_code_c | Restrict delete |
a_gift_fk3 | a_gift.a_method_of_payment_code_c | a_method_of_payment.a_method_of_payment_code_c | Restrict delete |
a_gift_fk4 | a_gift.p_donor_key_n | p_partner.p_partner_key_n | Restrict delete |
a_gift_fkcr | a_gift.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_gift_fkmd | a_gift.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_glm_period_fk1 | a_general_ledger_master_period.a_glm_sequence_i | a_general_ledger_master.a_glm_sequence_i | Restrict delete |
a_ich_stewardship_fk1 | a_ich_stewardship.a_ledger_number_i a_ich_stewardship.a_period_number_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_ich_stewardship_fk2 | a_ich_stewardship.a_ledger_number_i a_ich_stewardship.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_ich_stewardship_fkcr | a_ich_stewardship.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ich_stewardship_fkmd | a_ich_stewardship.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_journal_fk1 | a_journal.a_ledger_number_i a_journal.a_batch_number_i |
a_batch.a_ledger_number_i a_batch.a_batch_number_i |
Restrict delete |
a_journal_fk3 | a_journal.a_ledger_number_i a_journal.a_sub_system_code_c a_journal.a_transaction_type_code_c |
a_transaction_type.a_ledger_number_i a_transaction_type.a_sub_system_code_c a_transaction_type.a_transaction_type_code_c |
Restrict delete |
a_journal_fk4 | a_journal.a_transaction_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_journal_fkcr | a_journal.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_journal_fkmd | a_journal.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_key_focus_area_fkcr | a_key_focus_area.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_key_focus_area_fkmd | a_key_focus_area.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ledger_fk1 | a_ledger.a_tax_type_code_c | a_tax_type.a_tax_type_code_c | Restrict delete |
a_ledger_fk2 | a_ledger.a_country_code_c | p_country.p_country_code_c | Restrict delete |
a_ledger_fk3 | a_ledger.a_base_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_ledger_fk4 | a_ledger.a_intl_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_ledger_fkcr | a_ledger.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ledger_fkmd | a_ledger.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_ledger_init_flag_fk1 | a_ledger_init_flag.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_ledger_init_flag_fkcr | a_ledger_init_flag.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_ledger_init_flag_fkmd | a_ledger_init_flag.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_method_of_giving_fkcr | a_method_of_giving.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_method_of_giving_fkmd | a_method_of_giving.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_method_of_payment_fk1 | a_method_of_payment.a_process_to_call_c | s_file.s_file_name_c | Restrict delete |
a_method_of_payment_fkcr | a_method_of_payment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_method_of_payment_fkmd | a_method_of_payment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_detail_fee_fk1 | a_motivation_detail_fee.a_ledger_number_i a_motivation_detail_fee.a_motivation_group_code_c a_motivation_detail_fee.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
a_motivation_detail_fee_fk2 | a_motivation_detail_fee.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_motivation_detail_fee_fkcr | a_motivation_detail_fee.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_detail_fee_fkmd | a_motivation_detail_fee.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_detail_fk1 | a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c |
a_motivation_group.a_ledger_number_i a_motivation_group.a_motivation_group_code_c |
Restrict delete |
a_motivation_detail_fk2 | a_motivation_detail.a_ledger_number_i a_motivation_detail.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_motivation_detail_fk3 | a_motivation_detail.a_ledger_number_i a_motivation_detail.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_motivation_detail_fk4 | a_motivation_detail.p_recipient_key_n | p_partner.p_partner_key_n | Restrict delete |
a_motivation_detail_fkcr | a_motivation_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_detail_fkmd | a_motivation_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_group_fk1 | a_motivation_group.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_motivation_group_fkcr | a_motivation_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_motivation_group_fkmd | a_motivation_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_prev_year_corp_ex_rate_fk1 | a_prev_year_corp_ex_rate.a_from_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_prev_year_corp_ex_rate_fk2 | a_prev_year_corp_ex_rate.a_to_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_prev_year_corp_ex_rate_fkcr | a_prev_year_corp_ex_rate.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_prev_year_corp_ex_rate_fkmd | a_prev_year_corp_ex_rate.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_prev_year_trans_anal_attr_fk1 | a_prev_year_trans_anal_attrib.a_ledger_number_i a_prev_year_trans_anal_attrib.a_batch_number_i a_prev_year_trans_anal_attrib.a_journal_number_i a_prev_year_trans_anal_attrib.a_transaction_number_i |
a_previous_year_transaction.a_ledger_number_i a_previous_year_transaction.a_batch_number_i a_previous_year_transaction.a_journal_number_i a_previous_year_transaction.a_transaction_number_i |
Restrict delete |
a_prev_year_trans_anal_attr_fk2 | a_prev_year_trans_anal_attrib.a_ledger_number_i a_prev_year_trans_anal_attrib.a_account_code_c a_prev_year_trans_anal_attrib.a_analysis_type_code_c |
a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c a_analysis_attribute.a_analysis_type_code_c |
Restrict delete |
a_prev_year_trans_anal_attr_fk3 | a_prev_year_trans_anal_attrib.a_ledger_number_i a_prev_year_trans_anal_attrib.a_analysis_type_code_c a_prev_year_trans_anal_attrib.a_analysis_attribute_value_c |
a_freeform_analysis.a_ledger_number_i a_freeform_analysis.a_analysis_type_code_c a_freeform_analysis.a_analysis_value_c |
Restrict delete |
a_prev_year_trans_anal_attr_fk4 | a_prev_year_trans_anal_attrib.a_ledger_number_i a_prev_year_trans_anal_attrib.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_prev_year_trans_anal_attrib_fkcr | a_prev_year_trans_anal_attrib.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_prev_year_trans_anal_attrib_fkmd | a_prev_year_trans_anal_attrib.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_batch_fk1 | a_previous_year_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_previous_year_batch_fk2 | a_previous_year_batch.a_ledger_number_i a_previous_year_batch.a_batch_period_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_previous_year_batch_fkcr | a_previous_year_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_batch_fkmd | a_previous_year_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_journal_fk1 | a_previous_year_journal.a_ledger_number_i a_previous_year_journal.a_batch_number_i |
a_previous_year_batch.a_ledger_number_i a_previous_year_batch.a_batch_number_i |
Restrict delete |
a_previous_year_journal_fk2 | a_previous_year_journal.a_ledger_number_i a_previous_year_journal.a_journal_period_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_previous_year_journal_fk3 | a_previous_year_journal.a_ledger_number_i a_previous_year_journal.a_sub_system_code_c a_previous_year_journal.a_transaction_type_code_c |
a_transaction_type.a_ledger_number_i a_transaction_type.a_sub_system_code_c a_transaction_type.a_transaction_type_code_c |
Restrict delete |
a_previous_year_journal_fk4 | a_previous_year_journal.a_transaction_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_previous_year_journal_fk5 | a_previous_year_journal.a_base_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_previous_year_journal_fkcr | a_previous_year_journal.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_journal_fkmd | a_previous_year_journal.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_transaction_fk1 | a_previous_year_transaction.a_ledger_number_i a_previous_year_transaction.a_batch_number_i a_previous_year_transaction.a_journal_number_i |
a_previous_year_journal.a_ledger_number_i a_previous_year_journal.a_batch_number_i a_previous_year_journal.a_journal_number_i |
Restrict delete |
a_previous_year_transaction_fk2 | a_previous_year_transaction.a_ledger_number_i a_previous_year_transaction.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_previous_year_transaction_fk3 | a_previous_year_transaction.a_ledger_number_i a_previous_year_transaction.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_previous_year_transaction_fkcr | a_previous_year_transaction.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_previous_year_transaction_fkmd | a_previous_year_transaction.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_processed_fee_fk1 | a_processed_fee.a_ledger_number_i a_processed_fee.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_processed_fee_fk2 | a_processed_fee.a_ledger_number_i a_processed_fee.a_period_number_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_processed_fee_fk3 | a_processed_fee.a_ledger_number_i a_processed_fee.a_batch_number_i a_processed_fee.a_gift_transaction_number_i a_processed_fee.a_detail_number_i |
a_gift_detail.a_ledger_number_i a_gift_detail.a_batch_number_i a_gift_detail.a_gift_transaction_number_i a_gift_detail.a_detail_number_i |
Restrict delete |
a_processed_fee_fk4 | a_processed_fee.a_ledger_number_i a_processed_fee.a_batch_number_i |
a_gift_batch.a_ledger_number_i a_gift_batch.a_batch_number_i |
Restrict delete |
a_processed_fee_fkcr | a_processed_fee.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_processed_fee_fkmd | a_processed_fee.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_batch_fk1 | a_recurring_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_recurring_batch_fk2 | a_recurring_batch.s_user_id_c | s_user.s_user_id_c | Restrict delete |
a_recurring_batch_fk3 | a_recurring_batch.a_frequency_code_c | a_frequency.a_frequency_code_c | Restrict delete |
a_recurring_batch_fkcr | a_recurring_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_batch_fkmd | a_recurring_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_batch_fk1 | a_recurring_gift_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_recurring_gift_batch_fk2 | a_recurring_gift_batch.a_ledger_number_i a_recurring_gift_batch.a_bank_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_recurring_gift_batch_fk3 | a_recurring_gift_batch.a_ledger_number_i a_recurring_gift_batch.a_bank_cost_centre_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_recurring_gift_batch_fk4 | a_recurring_gift_batch.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
a_recurring_gift_batch_fkcr | a_recurring_gift_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_batch_fkmd | a_recurring_gift_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_detail_fk1 | a_recurring_gift_detail.a_ledger_number_i a_recurring_gift_detail.a_batch_number_i a_recurring_gift_detail.a_gift_transaction_number_i |
a_recurring_gift.a_ledger_number_i a_recurring_gift.a_batch_number_i a_recurring_gift.a_gift_transaction_number_i |
Restrict delete |
a_recurring_gift_detail_fk2 | a_recurring_gift_detail.a_ledger_number_i a_recurring_gift_detail.a_motivation_group_code_c a_recurring_gift_detail.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
a_recurring_gift_detail_fk3 | a_recurring_gift_detail.p_recipient_key_n | p_partner.p_partner_key_n | Restrict delete |
a_recurring_gift_detail_fk4 | a_recurring_gift_detail.p_mailing_code_c | p_mailing.p_mailing_code_c | Restrict delete |
a_recurring_gift_detail_fk5 | a_recurring_gift_detail.a_recipient_ledger_number_n | p_partner.p_partner_key_n | Restrict delete |
a_recurring_gift_detail_fkcr | a_recurring_gift_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_detail_fkmd | a_recurring_gift_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_fk1 | a_recurring_gift.a_ledger_number_i a_recurring_gift.a_batch_number_i |
a_recurring_gift_batch.a_ledger_number_i a_recurring_gift_batch.a_batch_number_i |
Restrict delete |
a_recurring_gift_fk2 | a_recurring_gift.a_method_of_giving_code_c | a_method_of_giving.a_method_of_giving_code_c | Restrict delete |
a_recurring_gift_fk3 | a_recurring_gift.a_method_of_payment_code_c | a_method_of_payment.a_method_of_payment_code_c | Restrict delete |
a_recurring_gift_fk4 | a_recurring_gift.p_donor_key_n | p_partner.p_partner_key_n | Restrict delete |
a_recurring_gift_fkcr | a_recurring_gift.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_gift_fkmd | a_recurring_gift.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_journal_fk1 | a_recurring_journal.a_ledger_number_i a_recurring_journal.a_batch_number_i |
a_recurring_batch.a_ledger_number_i a_recurring_batch.a_batch_number_i |
Restrict delete |
a_recurring_journal_fk2 | a_recurring_journal.a_ledger_number_i a_recurring_journal.a_sub_system_code_c a_recurring_journal.a_transaction_type_code_c |
a_transaction_type.a_ledger_number_i a_transaction_type.a_sub_system_code_c a_transaction_type.a_transaction_type_code_c |
Restrict delete |
a_recurring_journal_fk3 | a_recurring_journal.a_method_of_payment_code_c | a_method_of_payment.a_method_of_payment_code_c | Restrict delete |
a_recurring_journal_fk4 | a_recurring_journal.a_transaction_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_recurring_journal_fkcr | a_recurring_journal.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_journal_fkmd | a_recurring_journal.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_trans_anal_attr_fk1 | a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attrib.a_batch_number_i a_recurring_trans_anal_attrib.a_journal_number_i a_recurring_trans_anal_attrib.a_transaction_number_i |
a_recurring_transaction.a_ledger_number_i a_recurring_transaction.a_batch_number_i a_recurring_transaction.a_journal_number_i a_recurring_transaction.a_transaction_number_i |
Restrict delete |
a_recurring_trans_anal_attr_fk2 | a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attrib.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_recurring_trans_anal_attr_fk3 | a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attrib.a_account_code_c a_recurring_trans_anal_attrib.a_analysis_type_code_c |
a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c a_analysis_attribute.a_analysis_type_code_c |
Restrict delete |
a_recurring_trans_anal_attr_fk4 | a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attrib.a_analysis_type_code_c a_recurring_trans_anal_attrib.a_analysis_attribute_value_c |
a_freeform_analysis.a_ledger_number_i a_freeform_analysis.a_analysis_type_code_c a_freeform_analysis.a_analysis_value_c |
Restrict delete |
a_recurring_trans_anal_attr_fk5 | a_recurring_trans_anal_attrib.a_ledger_number_i a_recurring_trans_anal_attrib.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_recurring_trans_anal_attrib_fkcr | a_recurring_trans_anal_attrib.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_trans_anal_attrib_fkmd | a_recurring_trans_anal_attrib.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_transaction_fk1 | a_recurring_transaction.a_ledger_number_i a_recurring_transaction.a_batch_number_i a_recurring_transaction.a_journal_number_i |
a_recurring_journal.a_ledger_number_i a_recurring_journal.a_batch_number_i a_recurring_journal.a_journal_number_i |
Restrict delete |
a_recurring_transaction_fk2 | a_recurring_transaction.a_ledger_number_i a_recurring_transaction.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_recurring_transaction_fk3 | a_recurring_transaction.a_ledger_number_i a_recurring_transaction.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_recurring_transaction_fk4 | a_recurring_transaction.a_transaction_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_recurring_transaction_fk5 | a_recurring_transaction.a_base_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_recurring_transaction_fk6 | a_recurring_transaction.a_method_of_payment_code_c | a_method_of_payment.a_method_of_payment_code_c | Restrict delete |
a_recurring_transaction_fk7 | a_recurring_transaction.s_user_id_c | s_user.s_user_id_c | Restrict delete |
a_recurring_transaction_fkcr | a_recurring_transaction.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_recurring_transaction_fkmd | a_recurring_transaction.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_special_trans_type_fk1 | a_special_trans_type.a_sub_system_code_c | a_sub_system.a_sub_system_code_c | Restrict delete |
a_special_trans_type_fk2 | a_special_trans_type.a_spec_trans_process_to_call_c | s_file.s_file_name_c | Restrict delete |
a_special_trans_type_fk3 | a_special_trans_type.a_spec_trans_undo_process_c | s_file.s_file_name_c | Restrict delete |
a_special_trans_type_fkcr | a_special_trans_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_special_trans_type_fkmd | a_special_trans_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_sub_system_fkcr | a_sub_system.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_sub_system_fkmd | a_sub_system.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_suspence_account_fk1 | a_suspense_account.a_ledger_number_i a_suspense_account.a_suspense_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_suspense_account_fkcr | a_suspense_account.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_suspense_account_fkmd | a_suspense_account.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_system_interface_fk1 | a_system_interface.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_system_interface_fk2 | a_system_interface.a_sub_system_code_c | a_sub_system.a_sub_system_code_c | Restrict delete |
a_system_interface_fkcr | a_system_interface.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_system_interface_fkmd | a_system_interface.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_tax_table_fk1 | a_tax_table.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_tax_table_fk2 | a_tax_table.a_tax_type_code_c | a_tax_type.a_tax_type_code_c | Restrict delete |
a_tax_table_fkcr | a_tax_table.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_tax_table_fkmd | a_tax_table.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_tax_type_fkcr | a_tax_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_tax_type_fkmd | a_tax_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_batch_fk1 | a_this_year_old_batch.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_this_year_old_batch_fk2 | a_this_year_old_batch.a_ledger_number_i a_this_year_old_batch.a_batch_period_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_this_year_old_batch_fkcr | a_this_year_old_batch.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_batch_fkmd | a_this_year_old_batch.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_journal_fk1 | a_this_year_old_journal.a_ledger_number_i a_this_year_old_journal.a_batch_number_i |
a_this_year_old_batch.a_ledger_number_i a_this_year_old_batch.a_batch_number_i |
Restrict delete |
a_this_year_old_journal_fk2 | a_this_year_old_journal.a_ledger_number_i a_this_year_old_journal.a_journal_period_i |
a_accounting_period.a_ledger_number_i a_accounting_period.a_accounting_period_number_i |
Restrict delete |
a_this_year_old_journal_fk3 | a_this_year_old_journal.a_ledger_number_i a_this_year_old_journal.a_sub_system_code_c a_this_year_old_journal.a_transaction_type_code_c |
a_transaction_type.a_ledger_number_i a_transaction_type.a_sub_system_code_c a_transaction_type.a_transaction_type_code_c |
Restrict delete |
a_this_year_old_journal_fk4 | a_this_year_old_journal.a_transaction_currency_c | a_currency.a_currency_code_c | Restrict delete |
a_this_year_old_journal_fkcr | a_this_year_old_journal.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_journal_fkmd | a_this_year_old_journal.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_transaction_fk1 | a_this_year_old_transaction.a_ledger_number_i a_this_year_old_transaction.a_batch_number_i a_this_year_old_transaction.a_journal_number_i |
a_this_year_old_journal.a_ledger_number_i a_this_year_old_journal.a_batch_number_i a_this_year_old_journal.a_journal_number_i |
Restrict delete |
a_this_year_old_transaction_fk2 | a_this_year_old_transaction.a_ledger_number_i a_this_year_old_transaction.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_this_year_old_transaction_fk3 | a_this_year_old_transaction.a_ledger_number_i a_this_year_old_transaction.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_this_year_old_transaction_fkcr | a_this_year_old_transaction.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_this_year_old_transaction_fkmd | a_this_year_old_transaction.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_thisyearold_tran_anal_attr_fk1 | a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_trans_anal_attrib.a_batch_number_i a_thisyearold_trans_anal_attrib.a_journal_number_i a_thisyearold_trans_anal_attrib.a_transaction_number_i |
a_this_year_old_transaction.a_ledger_number_i a_this_year_old_transaction.a_batch_number_i a_this_year_old_transaction.a_journal_number_i a_this_year_old_transaction.a_transaction_number_i |
Restrict delete |
a_thisyearold_tran_anal_attr_fk2 | a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_trans_anal_attrib.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_thisyearold_tran_anal_attr_fk3 | a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_trans_anal_attrib.a_account_code_c a_thisyearold_trans_anal_attrib.a_analysis_type_code_c |
a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c a_analysis_attribute.a_analysis_type_code_c |
Restrict delete |
a_thisyearold_tran_anal_attr_fk4 | a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_trans_anal_attrib.a_analysis_type_code_c a_thisyearold_trans_anal_attrib.a_analysis_attribute_value_c |
a_freeform_analysis.a_ledger_number_i a_freeform_analysis.a_analysis_type_code_c a_freeform_analysis.a_analysis_value_c |
Restrict delete |
a_thisyearold_tran_anal_attr_fk5 | a_thisyearold_trans_anal_attrib.a_ledger_number_i a_thisyearold_trans_anal_attrib.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_thisyearold_trans_anal_attrib_fkcr | a_thisyearold_trans_anal_attrib.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_thisyearold_trans_anal_attrib_fkmd | a_thisyearold_trans_anal_attrib.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_trans_anal_attrib_fk1 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_batch_number_i a_trans_anal_attrib.a_journal_number_i a_trans_anal_attrib.a_transaction_number_i |
a_transaction.a_ledger_number_i a_transaction.a_batch_number_i a_transaction.a_journal_number_i a_transaction.a_transaction_number_i |
Restrict delete |
a_trans_anal_attrib_fk2 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_trans_anal_attrib_fk3 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_account_code_c a_trans_anal_attrib.a_analysis_type_code_c |
a_analysis_attribute.a_ledger_number_i a_analysis_attribute.a_account_code_c a_analysis_attribute.a_analysis_type_code_c |
Restrict delete |
a_trans_anal_attrib_fk4 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_analysis_type_code_c a_trans_anal_attrib.a_analysis_attribute_value_c |
a_freeform_analysis.a_ledger_number_i a_freeform_analysis.a_analysis_type_code_c a_freeform_analysis.a_analysis_value_c |
Restrict delete |
a_trans_anal_attrib_fk5 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_trans_anal_attrib_fk6 | a_trans_anal_attrib.a_ledger_number_i a_trans_anal_attrib.a_batch_number_i |
a_batch.a_ledger_number_i a_batch.a_batch_number_i |
Restrict delete |
a_trans_anal_attrib_fkcr | a_trans_anal_attrib.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_trans_anal_attrib_fkmd | a_trans_anal_attrib.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_transaction_fk1 | a_transaction.a_ledger_number_i a_transaction.a_batch_number_i a_transaction.a_journal_number_i |
a_journal.a_ledger_number_i a_journal.a_batch_number_i a_journal.a_journal_number_i |
Restrict delete |
a_transaction_fk2 | a_transaction.a_ledger_number_i a_transaction.a_batch_number_i |
a_batch.a_ledger_number_i a_batch.a_batch_number_i |
Restrict delete |
a_transaction_fk3 | a_transaction.a_ledger_number_i a_transaction.a_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_transaction_fk4 | a_transaction.a_ledger_number_i a_transaction.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_transaction_fk5 | a_transaction.a_key_ministry_key_n | p_unit.p_partner_key_n | Restrict delete |
a_transaction_fkcr | a_transaction.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_transaction_fkmd | a_transaction.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_transaction_type_fk1 | a_transaction_type.a_ledger_number_i a_transaction_type.a_debit_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_transaction_type_fk2 | a_transaction_type.a_ledger_number_i a_transaction_type.a_credit_account_code_c |
a_account.a_ledger_number_i a_account.a_account_code_c |
Restrict delete |
a_transaction_type_fk3 | a_transaction_type.a_sub_system_code_c | a_sub_system.a_sub_system_code_c | Restrict delete |
a_transaction_type_fkcr | a_transaction_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_transaction_type_fkmd | a_transaction_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
a_valid_ledger_number_fk1 | a_valid_ledger_number.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
a_valid_ledger_number_fk2 | a_valid_ledger_number.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
a_valid_ledger_number_fk3 | a_valid_ledger_number.a_ilt_processing_centre_n | p_partner.p_partner_key_n | Restrict delete |
a_valid_ledger_number_fk4 | a_valid_ledger_number.a_ledger_number_i a_valid_ledger_number.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
a_valid_ledger_number_fkcr | a_valid_ledger_number.s_created_by_c | s_user.s_user_id_c | Restrict delete |
a_valid_ledger_number_fkmd | a_valid_ledger_number.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
ar_article_price_fk1 | a_ar_article_price.a_ar_article_code_c | a_ar_article.a_ar_article_code_c | Restrict delete |
ar_article_price_fk2 | a_ar_article_price.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
ar_default_discount_fk1 | a_ar_default_discount.a_ar_category_code_c | a_ar_category.a_ar_category_code_c | Restrict delete |
ar_default_discount_fk2 | a_ar_default_discount.a_ar_discount_code_c a_ar_default_discount.a_ar_date_valid_from_d |
a_ar_discount.a_ar_discount_code_c a_ar_discount.a_ar_date_valid_from_d |
Restrict delete |
ar_discount_fk1 | a_ar_discount.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
ar_discount_fk2 | a_ar_discount.p_partner_type_code_c | p_type.p_type_code_c | Restrict delete |
ar_discount_fk3 | a_ar_discount.a_ar_article_code_c | a_ar_article.a_ar_article_code_c | Restrict delete |
ar_discount_per_category_fk1 | a_ar_discount_per_category.a_ar_category_code_c | a_ar_category.a_ar_category_code_c | Restrict delete |
ar_discount_per_category_fk2 | a_ar_discount_per_category.a_ar_discount_code_c a_ar_discount_per_category.a_ar_date_valid_from_d |
a_ar_discount.a_ar_discount_code_c a_ar_discount.a_ar_date_valid_from_d |
Restrict delete |
m_extract_fk1 | m_extract.m_extract_id_i | m_extract_master.m_extract_id_i | Restrict delete |
m_extract_fk2 | m_extract.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
m_extract_fk3 | m_extract.p_site_key_n m_extract.p_location_key_i |
p_location.p_site_key_n p_location.p_location_key_i |
Restrict delete |
m_extract_fkcr | m_extract.s_created_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_fkmd | m_extract.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_master_fk3 | m_extract_master.m_manual_mod_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_master_fk4 | m_extract_master.m_extract_type_code_c | m_extract_type.m_code_c | Restrict delete |
m_extract_master_fkcr | m_extract_master.s_created_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_master_fkmd | m_extract_master.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_parameter_fk1 | m_extract_parameter.m_extract_id_i | m_extract_master.m_extract_id_i | Restrict delete |
m_extract_parameter_fkcr | m_extract_parameter.s_created_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_parameter_fkmd | m_extract_parameter.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_type_fkcr | m_extract_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
m_extract_type_fkmd | m_extract_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_acquisition_fkcr | p_acquisition.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_acquisition_fkmd | p_acquisition.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_action_fk1 | p_action.p_process_code_c | p_process.p_process_code_c | Restrict delete |
p_action_fkcr | p_action.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_action_fkmd | p_action.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_address_element_fkcr | p_address_element.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_address_element_fkmd | p_address_element.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_address_layout_code_fkcr | p_address_layout_code.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_address_layout_code_fkmd | p_address_layout_code.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_address_layout_fk1 | p_address_layout.p_country_code_c | p_country.p_country_code_c | Restrict delete |
p_address_layout_fk2 | p_address_layout.p_address_layout_code_c | p_address_layout_code.p_code_c | Restrict delete |
p_address_layout_fkcr | p_address_layout.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_address_layout_fkmd | p_address_layout.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_address_line_fk1 | p_address_line.p_address_element_code_c | p_address_element.p_address_element_code_c | Restrict delete |
p_address_line_fkcr | p_address_line.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_address_line_fkmd | p_address_line.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_addressee_title_override_fk1 | p_addressee_title_override.p_language_code_c | p_language.p_language_code_c | Restrict delete |
p_addressee_title_override_fkcr | p_addressee_title_override.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_addressee_title_override_fkmd | p_addressee_title_override.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_addressee_type_fkcr | p_addressee_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_addressee_type_fkmd | p_addressee_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_area_fk1 | p_foundation_proposal_detail.p_area_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
p_bank_fk1 | p_bank.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_bank_fk2 | p_bank.p_contact_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_bank_fkcr | p_bank.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_bank_fkmd | p_bank.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_fk3 | p_banking_details.p_banking_type_i | p_banking_type.p_id_i | Restrict delete |
p_banking_details_fk4 | p_banking_details.p_bank_key_n | p_bank.p_partner_key_n | Restrict delete |
p_banking_details_fkcr | p_banking_details.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_fkmd | p_banking_details.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_usage_fk1 | p_banking_details_usage.p_partner_key_n p_banking_details_usage.p_banking_details_key_i |
p_partner_banking_details.p_partner_key_n p_partner_banking_details.p_banking_details_key_i |
Restrict delete |
p_banking_details_usage_fk2 | p_banking_details_usage.p_type_c | p_banking_details_usage_type.p_type_c | Restrict delete |
p_banking_details_usage_fkcr | p_banking_details_usage.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_usage_fkmd | p_banking_details_usage.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_usage_type_fkcr | p_banking_details_usage_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_details_usage_type_fkmd | p_banking_details_usage_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_type_fkcr | p_banking_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_banking_type_fkmd | p_banking_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_business_fkcr | p_business.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_business_fkmd | p_business.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_church_fk1 | p_church.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_church_fk2 | p_church.p_denomination_code_c | p_denomination.p_denomination_code_c | Restrict delete |
p_church_fk3 | p_church.p_contact_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_church_fkcr | p_church.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_church_fkmd | p_church.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_contact_attribute_detail_fk1 | p_contact_attribute_detail.p_contact_attribute_code_c | p_contact_attribute.p_contact_attribute_code_c | Restrict delete |
p_contact_attribute_detail_fkcr | p_contact_attribute_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_contact_attribute_detail_fkmd | p_contact_attribute_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_contact_attribute_fkcr | p_contact_attribute.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_contact_attribute_fkmd | p_contact_attribute.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_country_fk1 | p_country.p_internat_postal_type_code_c | p_international_postal_type.p_internat_postal_type_code_c | Restrict delete |
p_country_fkcr | p_country.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_country_fkmd | p_country.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_customised_greeting_fk1 | p_customised_greeting.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_customised_greeting_fk2 | p_customised_greeting.s_user_id_c | s_user.s_user_id_c | Restrict delete |
p_customised_greeting_fkcr | p_customised_greeting.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_customised_greeting_fkmd | p_customised_greeting.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_fk1 | p_data_label.p_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
p_data_label_fk2 | p_data_label.p_lookup_category_code_c | p_data_label_lookup_category.p_category_code_c | Restrict delete |
p_data_label_fkcr | p_data_label.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_fkmd | p_data_label.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_lookup_category_fkcr | p_data_label_lookup_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_lookup_category_fkmd | p_data_label_lookup_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_lookup_fk1 | p_data_label_lookup.p_category_code_c | p_data_label_lookup_category.p_category_code_c | Restrict delete |
p_data_label_lookup_fkcr | p_data_label_lookup.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_lookup_fkmd | p_data_label_lookup.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_use_fk1 | p_data_label_use.p_data_label_key_i | p_data_label.p_key_i | Restrict delete |
p_data_label_use_fkcr | p_data_label_use.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_use_fkmd | p_data_label_use.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_value_application_fk1 | p_data_label_value_application.p_partner_key_n p_data_label_value_application.pm_application_key_i p_data_label_value_application.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
p_data_label_value_application_fk2 | p_data_label_value_application.p_data_label_key_i | p_data_label.p_key_i | Restrict delete |
p_data_label_value_application_fk3 | p_data_label_value_application.p_value_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_data_label_value_application_fkcr | p_data_label_value_application.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_value_application_fkmd | p_data_label_value_application.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_value_partner_fk1 | p_data_label_value_partner.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_data_label_value_partner_fk2 | p_data_label_value_partner.p_data_label_key_i | p_data_label.p_key_i | Restrict delete |
p_data_label_value_partner_fk3 | p_data_label_value_partner.p_value_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_data_label_value_partner_fkcr | p_data_label_value_partner.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_data_label_value_partner_fkmd | p_data_label_value_partner.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_denomination_fkcr | p_denomination.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_denomination_fkmd | p_denomination.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_detail_proposal_fk1 | p_foundation_proposal_detail.p_foundation_partner_key_n p_foundation_proposal_detail.p_foundation_proposal_key_i |
p_foundation_proposal.p_foundation_partner_key_n p_foundation_proposal.p_foundation_proposal_key_i |
Restrict delete |
p_detail_proposal_fk2 | p_foundation_proposal_detail.p_foundation_partner_key_n | p_foundation.p_partner_key_n | Restrict delete |
p_email_fkcr | p_email.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_email_fkmd | p_email.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_family_fk1 | p_family.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_family_fk2 | p_family.p_field_key_n | p_unit.p_partner_key_n | Restrict delete |
p_family_fk3 | p_family.p_marital_status_c | pt_marital_status.pt_code_c | Restrict delete |
p_family_fkcr | p_family.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_family_fkmd | p_family.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_field_fk1 | p_foundation_proposal_detail.p_field_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
p_file_info_fk1 | p_file_info.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_file_info_fk2 | p_file_info.s_volume_name_c | s_volume.s_name_c | Restrict delete |
p_file_info_fkcr | p_file_info.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_file_info_fkmd | p_file_info.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_first_contact_fkcr | p_first_contact.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_first_contact_fkmd | p_first_contact.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_body_fk1 | p_form_letter_body.p_owner_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_body_fkcr | p_form_letter_body.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_body_fkmd | p_form_letter_body.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_design_fk2 | p_form_letter_design.p_body_name_c | p_form_letter_body.p_body_name_c | Restrict delete |
p_form_letter_design_fk3 | p_form_letter_design.p_address_layout_code_c | p_address_layout_code.p_code_c | Restrict delete |
p_form_letter_design_fkcr | p_form_letter_design.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_design_fkmd | p_form_letter_design.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_insert_fk1 | p_form_letter_insert.p_body_name_c | p_form_letter_body.p_body_name_c | Restrict delete |
p_form_letter_insert_fk2 | p_form_letter_insert.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_form_letter_insert_fk3 | p_form_letter_insert.m_extract_id_i | m_extract_master.m_extract_id_i | Restrict delete |
p_form_letter_insert_fkcr | p_form_letter_insert.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_form_letter_insert_fkmd | p_form_letter_insert.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_formality_fk1 | p_formality.p_language_code_c | p_language.p_language_code_c | Restrict delete |
p_formality_fk2 | p_formality.p_country_code_c | p_country.p_country_code_c | Restrict delete |
p_formality_fk3 | p_formality.p_addressee_type_code_c | p_addressee_type.p_addressee_type_code_c | Restrict delete |
p_formality_fkcr | p_formality.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_formality_fkmd | p_formality.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_contact_fk1 | p_foundation.p_contact_partner_n | p_partner.p_partner_key_n | Restrict delete |
p_foundation_deadline_fk1 | p_foundation_deadline.p_foundation_partner_key_n | p_foundation.p_partner_key_n | Restrict delete |
p_foundation_deadline_fkcr | p_foundation_deadline.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_deadline_fkmd | p_foundation_deadline.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_fk1 | p_foundation.p_partner_key_n | p_organisation.p_partner_key_n | Restrict delete |
p_foundation_fkcr | p_foundation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_fkmd | p_foundation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_detail_fkcr | p_foundation_proposal_detail.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_detail_fkmd | p_foundation_proposal_detail.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_fkcr | p_foundation_proposal.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_fkmd | p_foundation_proposal.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_status_fkcr | p_foundation_proposal_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_proposal_status_fkmd | p_foundation_proposal_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_foundation_submission_fk1 | p_foundation.p_proposal_submission_type_c | p_proposal_submission_type.p_submission_type_code_c | Restrict delete |
p_interest_category_fkcr | p_interest_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_interest_category_fkmd | p_interest_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_interest_fk1 | p_interest.p_category_c | p_interest_category.p_category_c | Restrict delete |
p_interest_fkcr | p_interest.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_interest_fkmd | p_interest.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_international_postal_type_fkcr | p_international_postal_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_international_postal_type_fkmd | p_international_postal_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_label_fk1 | p_label.s_form_name_c | s_form.s_form_name_c | Restrict delete |
p_label_fkcr | p_label.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_label_fkmd | p_label.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_language_fkcr | p_language.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_language_fkmd | p_language.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_location_fk1 | p_location.p_country_code_c | p_country.p_country_code_c | Restrict delete |
p_location_fkcr | p_location.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_location_fkmd | p_location.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_location_type_fkcr | p_location_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_location_type_fkmd | p_location_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_mailing_fkcr | p_mailing.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_mailing_fkmd | p_mailing.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_merge_field_fk1 | p_merge_field.p_merge_form_name_c | p_merge_form.p_merge_form_name_c | Restrict delete |
p_merge_field_fkcr | p_merge_field.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_merge_field_fkmd | p_merge_field.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_merge_form_fkcr | p_merge_form.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_merge_form_fkmd | p_merge_form.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_method_of_contact_fkcr | p_method_of_contact.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_method_of_contact_fkmd | p_method_of_contact.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_occupation_fkcr | p_occupation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_occupation_fkmd | p_occupation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_organisation_fk1 | p_organisation.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_organisation_fk2 | p_organisation.p_business_code_c | p_business.p_business_code_c | Restrict delete |
p_organisation_fk3 | p_organisation.p_contact_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_organisation_fkcr | p_organisation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_organisation_fkmd | p_organisation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_action_fk1 | p_partner_action.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_action_fk2 | p_partner_action.p_process_code_c p_partner_action.p_action_code_c |
p_action.p_process_code_c p_action.p_action_code_c |
Restrict delete |
p_partner_action_fk3 | p_partner_action.p_user_to_perform_action_c | s_user.s_user_id_c | Restrict delete |
p_partner_action_fk4 | p_partner_action.p_group_to_perform_action_c p_partner_action.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
p_partner_action_fk5 | p_partner_action.p_user_that_performed_action_c | s_user.s_user_id_c | Restrict delete |
p_partner_action_fk6 | p_partner_action.p_partner_key_n p_partner_action.p_contact_id_i p_partner_action.p_reminder_id_i |
p_partner_reminder.p_partner_key_n p_partner_reminder.p_contact_id_i p_partner_reminder.p_reminder_id_i |
Restrict delete |
p_partner_action_fkcr | p_partner_action.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_action_fkmd | p_partner_action.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_attribute_fk1 | p_partner_attribute.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_attribute_fk2 | p_partner_attribute.p_code_c | p_partner_attribute_type.p_code_c | Restrict delete |
p_partner_attribute_fkcr | p_partner_attribute.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_attribute_fkmd | p_partner_attribute.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_attribute_type_fkcr | p_partner_attribute_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_attribute_type_fkmd | p_partner_attribute_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_banking_details_fkcr | p_partner_banking_details.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_banking_details_fkmd | p_partner_banking_details.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_banking_link_fk1 | p_partner_banking_details.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_banking_link_fk2 | p_partner_banking_details.p_banking_details_key_i | p_banking_details.p_banking_details_key_i | Restrict delete |
p_partner_classes_fkcr | p_partner_classes.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_classes_fkmd | p_partner_classes.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_comment_fk1 | p_partner_comment.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_comment_fkcr | p_partner_comment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_comment_fkmd | p_partner_comment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_attribute_fk1 | p_partner_contact_attribute.p_contact_attribute_code_c p_partner_contact_attribute.p_contact_attr_detail_code_c |
p_contact_attribute_detail.p_contact_attribute_code_c p_contact_attribute_detail.p_contact_attr_detail_code_c |
Restrict delete |
p_partner_contact_attribute_fk2 | p_partner_contact_attribute.p_contact_id_i | p_partner_contact.p_contact_id_i | Restrict delete |
p_partner_contact_attribute_fkcr | p_partner_contact_attribute.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_attribute_fkmd | p_partner_contact_attribute.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_file_fk1 | p_partner_contact_file.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_contact_file_fk2 | p_partner_contact_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
p_partner_contact_file_fk3 | p_partner_contact_file.p_contact_id_i | p_partner_contact.p_contact_id_i | Restrict delete |
p_partner_contact_file_fkcr | p_partner_contact_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_file_fkmd | p_partner_contact_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_fk1 | p_partner_contact.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_contact_fk2 | p_partner_contact.p_mailing_code_c | p_mailing.p_mailing_code_c | Restrict delete |
p_partner_contact_fk3 | p_partner_contact.p_contact_code_c | p_method_of_contact.p_method_of_contact_code_c | Restrict delete |
p_partner_contact_fk4 | p_partner_contact.s_module_id_c | s_module.s_module_id_c | Restrict delete |
p_partner_contact_fk7 | p_partner_contact.s_user_id_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_fkcr | p_partner_contact.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_contact_fkmd | p_partner_contact.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_field_of_service_fk1 | p_partner_field_of_service.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_field_of_service_fk2 | p_partner_field_of_service.p_field_key_n | p_unit.p_partner_key_n | Restrict delete |
p_partner_field_of_service_fk3 | p_partner_field_of_service.p_partner_class_c | p_partner_classes.p_partner_class_c | Restrict delete |
p_partner_field_of_service_fk4 | p_partner_field_of_service.p_commitment_site_key_n p_partner_field_of_service.p_commitment_key_n |
pm_staff_data.p_site_key_n pm_staff_data.pm_key_n |
Restrict delete |
p_partner_field_of_service_fkcr | p_partner_field_of_service.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_field_of_service_fkmd | p_partner_field_of_service.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_file_fk1 | p_partner_file.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_file_fk2 | p_partner_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
p_partner_file_fkcr | p_partner_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_file_fkmd | p_partner_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_fk1 | p_partner.p_acquisition_code_c | p_acquisition.p_acquisition_code_c | Restrict delete |
p_partner_fk2 | p_partner.p_language_code_c | p_language.p_language_code_c | Restrict delete |
p_partner_fk3 | p_partner.p_status_code_c | p_partner_status.p_status_code_c | Restrict delete |
p_partner_fk4 | p_partner.p_addressee_type_code_c | p_addressee_type.p_addressee_type_code_c | Restrict delete |
p_partner_fk7 | p_partner.p_partner_class_c | p_partner_classes.p_partner_class_c | Restrict delete |
p_partner_fk8 | p_partner.p_first_contact_code_c | p_first_contact.p_first_contact_code_c | Restrict delete |
p_partner_fkcr | p_partner.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_fkmd | p_partner.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_graphic_fk1 | p_partner_graphic.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_graphic_fk2 | p_partner_graphic.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
p_partner_graphic_fkcr | p_partner_graphic.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_graphic_fkmd | p_partner_graphic.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_interest_fk1 | p_partner_interest.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_interest_fk2 | p_partner_interest.p_field_key_n | p_unit.p_partner_key_n | Restrict delete |
p_partner_interest_fk3 | p_partner_interest.p_country_c | p_country.p_country_code_c | Restrict delete |
p_partner_interest_fk4 | p_partner_interest.p_interest_c | p_interest.p_interest_c | Restrict delete |
p_partner_interest_fkcr | p_partner_interest.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_interest_fkmd | p_partner_interest.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_ledger_fk1 | p_partner_ledger.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
p_partner_ledger_fkcr | p_partner_ledger.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_ledger_fkmd | p_partner_ledger.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_location_fk1 | p_partner_location.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_location_fk2 | p_partner_location.p_site_key_n p_partner_location.p_location_key_i |
p_location.p_site_key_n p_location.p_location_key_i |
Restrict delete |
p_partner_location_fk3 | p_partner_location.p_location_type_c | p_location_type.p_code_c | Restrict delete |
p_partner_location_fkcr | p_partner_location.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_location_fkmd | p_partner_location.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_merge_fk1 | p_partner_merge.p_merge_from_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_merge_fk2 | p_partner_merge.p_merge_to_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_merge_fk3 | p_partner_merge.s_merged_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_merge_fkcr | p_partner_merge.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_merge_fkmd | p_partner_merge.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_relationship_fk1 | p_partner_relationship.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_relationship_fk2 | p_partner_relationship.p_relation_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_relationship_fk3 | p_partner_relationship.p_relation_name_c | p_relation.p_relation_name_c | Restrict delete |
p_partner_relationship_fkcr | p_partner_relationship.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_relationship_fkmd | p_partner_relationship.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_reminder_fk1 | p_partner_reminder.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_reminder_fk2 | p_partner_reminder.p_contact_id_i | p_partner_contact.p_contact_id_i | Restrict delete |
p_partner_reminder_fk3 | p_partner_reminder.s_user_id_c | s_user.s_user_id_c | Restrict delete |
p_partner_reminder_fk4 | p_partner_reminder.s_module_id_c | s_module.s_module_id_c | Restrict delete |
p_partner_reminder_fk5 | p_partner_reminder.s_user_restriction_c | s_user.s_user_id_c | Restrict delete |
p_partner_reminder_fk6 | p_partner_reminder.p_category_code_c | p_reminder_category.p_code_c | Restrict delete |
p_partner_reminder_fkcr | p_partner_reminder.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_reminder_fkmd | p_partner_reminder.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_set_fk1 | p_partner_set.p_unit_key_n | p_unit.p_partner_key_n | Restrict delete |
p_partner_set_fkcr | p_partner_set.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_set_fkmd | p_partner_set.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_set_partner_fk1 | p_partner_set_partner.p_partner_set_id_c p_partner_set_partner.p_partner_set_unit_key_n |
p_partner_set.p_partner_set_id_c p_partner_set.p_unit_key_n |
Restrict delete |
p_partner_set_partner_fk2 | p_partner_set_partner.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_set_partner_fkcr | p_partner_set_partner.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_set_partner_fkmd | p_partner_set_partner.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_short_code_fk1 | p_partner_short_code.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_short_code_fkcr | p_partner_short_code.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_short_code_fkmd | p_partner_short_code.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_state_fk1 | p_partner_state.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_state_fk2 | p_partner_state.p_process_code_c p_partner_state.p_state_code_c |
p_state.p_process_code_c p_state.p_state_code_c |
Restrict delete |
p_partner_state_fkcr | p_partner_state.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_state_fkmd | p_partner_state.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_status_fkcr | p_partner_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_status_fkmd | p_partner_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_tax_deductible_pct_fk1 | p_partner_tax_deductible_pct.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_tax_deductible_pct_fkcr | p_partner_tax_deductible_pct.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_tax_deductible_pct_fkmd | p_partner_tax_deductible_pct.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_type_fk3 | p_partner_type.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_partner_type_fk4 | p_partner_type.p_type_code_c | p_type.p_type_code_c | Restrict delete |
p_partner_type_fkcr | p_partner_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_partner_type_fkmd | p_partner_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_person_fk1 | p_person.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_person_fk2 | p_person.p_family_key_n | p_family.p_partner_key_n | Restrict delete |
p_person_fk3 | p_person.p_marital_status_c | pt_marital_status.pt_code_c | Restrict delete |
p_person_fk4 | p_person.p_field_key_n | p_unit.p_partner_key_n | Restrict delete |
p_person_fk5 | p_person.p_occupation_code_c | p_occupation.p_occupation_code_c | Restrict delete |
p_person_fkcr | p_person.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_person_fkmd | p_person.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_postcode_range_fkcr | p_postcode_range.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_postcode_range_fkmd | p_postcode_range.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_postcode_region_fk1 | p_postcode_region.p_range_c | p_postcode_range.p_range_c | Restrict delete |
p_postcode_region_fkcr | p_postcode_region.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_postcode_region_fkmd | p_postcode_region.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_process_fkcr | p_process.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_process_fkmd | p_process.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_proposal_ministry_fk1 | p_foundation_proposal_detail.p_key_ministry_key_n | p_unit.p_partner_key_n | Restrict delete |
p_proposal_motivation_fk1 | p_foundation_proposal_detail.p_project_ledger_number_i p_foundation_proposal_detail.p_project_motivation_group_c p_foundation_proposal_detail.p_project_motivation_detail_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
p_proposal_status_fk1 | p_foundation_proposal.p_foundation_partner_key_n | p_foundation.p_partner_key_n | Restrict delete |
p_proposal_status_fk2 | p_foundation_proposal.p_proposal_status_c | p_foundation_proposal_status.p_status_code_c | Restrict delete |
p_proposal_submission_type_fkcr | p_proposal_submission_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_proposal_submission_type_fkmd | p_proposal_submission_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_proposal_submitted_fk3 | p_foundation_proposal.p_partner_submitted_by_n | p_partner.p_partner_key_n | Restrict delete |
p_publication_cost_fk1 | p_publication_cost.p_publication_code_c | p_publication.p_publication_code_c | Restrict delete |
p_publication_cost_fk2 | p_publication_cost.p_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
p_publication_cost_fkcr | p_publication_cost.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_publication_cost_fkmd | p_publication_cost.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_publication_fk1 | p_publication.a_frequency_code_c | a_frequency.a_frequency_code_c | Restrict delete |
p_publication_fk2 | p_publication.p_publication_language_c | p_language.p_language_code_c | Restrict delete |
p_publication_fkcr | p_publication.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_publication_fkmd | p_publication.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_reason_subscription_cancelled_fkcr | p_reason_subscription_cancelled.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_reason_subscription_cancelled_fkmd | p_reason_subscription_cancelled.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_reason_subscription_given_fkcr | p_reason_subscription_given.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_reason_subscription_given_fkmd | p_reason_subscription_given.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_recent_partners_fk1 | p_recent_partners.s_user_id_c | s_user.s_user_id_c | Restrict delete |
p_recent_partners_fk2 | p_recent_partners.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_recent_partners_fkcr | p_recent_partners.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_recent_partners_fkmd | p_recent_partners.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_relation_category_fkcr | p_relation_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_relation_category_fkmd | p_relation_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_relation_fk1 | p_relation.p_relation_category_c | p_relation_category.p_code_c | Restrict delete |
p_relation_fkcr | p_relation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_relation_fkmd | p_relation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_reminder_category_fkcr | p_reminder_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_reminder_category_fkmd | p_reminder_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_reports_fk1 | p_reports.p_report_program_c | s_file.s_file_name_c | Restrict delete |
p_reports_fkcr | p_reports.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_reports_fkmd | p_reports.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_state_fk1 | p_state.p_process_code_c | p_process.p_process_code_c | Restrict delete |
p_state_fkcr | p_state.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_state_fkmd | p_state.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_subscription_fk1 | p_subscription.p_publication_code_c | p_publication.p_publication_code_c | Restrict delete |
p_subscription_fk2 | p_subscription.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_subscription_fk3 | p_subscription.p_gift_from_key_n | p_partner.p_partner_key_n | Restrict delete |
p_subscription_fk4 | p_subscription.p_reason_subs_given_code_c | p_reason_subscription_given.p_code_c | Restrict delete |
p_subscription_fk5 | p_subscription.p_reason_subs_cancelled_code_c | p_reason_subscription_cancelled.p_code_c | Restrict delete |
p_subscription_fkcr | p_subscription.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_subscription_fkmd | p_subscription.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_tax_fk1 | p_tax.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_tax_fkcr | p_tax.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_tax_fkmd | p_tax.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_title_fk1 | p_title.p_default_addressee_type_code_c | p_addressee_type.p_addressee_type_code_c | Restrict delete |
p_title_fkcr | p_title.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_title_fkmd | p_title.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_type_category_fkcr | p_type_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_type_category_fkmd | p_type_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_type_fk1 | p_type.p_category_code_c | p_type_category.p_code_c | Restrict delete |
p_type_fkcr | p_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_type_fkmd | p_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_unit_fk1 | p_unit.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_unit_fk2 | p_unit.u_unit_type_code_c | u_unit_type.u_unit_type_code_c | Restrict delete |
p_unit_fk3 | p_unit.p_country_code_c | p_country.p_country_code_c | Restrict delete |
p_unit_fk4 | p_unit.p_outreach_cost_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
p_unit_fk7 | p_unit.p_primary_office_n | p_partner.p_partner_key_n | Restrict delete |
p_unit_fkcr | p_unit.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_unit_fkmd | p_unit.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
p_venue_fk1 | p_venue.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_venue_fk2 | p_venue.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
p_venue_fk3 | p_venue.p_contact_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
p_venue_fkcr | p_venue.s_created_by_c | s_user.s_user_id_c | Restrict delete |
p_venue_fkmd | p_venue.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_attendee_fk1 | pc_attendee.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_attendee_fk2 | pc_attendee.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pc_attendee_fk3 | pc_attendee.pc_home_office_key_n | p_unit.p_partner_key_n | Restrict delete |
pc_attendee_fkcr | pc_attendee.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_attendee_fkmd | pc_attendee.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_building_fk1 | pc_building.p_venue_key_n | p_venue.p_partner_key_n | Restrict delete |
pc_building_fkcr | pc_building.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_building_fkmd | pc_building.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_cost_fk1 | pc_conference_cost.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_conference_cost_fkcr | pc_conference_cost.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_cost_fkmd | pc_conference_cost.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_fk1 | pc_conference.pc_conference_key_n | p_unit.p_partner_key_n | Restrict delete |
pc_conference_fk2 | pc_conference.a_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
pc_conference_fkcr | pc_conference.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_fkmd | pc_conference.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_option_fk1 | pc_conference_option.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_conference_option_fk2 | pc_conference_option.pc_option_type_code_c | pc_conference_option_type.pc_option_type_code_c | Restrict delete |
pc_conference_option_fkcr | pc_conference_option.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_option_fkmd | pc_conference_option.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_option_type_fkcr | pc_conference_option_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_option_type_fkmd | pc_conference_option_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_venue_fk1 | pc_conference_venue.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_conference_venue_fk2 | pc_conference_venue.p_venue_key_n | p_venue.p_partner_key_n | Restrict delete |
pc_conference_venue_fkcr | pc_conference_venue.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_conference_venue_fkmd | pc_conference_venue.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_cost_type_fkcr | pc_cost_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_cost_type_fkmd | pc_cost_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_discount_criteria_fkcr | pc_discount_criteria.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_discount_criteria_fkmd | pc_discount_criteria.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_discount_fk1 | pc_discount.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_discount_fk2 | pc_discount.pc_discount_criteria_code_c | pc_discount_criteria.pc_discount_criteria_code_c | Restrict delete |
pc_discount_fk3 | pc_discount.pc_cost_type_code_c | pc_cost_type.pc_cost_type_code_c | Restrict delete |
pc_discount_fkcr | pc_discount.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_discount_fkmd | pc_discount.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_early_late_fk1 | pc_early_late.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_early_late_fkcr | pc_early_late.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_early_late_fkmd | pc_early_late.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_extra_cost_fk1 | pc_extra_cost.pc_conference_key_n pc_extra_cost.p_partner_key_n |
pc_attendee.pc_conference_key_n pc_attendee.p_partner_key_n |
Restrict delete |
pc_extra_cost_fk2 | pc_extra_cost.pc_cost_type_code_c | pc_cost_type.pc_cost_type_code_c | Restrict delete |
pc_extra_cost_fk3 | pc_extra_cost.pc_authorising_field_n | p_unit.p_partner_key_n | Restrict delete |
pc_extra_cost_fkcr | pc_extra_cost.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_extra_cost_fkmd | pc_extra_cost.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_group_fk1 | pc_group.pc_conference_key_n pc_group.p_partner_key_n |
pc_attendee.pc_conference_key_n pc_attendee.p_partner_key_n |
Restrict delete |
pc_group_fkcr | pc_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_group_fkmd | pc_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_alloc_fk1 | pc_room_alloc.pc_conference_key_n pc_room_alloc.p_partner_key_n |
pc_attendee.pc_conference_key_n pc_attendee.p_partner_key_n |
Restrict delete |
pc_room_alloc_fk2 | pc_room_alloc.p_venue_key_n pc_room_alloc.pc_building_code_c pc_room_alloc.pc_room_number_c |
pc_room.p_venue_key_n pc_room.pc_building_code_c pc_room.pc_room_number_c |
Restrict delete |
pc_room_alloc_fkcr | pc_room_alloc.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_alloc_fkmd | pc_room_alloc.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_attribute_fk1 | pc_room_attribute.p_venue_key_n pc_room_attribute.pc_building_code_c pc_room_attribute.pc_room_number_c |
pc_room.p_venue_key_n pc_room.pc_building_code_c pc_room.pc_room_number_c |
Restrict delete |
pc_room_attribute_fk2 | pc_room_attribute.pc_room_attr_type_code_c | pc_room_attribute_type.pc_code_c | Restrict delete |
pc_room_attribute_fkcr | pc_room_attribute.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_attribute_fkmd | pc_room_attribute.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_attribute_type_fkcr | pc_room_attribute_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_attribute_type_fkmd | pc_room_attribute_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_fk1 | pc_room.p_venue_key_n pc_room.pc_building_code_c |
pc_building.p_venue_key_n pc_building.pc_building_code_c |
Restrict delete |
pc_room_fkcr | pc_room.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_room_fkmd | pc_room.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pc_supplement_fk1 | pc_supplement.pc_conference_key_n | pc_conference.pc_conference_key_n | Restrict delete |
pc_supplement_fkcr | pc_supplement.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pc_supplement_fkmd | pc_supplement.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
ph_booking_fk1 | ph_booking.p_contact_key_n | p_partner.p_partner_key_n | Restrict delete |
ph_booking_fk2 | ph_booking.a_ledger_number_for_invoice_i ph_booking.a_ar_invoice_key_i |
a_ar_invoice.a_ledger_number_i a_ar_invoice.a_key_i |
Restrict delete |
ph_booking_fkcr | ph_booking.s_created_by_c | s_user.s_user_id_c | Restrict delete |
ph_booking_fkmd | ph_booking.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
ph_room_booking_fk1 | ph_room_booking.ph_booking_key_i | ph_booking.ph_key_i | Restrict delete |
ph_room_booking_fk2 | ph_room_booking.ph_room_alloc_key_i | pc_room_alloc.pc_key_i | Restrict delete |
ph_room_booking_fkcr | ph_room_booking.s_created_by_c | s_user.s_user_id_c | Restrict delete |
ph_room_booking_fkmd | ph_room_booking.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_file_fk1 | pm_application_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
pm_application_file_fk2 | pm_application_file.p_partner_key_n pm_application_file.pm_application_key_i pm_application_file.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
pm_application_file_fkcr | pm_application_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_file_fkmd | pm_application_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_forms_file_fk1 | pm_application_forms_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
pm_application_forms_file_fk2 | pm_application_forms_file.p_partner_key_n pm_application_forms_file.pm_application_key_i pm_application_forms_file.pm_registration_office_n pm_application_forms_file.pt_form_name_c |
pm_application_forms.p_partner_key_n pm_application_forms.pm_application_key_i pm_application_forms.pm_registration_office_n pm_application_forms.pt_form_name_c |
Restrict delete |
pm_application_forms_file_fkcr | pm_application_forms_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_forms_file_fkmd | pm_application_forms_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_forms_fk1 | pm_application_forms.p_partner_key_n pm_application_forms.pm_application_key_i pm_application_forms.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
pm_application_forms_fk2 | pm_application_forms.pt_form_name_c | pt_app_form_types.pt_form_name_c | Restrict delete |
pm_application_forms_fk3 | pm_application_forms.pm_reference_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
pm_application_forms_fkcr | pm_application_forms.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_forms_fkmd | pm_application_forms.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_status_history_fk1 | pm_application_status_history.p_partner_key_n pm_application_status_history.pm_application_key_i pm_application_status_history.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
pm_application_status_history_fk2 | pm_application_status_history.pm_status_code_c | pt_applicant_status.pt_code_c | Restrict delete |
pm_application_status_history_fkcr | pm_application_status_history.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_application_status_history_fkmd | pm_application_status_history.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_commitment_status_fkcr | pm_commitment_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_commitment_status_fkmd | pm_commitment_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_category_fkcr | pm_document_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_category_fkmd | pm_document_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_file_fk1 | pm_document_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
pm_document_file_fk2 | pm_document_file.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
pm_document_file_fk3 | pm_document_file.p_site_key_n pm_document_file.pm_document_key_n |
pm_document.p_site_key_n pm_document.pm_document_key_n |
Restrict delete |
pm_document_file_fkcr | pm_document_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_file_fkmd | pm_document_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_fk1 | pm_document.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_document_fk2 | pm_document.pm_doc_code_c | pm_document_type.pm_doc_code_c | Restrict delete |
pm_document_fk3 | pm_document.pm_contact_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
pm_document_fkcr | pm_document.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_fkmd | pm_document.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_type_fk1 | pm_document_type.pm_doc_category_c | pm_document_category.pm_code_c | Restrict delete |
pm_document_type_fkcr | pm_document_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_document_type_fkmd | pm_document_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_formal_education_fk1 | pm_formal_education.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_formal_education_fk2 | pm_formal_education.p_country_code_c | p_country.p_country_code_c | Restrict delete |
pm_formal_education_fkcr | pm_formal_education.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_formal_education_fkmd | pm_formal_education.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_general_application_fk1 | pm_general_application.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_general_application_fk10 | pm_general_application.pm_closed_by_c | s_user.s_user_id_c | Restrict delete |
pm_general_application_fk2 | pm_general_application.pm_registration_office_n | p_unit.p_partner_key_n | Restrict delete |
pm_general_application_fk3 | pm_general_application.pm_gen_app_poss_srv_unit_key_n | p_unit.p_partner_key_n | Restrict delete |
pm_general_application_fk4 | pm_general_application.pm_gen_application_status_c | pt_applicant_status.pt_code_c | Restrict delete |
pm_general_application_fk5 | pm_general_application.pt_app_type_name_c | pt_application_type.pt_app_type_name_c | Restrict delete |
pm_general_application_fk6 | pm_general_application.pm_gen_contact1_c | pt_contact.pt_contact_name_c | Restrict delete |
pm_general_application_fk7 | pm_general_application.pm_gen_contact2_c | pt_contact.pt_contact_name_c | Restrict delete |
pm_general_application_fk8 | pm_general_application.pm_gen_app_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
pm_general_application_fk9 | pm_general_application.pm_placement_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_general_application_fkcr | pm_general_application.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_general_application_fkmd | pm_general_application.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_interview_fk1 | pm_interview.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_interview_fkcr | pm_interview.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_interview_fkmd | pm_interview.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_job_assignment_fk1 | pm_job_assignment.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
pm_job_assignment_fk2 | pm_job_assignment.pm_unit_key_n pm_job_assignment.pt_position_name_c pm_job_assignment.pt_position_scope_c pm_job_assignment.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
pm_job_assignment_fk3 | pm_job_assignment.pt_assignment_type_code_c | pt_assignment_type.pt_assignment_type_code_c | Restrict delete |
pm_job_assignment_fk4 | pm_job_assignment.pm_leaving_code_c | pt_leaving_code.pt_leaving_code_ind_c | Restrict delete |
pm_job_assignment_fkcr | pm_job_assignment.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_job_assignment_fkmd | pm_job_assignment.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_long_term_support_figures_fk1 | pm_long_term_support_figures.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_long_term_support_figures_fkcr | pm_long_term_support_figures.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_long_term_support_figures_fkmd | pm_long_term_support_figures.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_ownership_fk1 | pm_ownership.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_ownership_fk2 | pm_ownership.pt_valuable_item_name_c | pt_valuable_item.pt_valuable_item_name_c | Restrict delete |
pm_ownership_fkcr | pm_ownership.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_ownership_fkmd | pm_ownership.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_passport_details_fk1 | pm_passport_details.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_passport_details_fk2 | pm_passport_details.pm_passport_details_type_c | pt_passport_type.pt_code_c | Restrict delete |
pm_passport_details_fk3 | pm_passport_details.p_passport_nationality_code_c | p_country.p_country_code_c | Restrict delete |
pm_passport_details_fk4 | pm_passport_details.p_country_of_issue_c | p_country.p_country_code_c | Restrict delete |
pm_passport_details_fkcr | pm_passport_details.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_passport_details_fkmd | pm_passport_details.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_past_experience_fk1 | pm_past_experience.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_past_experience_fkcr | pm_past_experience.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_past_experience_fkmd | pm_past_experience.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_pers_office_specific_data_fk1 | pm_pers_office_specific_data.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_pers_office_specific_data_fkcr | pm_pers_office_specific_data.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_pers_office_specific_data_fkmd | pm_pers_office_specific_data.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_ability_fk1 | pm_person_ability.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_ability_fk2 | pm_person_ability.pt_ability_area_name_c | pt_ability_area.pt_ability_area_name_c | Restrict delete |
pm_person_ability_fk3 | pm_person_ability.pt_ability_level_i | pt_ability_level.pt_ability_level_i | Restrict delete |
pm_person_ability_fkcr | pm_person_ability.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_ability_fkmd | pm_person_ability.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_absence_fk1 | pm_person_absence.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_absence_fkcr | pm_person_absence.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_absence_fkmd | pm_person_absence.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_commitment_status_fk1 | pm_person_commitment_status.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_commitment_status_fk2 | pm_person_commitment_status.pm_status_code_c | pm_commitment_status.pm_code_c | Restrict delete |
pm_person_commitment_status_fkcr | pm_person_commitment_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_commitment_status_fkmd | pm_person_commitment_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_evaluation_fk1 | pm_person_evaluation.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_evaluation_fkcr | pm_person_evaluation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_evaluation_fkmd | pm_person_evaluation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_file_fk1 | pm_person_file.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_file_fk2 | pm_person_file.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
pm_person_file_fkcr | pm_person_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_file_fkmd | pm_person_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_language_fk1 | pm_person_language.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_language_fk2 | pm_person_language.p_language_code_c | p_language.p_language_code_c | Restrict delete |
pm_person_language_fk3 | pm_person_language.pt_language_level_i | pt_language_level.pt_language_level_i | Restrict delete |
pm_person_language_fkcr | pm_person_language.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_language_fkmd | pm_person_language.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_qualification_fk1 | pm_person_qualification.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_qualification_fk2 | pm_person_qualification.pt_qualification_area_name_c | pt_qualification_area.pt_qualification_area_name_c | Restrict delete |
pm_person_qualification_fk3 | pm_person_qualification.pt_qualification_level_i | pt_qualification_level.pt_qualification_level_i | Restrict delete |
pm_person_qualification_fkcr | pm_person_qualification.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_qualification_fkmd | pm_person_qualification.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_skill_fk1 | pm_person_skill.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_skill_fk2 | pm_person_skill.pm_skill_category_code_c | pt_skill_category.pt_code_c | Restrict delete |
pm_person_skill_fk3 | pm_person_skill.pm_description_language_c | p_language.p_language_code_c | Restrict delete |
pm_person_skill_fk4 | pm_person_skill.pm_skill_level_i | pt_skill_level.pt_level_i | Restrict delete |
pm_person_skill_fkcr | pm_person_skill.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_skill_fkmd | pm_person_skill.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_vision_fk1 | pm_person_vision.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_person_vision_fk2 | pm_person_vision.pt_vision_area_name_c | pt_vision_area.pt_vision_area_name_c | Restrict delete |
pm_person_vision_fk3 | pm_person_vision.pt_vision_level_i | pt_vision_level.pt_vision_level_i | Restrict delete |
pm_person_vision_fkcr | pm_person_vision.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_person_vision_fkmd | pm_person_vision.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_personal_data_fk1 | pm_personal_data.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_personal_data_fk2 | pm_personal_data.pm_driver_status_c | pt_driver_status.pt_code_c | Restrict delete |
pm_personal_data_fk3 | pm_personal_data.p_language_code_c | p_language.p_language_code_c | Restrict delete |
pm_personal_data_fkcr | pm_personal_data.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_personal_data_fkmd | pm_personal_data.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_short_term_application_fk1 | pm_short_term_application.p_partner_key_n pm_short_term_application.pm_application_key_i pm_short_term_application.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
pm_short_term_application_fk10 | pm_short_term_application.pm_st_pre_congress_code_c | pt_congress_code.pt_code_c | Restrict delete |
pm_short_term_application_fk11 | pm_short_term_application.pm_st_congress_code_c | pt_congress_code.pt_code_c | Restrict delete |
pm_short_term_application_fk12 | pm_short_term_application.pm_outreach_role_c | pt_congress_code.pt_code_c | Restrict delete |
pm_short_term_application_fk13 | pm_short_term_application.pm_st_congress_language_c | p_language.p_language_code_c | Restrict delete |
pm_short_term_application_fk14 | pm_short_term_application.pm_st_country_pref_c | pt_outreach_preference_level.pt_code_c | Restrict delete |
pm_short_term_application_fk15 | pm_short_term_application.pm_st_activity_pref_c | pt_outreach_preference_level.pt_code_c | Restrict delete |
pm_short_term_application_fk16 | pm_short_term_application.pm_st_confirmed_option_n | p_unit.p_partner_key_n | Restrict delete |
pm_short_term_application_fk17 | pm_short_term_application.pm_st_option1_n | p_unit.p_partner_key_n | Restrict delete |
pm_short_term_application_fk18 | pm_short_term_application.pm_st_option2_n | p_unit.p_partner_key_n | Restrict delete |
pm_short_term_application_fk19 | pm_short_term_application.pm_st_current_field_n | p_unit.p_partner_key_n | Restrict delete |
pm_short_term_application_fk2 | pm_short_term_application.pm_st_special_applicant_c | pt_special_applicant.pt_code_c | Restrict delete |
pm_short_term_application_fk20 | pm_short_term_application.pm_st_field_charged_n | p_unit.p_partner_key_n | Restrict delete |
pm_short_term_application_fk21 | pm_short_term_application.pm_st_recruit_efforts_c | p_acquisition.p_acquisition_code_c | Restrict delete |
pm_short_term_application_fk3 | pm_short_term_application.pm_st_leadership_rating_c | pt_leadership_rating.pt_code_c | Restrict delete |
pm_short_term_application_fk4 | pm_short_term_application.pt_arrival_point_code_c | pt_arrival_point.pt_code_c | Restrict delete |
pm_short_term_application_fk5 | pm_short_term_application.pt_departure_point_code_c | pt_arrival_point.pt_code_c | Restrict delete |
pm_short_term_application_fk6 | pm_short_term_application.pm_st_party_contact_n | p_partner.p_partner_key_n | Restrict delete |
pm_short_term_application_fk7 | pm_short_term_application.pm_st_party_together_c | pt_party_type.pt_code_c | Restrict delete |
pm_short_term_application_fk8 | pm_short_term_application.pt_travel_type_to_cong_code_c | pt_travel_type.pt_code_c | Restrict delete |
pm_short_term_application_fk9 | pm_short_term_application.pt_travel_type_from_cong_code_c | pt_travel_type.pt_code_c | Restrict delete |
pm_short_term_application_fkcr | pm_short_term_application.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_short_term_application_fkmd | pm_short_term_application.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_special_need_fk1 | pm_special_need.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_special_need_fkcr | pm_special_need.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_special_need_fkmd | pm_special_need.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_staff_data_fk1 | pm_staff_data.p_partner_key_n | p_person.p_partner_key_n | Restrict delete |
pm_staff_data_fk2 | pm_staff_data.pm_office_recruited_by_n | p_unit.p_partner_key_n | Restrict delete |
pm_staff_data_fk3 | pm_staff_data.pm_home_office_n | p_unit.p_partner_key_n | Restrict delete |
pm_staff_data_fk4 | pm_staff_data.pm_receiving_field_n | p_unit.p_partner_key_n | Restrict delete |
pm_staff_data_fk5 | pm_staff_data.pm_receiving_field_office_n | p_unit.p_partner_key_n | Restrict delete |
pm_staff_data_fk6 | pm_staff_data.pm_status_code_c | pm_commitment_status.pm_code_c | Restrict delete |
pm_staff_data_fkcr | pm_staff_data.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_staff_data_fkmd | pm_staff_data.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pm_year_program_application_fk1 | pm_year_program_application.p_partner_key_n pm_year_program_application.pm_application_key_i pm_year_program_application.pm_registration_office_n |
pm_general_application.p_partner_key_n pm_general_application.pm_application_key_i pm_general_application.pm_registration_office_n |
Restrict delete |
pm_year_program_application_fk2 | pm_year_program_application.pt_position_name_c pm_year_program_application.pt_position_scope_c |
pt_position.pt_position_name_c pt_position.pt_position_scope_c |
Restrict delete |
pm_year_program_application_fkcr | pm_year_program_application.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pm_year_program_application_fkmd | pm_year_program_application.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_ability_area_fkcr | pt_ability_area.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_ability_area_fkmd | pt_ability_area.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_ability_level_fkcr | pt_ability_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_ability_level_fkmd | pt_ability_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_app_form_types_fkcr | pt_app_form_types.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_app_form_types_fkmd | pt_app_form_types.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_applicant_status_fkcr | pt_applicant_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_applicant_status_fkmd | pt_applicant_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_application_type_fkcr | pt_application_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_application_type_fkmd | pt_application_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_arrival_point_fkcr | pt_arrival_point.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_arrival_point_fkmd | pt_arrival_point.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_assignment_type_fkcr | pt_assignment_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_assignment_type_fkmd | pt_assignment_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_congress_code_fkcr | pt_congress_code.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_congress_code_fkmd | pt_congress_code.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_contact_fkcr | pt_contact.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_contact_fkmd | pt_contact.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_driver_status_fkcr | pt_driver_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_driver_status_fkmd | pt_driver_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_language_level_fkcr | pt_language_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_language_level_fkmd | pt_language_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_leadership_rating_fkcr | pt_leadership_rating.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_leadership_rating_fkmd | pt_leadership_rating.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_leaving_code_fkcr | pt_leaving_code.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_leaving_code_fkmd | pt_leaving_code.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_marital_status_fkcr | pt_marital_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_marital_status_fkmd | pt_marital_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_office_specific_data_labels_fkcr | pt_office_specific_data_labels.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_office_specific_data_labels_fkmd | pt_office_specific_data_labels.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_outreach_preference_level_fkcr | pt_outreach_preference_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_outreach_preference_level_fkmd | pt_outreach_preference_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_party_type_fkcr | pt_party_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_party_type_fkmd | pt_party_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_passport_type_fkcr | pt_passport_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_passport_type_fkmd | pt_passport_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_personal_data_labels_fkcr | pt_personal_data_labels.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_personal_data_labels_fkmd | pt_personal_data_labels.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_position_fk1 | pt_position.pt_position_scope_c | u_unit_type.u_unit_type_code_c | Restrict delete |
pt_position_fkcr | pt_position.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_position_fkmd | pt_position.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_qualification_area_fkcr | pt_qualification_area.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_qualification_area_fkmd | pt_qualification_area.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_qualification_level_fkcr | pt_qualification_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_qualification_level_fkmd | pt_qualification_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_reports_fk1 | pt_reports.pt_report_program_c | s_file.s_file_name_c | Restrict delete |
pt_reports_fkcr | pt_reports.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_reports_fkmd | pt_reports.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_skill_category_fkcr | pt_skill_category.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_skill_category_fkmd | pt_skill_category.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_skill_level_fkcr | pt_skill_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_skill_level_fkmd | pt_skill_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_special_applicant_fkcr | pt_special_applicant.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_special_applicant_fkmd | pt_special_applicant.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_travel_type_fkcr | pt_travel_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_travel_type_fkmd | pt_travel_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_valuable_item_fkcr | pt_valuable_item.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_valuable_item_fkmd | pt_valuable_item.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_vision_area_fkcr | pt_vision_area.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_vision_area_fkmd | pt_vision_area.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
pt_vision_level_fkcr | pt_vision_level.s_created_by_c | s_user.s_user_id_c | Restrict delete |
pt_vision_level_fkmd | pt_vision_level.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_batch_job_fk1 | s_batch_job.s_file_name_c | s_file.s_file_name_c | Restrict delete |
s_batch_job_fk2 | s_batch_job.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_batch_job_fkcr | s_batch_job.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_batch_job_fkmd | s_batch_job.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_change_event_fkcr | s_change_event.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_change_event_fkmd | s_change_event.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_default_file_volume_fk1 | s_default_file_volume.s_group_name_c | s_volume_partner_group.s_name_c | Restrict delete |
s_default_file_volume_fk2 | s_default_file_volume.s_volume_name_c | s_volume.s_name_c | Restrict delete |
s_default_file_volume_fkcr | s_default_file_volume.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_default_file_volume_fkmd | s_default_file_volume.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_error_log_fk2 | s_error_log.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_error_log_fkcr | s_error_log.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_error_log_fkmd | s_error_log.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_error_message_fk1 | s_error_message.s_language_code_c | p_language.p_language_code_c | Restrict delete |
s_error_message_fkcr | s_error_message.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_error_message_fkmd | s_error_message.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_file_fkcr | s_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_file_fkmd | s_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_form_fkcr | s_form.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_form_fkmd | s_form.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_function_fkcr | s_function.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_function_fkmd | s_function.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_function_relationship_fk1 | s_function_relationship.s_function_1_c | s_function.s_function_id_c | Restrict delete |
s_function_relationship_fk2 | s_function_relationship.s_function_2_c | s_function.s_function_id_c | Restrict delete |
s_function_relationship_fkcr | s_function_relationship.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_function_relationship_fkmd | s_function_relationship.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_cost_centre_fk1 | s_group_cost_centre.s_group_id_c s_group_cost_centre.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_cost_centre_fk2 | s_group_cost_centre.a_ledger_number_i s_group_cost_centre.a_cost_centre_code_c |
a_cost_centre.a_ledger_number_i a_cost_centre.a_cost_centre_code_c |
Restrict delete |
s_group_cost_centre_fkcr | s_group_cost_centre.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_cost_centre_fkmd | s_group_cost_centre.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_data_label_fk1 | s_group_data_label.s_group_id_c s_group_data_label.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_data_label_fk2 | s_group_data_label.p_data_label_key_i | p_data_label.p_key_i | Restrict delete |
s_group_data_label_fkcr | s_group_data_label.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_data_label_fkmd | s_group_data_label.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_extract_fk1 | s_group_extract.s_group_id_c s_group_extract.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_extract_fk2 | s_group_extract.m_extract_id_i | m_extract_master.m_extract_id_i | Restrict delete |
s_group_extract_fkcr | s_group_extract.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_extract_fkmd | s_group_extract.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_file_info_fk1 | s_group_file_info.s_group_id_c s_group_file_info.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_file_info_fk2 | s_group_file_info.p_file_info_key_n | p_file_info.p_key_n | Restrict delete |
s_group_file_info_fkcr | s_group_file_info.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_file_info_fkmd | s_group_file_info.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_fkcr | s_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_fkmd | s_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_function_fk1 | s_group_function.s_group_id_c s_group_function.s_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_function_fk2 | s_group_function.s_function_id_c | s_function.s_function_id_c | Restrict delete |
s_group_function_fkcr | s_group_function.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_function_fkmd | s_group_function.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_gift_fk1 | s_group_gift.s_group_id_c s_group_gift.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_gift_fk2 | s_group_gift.a_ledger_number_i s_group_gift.a_batch_number_i s_group_gift.a_gift_transaction_number_i |
a_gift.a_ledger_number_i a_gift.a_batch_number_i a_gift.a_gift_transaction_number_i |
Restrict delete |
s_group_gift_fkcr | s_group_gift.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_gift_fkmd | s_group_gift.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_ledger_fk1 | s_group_ledger.s_group_id_c s_group_ledger.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_ledger_fk2 | s_group_ledger.a_ledger_number_i | a_ledger.a_ledger_number_i | Restrict delete |
s_group_ledger_fkcr | s_group_ledger.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_ledger_fkmd | s_group_ledger.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_location_fk1 | s_group_location.s_group_id_c s_group_location.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_location_fk2 | s_group_location.p_site_key_n s_group_location.p_location_key_i |
p_location.p_site_key_n p_location.p_location_key_i |
Restrict delete |
s_group_location_fkcr | s_group_location.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_location_fkmd | s_group_location.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_module_acc_perm_fk1 | s_group_module_access_permission.s_group_id_c s_group_module_access_permission.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_module_acc_perm_fk2 | s_group_module_access_permission.s_module_id_c | s_module.s_module_id_c | Restrict delete |
s_group_module_access_permission_fkcr | s_group_module_access_permission.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_module_access_permission_fkmd | s_group_module_access_permission.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_motivation_fk1 | s_group_motivation.s_group_id_c s_group_motivation.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_motivation_fk2 | s_group_motivation.a_ledger_number_i s_group_motivation.a_motivation_group_code_c s_group_motivation.a_motivation_detail_code_c |
a_motivation_detail.a_ledger_number_i a_motivation_detail.a_motivation_group_code_c a_motivation_detail.a_motivation_detail_code_c |
Restrict delete |
s_group_motivation_fkcr | s_group_motivation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_motivation_fkmd | s_group_motivation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_contact_fk1 | s_group_partner_contact.s_group_id_c s_group_partner_contact.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_partner_contact_fk2 | s_group_partner_contact.p_contact_id_i | p_partner_contact.p_contact_id_i | Restrict delete |
s_group_partner_contact_fkcr | s_group_partner_contact.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_contact_fkmd | s_group_partner_contact.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_location_fk1 | s_group_partner_location.s_group_id_c s_group_partner_location.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_partner_location_fk2 | s_group_partner_location.p_partner_key_n s_group_partner_location.p_site_key_n s_group_partner_location.p_location_key_i |
p_partner_location.p_partner_key_n p_partner_location.p_site_key_n p_partner_location.p_location_key_i |
Restrict delete |
s_group_partner_location_fkcr | s_group_partner_location.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_location_fkmd | s_group_partner_location.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_reminder_fk1 | s_group_partner_reminder.s_group_id_c s_group_partner_reminder.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_partner_reminder_fk2 | s_group_partner_reminder.p_partner_key_n s_group_partner_reminder.p_contact_id_i s_group_partner_reminder.p_reminder_id_i |
p_partner_reminder.p_partner_key_n p_partner_reminder.p_contact_id_i p_partner_reminder.p_reminder_id_i |
Restrict delete |
s_group_partner_reminder_fkcr | s_group_partner_reminder.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_reminder_fkmd | s_group_partner_reminder.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_set_fk1 | s_group_partner_set.s_group_id_c s_group_partner_set.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_partner_set_fk2 | s_group_partner_set.p_partner_set_id_c s_group_partner_set.p_partner_set_unit_key_n |
p_partner_set.p_partner_set_id_c p_partner_set.p_unit_key_n |
Restrict delete |
s_group_partner_set_fkcr | s_group_partner_set.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_partner_set_fkmd | s_group_partner_set.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_group_table_acc_perm_fk1 | s_group_table_access_permission.s_group_id_c s_group_table_access_permission.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_group_table_access_permission_fkcr | s_group_table_access_permission.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_group_table_access_permission_fkmd | s_group_table_access_permission.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_job_group_fk1 | s_job_group.s_unit_key_n s_job_group.pt_position_name_c s_job_group.pt_position_scope_c s_job_group.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
s_job_group_fk2 | s_job_group.s_group_id_c s_job_group.s_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_job_group_fkcr | s_job_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_job_group_fkmd | s_job_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_label_fk1 | s_label.s_form_name_c | s_form.s_form_name_c | Restrict delete |
s_label_fkcr | s_label.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_label_fkmd | s_label.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_language_specific_fk1 | s_language_specific.s_language_code_c | p_language.p_language_code_c | Restrict delete |
s_language_specific_fkcr | s_language_specific.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_language_specific_fkmd | s_language_specific.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_login_fkcr | s_login.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_login_fkmd | s_login.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_logon_message_fk1 | s_logon_message.s_language_code_c | p_language.p_language_code_c | Restrict delete |
s_logon_message_fkcr | s_logon_message.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_logon_message_fkmd | s_logon_message.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_module_file_fkcr | s_module_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_module_file_fkmd | s_module_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_module_fkcr | s_module.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_module_fkmd | s_module.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_patch_log_fk1 | s_patch_log.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_patch_log_fkcr | s_patch_log.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_patch_log_fkmd | s_patch_log.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_report_file_fk1 | s_report_file.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_report_file_fk2 | s_report_file.s_rpg_c | s_file.s_file_name_c | Restrict delete |
s_report_file_fkcr | s_report_file.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_report_file_fkmd | s_report_file.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_report_options_fk1 | s_report_options.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_report_options_fk2 | s_report_options.s_module_id_c | s_module.s_module_id_c | Restrict delete |
s_report_options_fk3 | s_report_options.s_rpg_c | s_file.s_file_name_c | Restrict delete |
s_report_options_fkcr | s_report_options.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_report_options_fkmd | s_report_options.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_reports_to_archive_fkcr | s_reports_to_archive.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_reports_to_archive_fkmd | s_reports_to_archive.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_selected_output_destination_fk1 | s_selected_output_destination.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_selected_output_destination_fk2 | s_selected_output_destination.s_module_id_c | s_module.s_module_id_c | Restrict delete |
s_selected_output_destination_fkcr | s_selected_output_destination.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_selected_output_destination_fkmd | s_selected_output_destination.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_system_defaults_fkcr | s_system_defaults.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_system_defaults_fkmd | s_system_defaults.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_system_status_fk1 | s_system_status.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_system_status_fkcr | s_system_status.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_system_status_fkmd | s_system_status.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_system_status_log_fk1 | s_system_status_log.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_system_status_log_fkcr | s_system_status_log.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_system_status_log_fkmd | s_system_status_log.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_user_defaults_fk1 | s_user_defaults.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_user_defaults_fkcr | s_user_defaults.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_user_defaults_fkmd | s_user_defaults.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_user_fk1 | s_user.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
s_user_group_fk1 | s_user_group.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_user_group_fk2 | s_user_group.s_group_id_c s_user_group.s_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_user_group_fkcr | s_user_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_user_group_fkmd | s_user_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_user_module_acc_perm_fk1 | s_user_module_access_permission.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_user_module_acc_perm_fk2 | s_user_module_access_permission.s_module_id_c | s_module.s_module_id_c | Restrict delete |
s_user_module_access_permission_fkcr | s_user_module_access_permission.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_user_module_access_permission_fkmd | s_user_module_access_permission.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_user_table_acc_perm_fk1 | s_user_table_access_permission.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_user_table_access_permission_fkcr | s_user_table_access_permission.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_user_table_access_permission_fkmd | s_user_table_access_permission.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_valid_output_form_fk1 | s_valid_output_form.s_module_id_c | s_module.s_module_id_c | Restrict delete |
s_valid_output_form_fk2 | s_valid_output_form.s_form_name_c | s_form.s_form_name_c | Restrict delete |
s_valid_output_form_fkcr | s_valid_output_form.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_valid_output_form_fkmd | s_valid_output_form.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_fk1 | s_volume.s_parent_volume_name_c | s_volume.s_name_c | Restrict delete |
s_volume_fkcr | s_volume.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_fkmd | s_volume.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_partner_group_fkcr | s_volume_partner_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_partner_group_fkmd | s_volume_partner_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_partner_group_partner_fkcr | s_volume_partner_group_partner.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_partner_group_partner_fkmd | s_volume_partner_group_partner.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_volume_partner_group_ptn_fk1 | s_volume_partner_group_partner.s_group_name_c | s_volume_partner_group.s_name_c | Restrict delete |
s_volume_partner_group_ptn_fk2 | s_volume_partner_group_partner.p_partner_key_n | p_partner.p_partner_key_n | Restrict delete |
s_workflow_definition_fkcr | s_workflow_definition.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_definition_fkmd | s_workflow_definition.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_group_fk1 | s_workflow_group.s_workflow_id_i | s_workflow_definition.s_workflow_id_i | Restrict delete |
s_workflow_group_fk2 | s_workflow_group.s_group_id_c s_workflow_group.s_group_unit_key_n |
s_group.s_group_id_c s_group.s_unit_key_n |
Restrict delete |
s_workflow_group_fkcr | s_workflow_group.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_group_fkmd | s_workflow_group.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_instance_fk1 | s_workflow_instance.s_workflow_id_i | s_workflow_definition.s_workflow_id_i | Restrict delete |
s_workflow_instance_fkcr | s_workflow_instance.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_instance_fkmd | s_workflow_instance.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_instance_step_fk1 | s_workflow_instance_step.s_workflow_instance_id_i | s_workflow_instance.s_workflow_instance_id_i | Restrict delete |
s_workflow_instance_step_fk2 | s_workflow_instance_step.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_workflow_instance_step_fkcr | s_workflow_instance_step.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_instance_step_fkmd | s_workflow_instance_step.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_step_fk1 | s_workflow_step.s_workflow_id_i | s_workflow_definition.s_workflow_id_i | Restrict delete |
s_workflow_step_fk2 | s_workflow_step.s_function_id_c | s_function.s_function_id_c | Restrict delete |
s_workflow_step_fkcr | s_workflow_step.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_step_fkmd | s_workflow_step.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_user_fk1 | s_workflow_user.s_workflow_id_i | s_workflow_definition.s_workflow_id_i | Restrict delete |
s_workflow_user_fk2 | s_workflow_user.s_user_id_c | s_user.s_user_id_c | Restrict delete |
s_workflow_user_fkcr | s_workflow_user.s_created_by_c | s_user.s_user_id_c | Restrict delete |
s_workflow_user_fkmd | s_workflow_user.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
u_unit_type_fkcr | u_unit_type.s_created_by_c | s_user.s_user_id_c | Restrict delete |
u_unit_type_fkmd | u_unit_type.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_job_fk1 | um_job.pm_unit_key_n | p_unit.p_partner_key_n | Restrict delete |
um_job_fk2 | um_job.pt_position_name_c um_job.pt_position_scope_c |
pt_position.pt_position_name_c pt_position.pt_position_scope_c |
Restrict delete |
um_job_fkcr | um_job.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_job_fkmd | um_job.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_job_language_fk1 | um_job_language.pm_unit_key_n um_job_language.pt_position_name_c um_job_language.pt_position_scope_c um_job_language.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
um_job_language_fk2 | um_job_language.p_language_code_c | p_language.p_language_code_c | Restrict delete |
um_job_language_fk3 | um_job_language.pt_language_level_i | pt_language_level.pt_language_level_i | Restrict delete |
um_job_language_fkcr | um_job_language.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_job_language_fkmd | um_job_language.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_job_qualification_fk1 | um_job_qualification.pm_unit_key_n um_job_qualification.pt_position_name_c um_job_qualification.pt_position_scope_c um_job_qualification.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
um_job_qualification_fk2 | um_job_qualification.pt_qualification_area_name_c | pt_qualification_area.pt_qualification_area_name_c | Restrict delete |
um_job_qualification_fk3 | um_job_qualification.pt_qualification_level_i | pt_qualification_level.pt_qualification_level_i | Restrict delete |
um_job_qualification_fkcr | um_job_qualification.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_job_qualification_fkmd | um_job_qualification.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_job_requirement_fk1 | um_job_requirement.pm_unit_key_n um_job_requirement.pt_position_name_c um_job_requirement.pt_position_scope_c um_job_requirement.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
um_job_requirement_fk2 | um_job_requirement.pt_ability_area_name_c | pt_ability_area.pt_ability_area_name_c | Restrict delete |
um_job_requirement_fk3 | um_job_requirement.pt_ability_level_i | pt_ability_level.pt_ability_level_i | Restrict delete |
um_job_requirement_fkcr | um_job_requirement.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_job_requirement_fkmd | um_job_requirement.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_job_vision_fk1 | um_job_vision.pm_unit_key_n um_job_vision.pt_position_name_c um_job_vision.pt_position_scope_c um_job_vision.um_job_key_i |
um_job.pm_unit_key_n um_job.pt_position_name_c um_job.pt_position_scope_c um_job.um_job_key_i |
Restrict delete |
um_job_vision_fk2 | um_job_vision.pt_vision_area_name_c | pt_vision_area.pt_vision_area_name_c | Restrict delete |
um_job_vision_fk3 | um_job_vision.pt_vision_level_i | pt_vision_level.pt_vision_level_i | Restrict delete |
um_job_vision_fkcr | um_job_vision.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_job_vision_fkmd | um_job_vision.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_ability_fk1 | um_unit_ability.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_ability_fk2 | um_unit_ability.pt_ability_area_name_c | pt_ability_area.pt_ability_area_name_c | Restrict delete |
um_unit_ability_fk3 | um_unit_ability.pt_ability_level_i | pt_ability_level.pt_ability_level_i | Restrict delete |
um_unit_ability_fkcr | um_unit_ability.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_ability_fkmd | um_unit_ability.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_cost_fk1 | um_unit_cost.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_cost_fk2 | um_unit_cost.a_local_currency_code_c | a_currency.a_currency_code_c | Restrict delete |
um_unit_cost_fkcr | um_unit_cost.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_cost_fkmd | um_unit_cost.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_evaluation_fk1 | um_unit_evaluation.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_evaluation_fkcr | um_unit_evaluation.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_evaluation_fkmd | um_unit_evaluation.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_language_fk1 | um_unit_language.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_language_fk2 | um_unit_language.p_language_code_c | p_language.p_language_code_c | Restrict delete |
um_unit_language_fk3 | um_unit_language.pt_language_level_i | pt_language_level.pt_language_level_i | Restrict delete |
um_unit_language_fkcr | um_unit_language.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_language_fkmd | um_unit_language.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_structure_fk1 | um_unit_structure.um_parent_unit_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_structure_fk2 | um_unit_structure.um_child_unit_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_structure_fkcr | um_unit_structure.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_structure_fkmd | um_unit_structure.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_vision_fk1 | um_unit_vision.p_partner_key_n | p_unit.p_partner_key_n | Restrict delete |
um_unit_vision_fk2 | um_unit_vision.pt_vision_area_name_c | pt_vision_area.pt_vision_area_name_c | Restrict delete |
um_unit_vision_fk3 | um_unit_vision.pt_vision_level_i | pt_vision_level.pt_vision_level_i | Restrict delete |
um_unit_vision_fkcr | um_unit_vision.s_created_by_c | s_user.s_user_id_c | Restrict delete |
um_unit_vision_fkmd | um_unit_vision.s_modified_by_c | s_user.s_user_id_c | Restrict delete |
Check Constraints:
Table | Constraint Name | Constraint |
---|---|---|
None detected |