Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
a_asset_change.[a_asset_acct_id] a_asset_acct.[a_asset_acct_id]
a_asset_info_ins.[a_asset_id] a_asset.[a_asset_id]
a_asset_info_oth.[a_asset_id] a_asset.[a_asset_id]
a_asset_info_tax.[a_asset_id] a_asset.[a_asset_id]
a_asset_split.[a_asset_acct_id] a_asset_acct.[a_asset_acct_id]
a_asset_split.[a_asset_id] a_asset.[a_asset_id]
a_asset_split.[a_depreciation_workfile_id] a_depreciation_workfile.[a_depreciation_workfile_id]
a_asset_transfer.[a_asset_acct_id] a_asset_acct.[a_asset_acct_id]
ad_ctxhelp.[ad_form_id] ad_form.[ad_form_id]
ad_ctxhelp.[ad_infowindow_id] ad_infowindow.[ad_infowindow_id]
ad_ctxhelp.[ad_process_id] ad_process.[ad_process_id]
ad_ctxhelp.[ad_tab_id] ad_tab.[ad_tab_id]
ad_ctxhelp.[ad_table_id] ad_table.[ad_table_id]
ad_ctxhelp.[ad_task_id] ad_task.[ad_task_id]
ad_ctxhelp.[ad_workflow_id] ad_workflow.[ad_workflow_id]
ad_field_backup.[ad_field_id] ad_field.[ad_field_id]
ad_field_backup.[ad_fieldgroup_id] ad_fieldgroup.[ad_fieldgroup_id]
ad_field_backup.[ad_reference_value_id] value.[value_id]
ad_field_backup.[ad_val_rule_id] ad_val_rule.[ad_val_rule_id]
ad_infocolumn_backup.[ad_infocolumn_id] ad_infocolumn.[ad_infocolumn_id]
ad_infocolumn_backup.[ad_reference_value_id] value.[value_id]
ad_infocolumn_backup.[ad_val_rule_id] ad_val_rule.[ad_val_rule_id]
ad_orginfo.[pa_goal_id] pa_goal.[pa_goal_id]
ad_package_imp_backup.[ad_package_imp_detail_id] ad_package_imp_detail.[ad_package_imp_detail_id]
ad_package_imp_backup.[ad_package_imp_id] ad_package_imp.[ad_package_imp_id]
ad_package_imp_backup.[ad_table_id] ad_table.[ad_table_id]
ad_replicationdocument.[ad_replicationstrategy_id] ad_replicationstrategy.[ad_replicationstrategy_id]
c_allocationline.[c_invoicepayschedule_id] c_invoicepayschedule.[c_invoicepayschedule_id]
c_charge.[lbr_productcategory_id] lbr_productcategory.[lbr_productcategory_id]
c_invoiceline.[lbr_cfop_id] lbr_cfop.[lbr_cfop_id]
c_invoicepayschedule.[c_payment_id] c_payment.[c_payment_id]
c_order.[cof_orgst_id] cof_orgst.[cof_orgst_id]
c_orderline.[lbr_cfop_id] lbr_cfop.[lbr_cfop_id]
c_orderline.[m_productionline_id] m_productionline.[m_productionline_id]
c_paymenttransaction.[c_doctype_id] c_doctype.[c_doctype_id]
c_tax.[lbr_taxname_id] lbr_taxname.[lbr_taxname_id]
cof_c_dime.[c_period_id] c_period.[c_period_id]
cof_c_doctype_return.[c_doctype_id] c_doctype.[c_doctype_id]
cof_c_ibptax.[c_region_id] c_region.[c_region_id]
cof_c_sintegra.[c_period_id] c_period.[c_period_id]
cof_c_sped_contabil_org.[cof_c_sped_contabil_id] cof_c_sped_contabil.[cof_c_sped_contabil_id]
cof_c_sped_contribuicoes.[c_period_id] c_period.[c_period_id]
cof_contract.[c_recurring_id] c_recurring.[c_recurring_id]
cof_cte_cobr_dup.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_compcomp.[cof_cte_infctecomp_id] cof_cte_infctecomp.[cof_cte_infctecomp_id]
cof_cte_compl_obscont.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_compl_obsfisco.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_contq.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_emitdocant.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_fluxo_pass.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_iddocantele.[cof_cte_emitdocant_id] cof_cte_emitdocant.[cof_cte_emitdocant_id]
cof_cte_iddocantpap.[cof_cte_emitdocant_id] cof_cte_emitdocant.[cof_cte_emitdocant_id]
cof_cte_infcarga_infq.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_infctecomp.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_laccontq.[cof_cte_contq_id] cof_cte_contq.[cof_cte_contq_id]
cof_cte_peri.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_rem_infnf.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_rem_infnfe.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_rem_infoutros.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_seg.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_veicnovos.[cof_cte_id] cof_cte.[cof_cte_id]
cof_cte_vprest_comp.[cof_cte_id] cof_cte.[cof_cte_id]
cof_elementvaluereference.[c_element_id] c_element.[c_element_id]
cof_orgst.[c_country_id] c_country.[c_country_id]
cof_orgst.[c_region_id] c_region.[c_region_id]
cof_packinglist_line.[cof_localseparation_id] cof_localseparation.[cof_localseparation_id]
cof_participant.[c_bpartner_id] c_bpartner.[c_bpartner_id]
cof_participant.[c_period_id] c_period.[c_period_id]
cof_r_survey.[ad_table_id] ad_table.[ad_table_id]
cof_r_survey_answer.[cof_r_survey_id] cof_r_survey.[cof_r_survey_id]
cof_r_survey_answer_value.[cof_r_survey_question_id] cof_r_survey_question.[cof_r_survey_question_id]
cof_selection.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
cof_selection.[m_attributesetinstance_id] m_attributesetinstance.[m_attributesetinstance_id]
i_asset.[a_asset_id] a_asset.[a_asset_id]
i_fajournal.[a_asset_id] a_asset.[a_asset_id]
i_fajournal.[c_conversiontype_id] c_conversiontype.[c_conversiontype_id]
i_fajournal.[c_subacct_id] c_subacct.[c_subacct_id]
i_inout.[c_bpartner_id] c_bpartner.[c_bpartner_id]
i_inout.[c_bpartner_location_id] c_bpartner_location.[c_bpartner_location_id]
i_inout.[c_doctype_id] c_doctype.[c_doctype_id]
i_inout.[m_attributesetinstance_id] m_attributesetinstance.[m_attributesetinstance_id]
i_inout.[m_inout_id] m_inout.[m_inout_id]
i_inout.[m_inoutline_id] m_inoutline.[m_inoutline_id]
i_inout.[m_locator_id] m_locator.[m_locator_id]
i_inout.[m_product_id] m_product.[m_product_id]
i_inout.[m_warehouse_id] m_warehouse.[m_warehouse_id]
i_taximport.[lbr_ncm_id] lbr_ncm.[lbr_ncm_id]
lbr_averagecost.[c_period_id] c_period.[c_period_id]
lbr_averagecost.[m_costelement_id] m_costelement.[m_costelement_id]
lbr_averagecostline.[lbr_averagecost_id] lbr_averagecost.[lbr_averagecost_id]
lbr_averagecostline.[m_product_id] m_product.[m_product_id]
lbr_cfopline.[c_doctype_id] c_doctype.[c_doctype_id]
lbr_cfopline.[lbr_bpartnercategory_id] lbr_bpartnercategory.[lbr_bpartnercategory_id]
lbr_cfopline.[lbr_productcategory_id] lbr_productcategory.[lbr_productcategory_id]
lbr_de.[c_country_id] c_country.[c_country_id]
lbr_di.[c_bpartner_id] c_bpartner.[c_bpartner_id]
lbr_di.[c_region_id] c_region.[c_region_id]
lbr_docfiscal.[c_doctype_id] c_doctype.[c_doctype_id]
lbr_docfiscal.[c_invoice_id] c_invoice.[c_invoice_id]
lbr_docfiscal.[c_order_id] c_order.[c_order_id]
lbr_docfiscal.[c_paymentterm_id] c_paymentterm.[c_paymentterm_id]
lbr_docfiscal.[lbr_nfelot_id] lbr_nfelot.[lbr_nfelot_id]
lbr_docfiscal.[m_inout_id] m_inout.[m_inout_id]
lbr_docfiscal.[m_pricelist_id] m_pricelist.[m_pricelist_id]
lbr_docfiscal.[m_shipper_id] m_shipper.[m_shipper_id]
lbr_docfiscal_line.[c_charge_id] c_charge.[c_charge_id]
lbr_docfiscal_line.[c_invoiceline_id] c_invoiceline.[c_invoiceline_id]
lbr_docfiscal_line.[c_uom_id] c_uom.[c_uom_id]
lbr_docfiscal_line.[lbr_cfop_id] lbr_cfop.[lbr_cfop_id]
lbr_docfiscal_line.[m_attributesetinstance_id] m_attributesetinstance.[m_attributesetinstance_id]
lbr_docfiscal_line.[m_product_id] m_product.[m_product_id]
lbr_docprintfield.[lbr_docprint_id] lbr_docprint.[lbr_docprint_id]
lbr_icmsmatrix.[c_region_id] c_region.[c_region_id]
lbr_issmatrix.[c_city_id] c_city.[c_city_id]
lbr_issmatrix.[c_region_id] c_region.[c_region_id]
lbr_issmatrix.[lbr_tax_id] lbr_tax.[lbr_tax_id]
lbr_issmatrix.[m_product_id] m_product.[m_product_id]
lbr_nfewebservice.[c_region_id] c_region.[c_region_id]
lbr_taxdefinition.[c_bpartner_id] c_bpartner.[c_bpartner_id]
lbr_taxdefinition.[c_doctype_id] c_doctype.[c_doctype_id]
lbr_taxdefinition.[c_region_id] c_region.[c_region_id]
lbr_taxdefinition.[lbr_bpartnercategory_id] lbr_bpartnercategory.[lbr_bpartnercategory_id]
lbr_taxdefinition.[lbr_cfop_id] lbr_cfop.[lbr_cfop_id]
lbr_taxdefinition.[lbr_fiscalgroup_bpartner_id] lbr_fiscalgroup_bpartner.[lbr_fiscalgroup_bpartner_id]
lbr_taxdefinition.[lbr_fiscalgroup_product_id] lbr_fiscalgroup_product.[lbr_fiscalgroup_product_id]
lbr_taxdefinition.[lbr_ncm_id] lbr_ncm.[lbr_ncm_id]
lbr_taxdefinition.[lbr_productcategory_id] lbr_productcategory.[lbr_productcategory_id]
lbr_taxdefinition.[lbr_tax_id] lbr_tax.[lbr_tax_id]
lbr_taxdefinition.[m_product_id] m_product.[m_product_id]
lbr_taxformula.[lbr_formula_id] lbr_formula.[lbr_formula_id]
lbr_taxformula.[lbr_taxname_id] lbr_taxname.[lbr_taxname_id]
lbr_taxline.[cof_modbc_id] cof_modbc.[cof_modbc_id]
lbr_taxline.[lbr_taxname_id] lbr_taxname.[lbr_taxname_id]
lbr_taxline.[lbr_taxstatus_id] lbr_taxstatus.[lbr_taxstatus_id]
lbr_taxstatus.[lbr_taxname_id] lbr_taxname.[lbr_taxname_id]
m_locator.[c_bpartner_id] c_bpartner.[c_bpartner_id]
m_movement.[m_inout_id] m_inout.[m_inout_id]
m_movementline.[lbr_tax_id] lbr_tax.[lbr_tax_id]
m_product.[lbr_fiscalgroup_product_id] lbr_fiscalgroup_product.[lbr_fiscalgroup_product_id]
m_product.[lbr_ncm_id] lbr_ncm.[lbr_ncm_id]
m_product.[lbr_productcategory_id] lbr_productcategory.[lbr_productcategory_id]
m_product.[m_attributesetinstance_id] m_attributesetinstance.[m_attributesetinstance_id]
m_product_category.[m_attributeset_id] m_attributeset.[m_attributeset_id]
m_rmaline.[lbr_tax_id] lbr_tax.[lbr_tax_id]
t_1099extract.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_1099extract.[c_bpartner_id] c_bpartner.[c_bpartner_id]
t_1099extract.[c_location_id] c_location.[c_location_id]
t_aging.[c_doctype_id] c_doctype.[c_doctype_id]
t_bankregister.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_bankregister.[c_bank_id] c_bank.[c_bank_id]
t_bankregister.[c_bpartner_id] c_bpartner.[c_bpartner_id]
t_bom_indented.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_bom_indented.[m_costelement_id] m_costelement.[m_costelement_id]
t_bom_indented.[m_product_id] m_product.[m_product_id]
t_bomline.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_bomline.[m_costelement_id] m_costelement.[m_costelement_id]
t_bomline.[m_costtype_id] m_costtype.[m_costtype_id]
t_bomline.[m_product_id] m_product.[m_product_id]
t_bomline.[pp_product_bom_id] pp_product_bom.[pp_product_bom_id]
t_bomline.[pp_product_bomline_id] pp_product_bomline.[pp_product_bomline_id]
t_cashflow.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_cashflow.[c_activity_id] c_activity.[c_activity_id]
t_cashflow.[c_bpartner_id] c_bpartner.[c_bpartner_id]
t_cashflow.[c_campaign_id] c_campaign.[c_campaign_id]
t_cashflow.[c_cashplanline_id] c_cashplanline.[c_cashplanline_id]
t_cashflow.[c_charge_id] c_charge.[c_charge_id]
t_cashflow.[c_elementvalue_id] c_elementvalue.[c_elementvalue_id]
t_cashflow.[c_invoice_id] c_invoice.[c_invoice_id]
t_cashflow.[c_order_id] c_order.[c_order_id]
t_cashflow.[c_project_id] c_project.[c_project_id]
t_cashflow.[m_product_id] m_product.[m_product_id]
t_moveclient.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_mrp_crp.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_reconciliation.[ad_pinstance_id] ad_pinstance.[ad_pinstance_id]
t_reconciliation.[fact_acct_id] fact_acct.[fact_acct_id]
t_replenish.[c_bpartner_id] c_bpartner.[c_bpartner_id]
t_transaction.[c_project_id] c_project.[c_project_id]
t_transaction.[m_inout_id] m_inout.[m_inout_id]
t_transaction.[m_inventory_id] m_inventory.[m_inventory_id]
t_transaction.[m_movement_id] m_movement.[m_movement_id]
t_transaction.[m_production_id] m_production.[m_production_id]
t_trialbalance.[a_asset_id] a_asset.[a_asset_id]
t_trialbalance.[ad_table_id] ad_table.[ad_table_id]
t_trialbalance.[c_activity_id] c_activity.[c_activity_id]
t_trialbalance.[c_bpartner_id] c_bpartner.[c_bpartner_id]
t_trialbalance.[c_campaign_id] c_campaign.[c_campaign_id]
t_trialbalance.[c_currency_id] c_currency.[c_currency_id]
t_trialbalance.[c_period_id] c_period.[c_period_id]
t_trialbalance.[c_project_id] c_project.[c_project_id]
t_trialbalance.[c_salesregion_id] c_salesregion.[c_salesregion_id]
t_trialbalance.[c_tax_id] c_tax.[c_tax_id]
t_trialbalance.[c_uom_id] c_uom.[c_uom_id]
t_trialbalance.[gl_budget_id] gl_budget.[gl_budget_id]
t_trialbalance.[gl_category_id] gl_category.[gl_category_id]
t_trialbalance.[m_locator_id] m_locator.[m_locator_id]
t_trialbalance.[m_product_id] m_product.[m_product_id]
test.[c_bpartner_id] c_bpartner.[c_bpartner_id]
test.[c_currency_id] c_currency.[c_currency_id]
test.[c_location_id] c_location.[c_location_id]
test.[c_payment_id] c_payment.[c_payment_id]
test.[c_uom_id] c_uom.[c_uom_id]
test.[cof_r_survey_id] cof_r_survey.[cof_r_survey_id]
test.[lbr_tax_id] lbr_tax.[lbr_tax_id]
test.[m_locator_id] m_locator.[m_locator_id]
test.[m_product_id] m_product.[m_product_id]

Tables without indexes

Tables that contain a single column

Table Column
dbreplicasyncverifier lastupdate
dual dummy

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected