Table idempiere9.adempiere.c_validcombination
Valid Account Combination

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_validcombination_id numeric 10
a_asset_acct.a_accumdepreciation_acct aaccumdepreciation_aassetacct R
a_asset_acct.a_asset_acct aassetvc_aassetacct R
a_asset_acct.a_depreciation_acct adepreciationvc_aassetacct R
a_asset_acct.a_disposal_gain_acct adisposalgain_aassetacct R
a_asset_acct.a_disposal_loss_acct adisposalloss_aassetacct R
a_asset_acct.a_disposal_revenue_acct adisposalrevenue_aassetacct R
a_asset_acct.a_reval_adep_offset_cur_acct arevaladepoffsetcur_aassetacct R
a_asset_acct.a_reval_adep_offset_prior_acct arevaladepoffsetprior_aassetac R
a_asset_acct.a_reval_cost_offset_acct arevalcostoffset_aassetacct R
a_asset_acct.a_reval_cost_offset_prior_acct arevalcostoffsetprior_aassetac R
a_asset_acct.a_reval_depexp_offset_acct arevaldepexpoffset_aassetacct R
a_asset_change.a_accumdepreciation_acct aaccumdepreciation_aassetchang R
a_asset_change.a_asset_acct aassetvc_aassetchange R
a_asset_change.a_depreciation_acct adepreciation_aassetchange R
a_asset_change.a_disposal_loss_acct adisposalloss_aassetchange R
a_asset_change.a_disposal_revenue_acct adisposalrevenue_aassetchange R
a_asset_change.c_validcombination_id cvalidcombinati_aassetchange R
a_asset_group_acct.a_accumdepreciation_acct aaccumdepreciation_aassetgroup R
a_asset_group_acct.a_asset_acct aasset_aassetgroupacct R
a_asset_group_acct.a_depreciation_acct adepreciationvc_aassetgroupacc R
a_asset_group_acct.a_disposal_gain_acct adisposalgain_aassetgroupacct R
a_asset_group_acct.a_disposal_loss_acct adisposalloss_aassetgroupacct R
a_asset_group_acct.a_disposal_revenue_acct adisposalrevenue_aassetgroupac R
a_asset_group_acct.a_reval_adep_offset_cur_acct arevaladepoffsetcur_aassetgrou R
a_asset_group_acct.a_reval_adep_offset_prior_acct arevaladepoffsetprior_aassetgr R
a_asset_group_acct.a_reval_cost_offset_acct arevalcostoffset_aassetgroupac R
a_asset_group_acct.a_reval_cost_offset_prior_acct arevalcostoffsetprior_aassetgr R
a_asset_group_acct.a_reval_depexp_offset_acct arevaldepexpoffset_aassetgroup R
a_asset_transfer.a_accumdepreciation_acct aaccumdepreciation_aassettrans R
a_asset_transfer.a_accumdepreciation_new_acct aaccumdepreciationnew_aassettr R
a_asset_transfer.a_asset_acct aassetvc_aassettransfer R
a_asset_transfer.a_asset_new_acct aassetnew_aassettransfer R
a_asset_transfer.a_depreciation_acct adepreciation_aassettransfer R
a_asset_transfer.a_depreciation_new_acct adepreciationnew_aassettransfe R
a_asset_transfer.a_disposal_loss_acct adisposalloss_aassettransfer R
a_asset_transfer.a_disposal_loss_new_acct adisposallossnew_aassettransfe R
a_asset_transfer.a_disposal_revenue_acct adisposalrevenue_aassettransfe R
a_asset_transfer.a_disposal_revenue_new_acct adisposalrevenuenew_aassettran R
a_depreciation_exp.a_account_number_acct aaccountnumber_adepreciationex R
a_depreciation_exp.cr_account_id craccou_adepreciationexp R
a_depreciation_exp.dr_account_id draccou_adepreciationexp R
a_fundingmode_acct.a_fundingmode_acct afundingmodevc_afundingmodeacc R
c_acctschema_default.b_asset_acct vc_basset_cschemadefault R
c_acctschema_default.b_expense_acct vc_bexpense_cschemadefault R
c_acctschema_default.b_interestexp_acct vc_binterestexp_cschemadefault R
c_acctschema_default.b_interestrev_acct vc_binterestrev_cschemadefault R
c_acctschema_default.b_intransit_acct vc_bintransit_cschemadefault R
c_acctschema_default.b_paymentselect_acct vc_bpaymentselect_cschemadefau R
c_acctschema_default.b_revaluationgain_acct vc_brevaluationgain_cschemadef R
c_acctschema_default.b_revaluationloss_acct vc_brevaluationloss_cschemadef R
c_acctschema_default.b_settlementgain_acct vc_bsettlementgain_cschemadefa R
c_acctschema_default.b_settlementloss_acct vc_bsettlementloss_cschemadefa R
c_acctschema_default.b_unallocatedcash_acct vc_bunallocatedcash_cschemadef R
c_acctschema_default.b_unidentified_acct vc_bunidentified_cschemadefaul R
c_acctschema_default.c_prepayment_acct vc_cprepayment_cschemadefault R
c_acctschema_default.c_receivable_acct vc_creceivable_cschemadefault R
c_acctschema_default.c_receivable_services_acct creceivableservices_cacctschem R
c_acctschema_default.cb_asset_acct vc_cbasset_cschemadefault R
c_acctschema_default.cb_cashtransfer_acct vc_cbcashtransfer_cschemadefau R
c_acctschema_default.cb_differences_acct vc_cbdifferences_cschemadefaul R
c_acctschema_default.cb_expense_acct vc_cbexpense_cschemadefault R
c_acctschema_default.cb_receipt_acct vc_cbreceipt_cschemadefault R
c_acctschema_default.ch_expense_acct vc_chexpense_cschemadefault R
c_acctschema_default.ch_revenue_acct chrevenue_cacctschemadefault R
c_acctschema_default.e_expense_acct vc_eexpense_cschemadefault R
c_acctschema_default.e_prepayment_acct vc_eprepayment_cschemadefault R
c_acctschema_default.notinvoicedreceipts_acct vc_notinvoicedreceipts_cschema R
c_acctschema_default.notinvoicedreceivables_acct vc_notinvoicedrec_cschemadefau R
c_acctschema_default.notinvoicedrevenue_acct vc_notinvoicedrevenue_cschemad R
c_acctschema_default.p_asset_acct vc_passet_cschemadefault R
c_acctschema_default.p_averagecostvariance_acct paveragecostvariance_cacctsche R
c_acctschema_default.p_burden_acct pburden_cacctschemadefault R
c_acctschema_default.p_cogs_acct vc_pcogs_cschemadefault R
c_acctschema_default.p_costadjustment_acct pcostadjustment_cacctschemadef R
c_acctschema_default.p_costofproduction_acct pcostofproduction_cacctschemad R
c_acctschema_default.p_expense_acct vc_pexpense_cschemadefault R
c_acctschema_default.p_floorstock_acct pfloorstock_cacctschemadefault R
c_acctschema_default.p_inventoryclearing_acct pinventoryclearing_cacctschema R
c_acctschema_default.p_invoicepricevariance_acct vc_pinvoicepv_cschemadefault R
c_acctschema_default.p_labor_acct plabor_cacctschemadefault R
c_acctschema_default.p_landedcostclearing_acct plandedcostclearingvc_cacctsch R
c_acctschema_default.p_methodchangevariance_acct pmethodchangevariance_cacctsch R
c_acctschema_default.p_mixvariance_acct pmixvariance_cacctschemadefaul R
c_acctschema_default.p_outsideprocessing_acct poutsideprocessing_cacctschema R
c_acctschema_default.p_overhead_acct poverhead_cacctschemadefault R
c_acctschema_default.p_purchasepricevariance_acct vc_ppurchasepv_cschemadefault R
c_acctschema_default.p_ratevariance_acct pratevariance_cacctschemadefau R
c_acctschema_default.p_revenue_acct vc_prevenue_cschemadefault R
c_acctschema_default.p_scrap_acct pscrap_cacctschemadefault R
c_acctschema_default.p_tradediscountgrant_acct vc_ptdiscountgrant_cschemadefa R
c_acctschema_default.p_tradediscountrec_acct vc_ptdiscountrec_cschemadefaul R
c_acctschema_default.p_usagevariance_acct pusagevariance_cacctschemadefa R
c_acctschema_default.p_wip_acct pwip_cacctschemadefault R
c_acctschema_default.paydiscount_exp_acct vc_paydiscountexp_cschemadefau R
c_acctschema_default.paydiscount_rev_acct vc_paydiscountrev_cschemadefau R
c_acctschema_default.pj_asset_acct vc_pjasset_cschemadefault R
c_acctschema_default.pj_wip_acct vc_pjwip_cschemadefault R
c_acctschema_default.realizedgain_acct vc_realizedgain_cschemadefault R
c_acctschema_default.realizedloss_acct vc_realizedloss_cschemadefault R
c_acctschema_default.t_credit_acct vc_tcredit_cschemadefault R
c_acctschema_default.t_due_acct vc_tdue_cschemadefault R
c_acctschema_default.t_expense_acct vc_texpense_cschemadefault R
c_acctschema_default.t_liability_acct vc_tliability_cschemadefault R
c_acctschema_default.t_receivables_acct vc_trec_cschemadefault R
c_acctschema_default.unearnedrevenue_acct vc_unearnedrevenue_cschemadefa R
c_acctschema_default.unrealizedgain_acct vc_unrealizedgain_cschemadefau R
c_acctschema_default.unrealizedloss_acct vc_unrealizedloss_cschemadefau R
c_acctschema_default.v_liability_acct vc_vliability_cschemadefault R
c_acctschema_default.v_liability_services_acct vc_vliabilityservices_cschemad R
c_acctschema_default.v_prepayment_acct vc_vprepayment_cschemadefault R
c_acctschema_default.w_differences_acct vc_wdifferences_cschemadefault R
c_acctschema_default.w_invactualadjust_acct vc_winvactualadjust_cschemadef R
c_acctschema_default.w_inventory_acct vc_winventory_cschemadefault R
c_acctschema_default.w_revaluation_acct vc_wrevaluation_cschemadefault R
c_acctschema_default.withholding_acct vc_withholding_cschemadefault R
c_acctschema_default.writeoff_acct vc_writeoff_cschemadefault R
c_acctschema_gl.commitmentoffset_acct commitmentoffset_cacctschemagl R
c_acctschema_gl.commitmentoffsetsales_acct commitmentoffsetsales_cacctsch R
c_acctschema_gl.currencybalancing_acct vc_currencybalancing_cschemagl R
c_acctschema_gl.incomesummary_acct vc_incomesummary_cschemagl R
c_acctschema_gl.intercompanyduefrom_acct vc_intercompanyduefrom_cschema R
c_acctschema_gl.intercompanydueto_acct vc_intercompanydueto_cschemagl R
c_acctschema_gl.ppvoffset_acct vc_ppvoffset_cschemagl R
c_acctschema_gl.retainedearning_acct vc_retainedearning_cschemagl R
c_acctschema_gl.suspensebalancing_acct vc_suspensebalancing_cschemagl R
c_acctschema_gl.suspenseerror_acct vc_suspenseerror_cschemagl R
c_bankaccount_acct.b_asset_acct vc_basset_cbankaccount R
c_bankaccount_acct.b_expense_acct vc_bexpense_cbankaccount R
c_bankaccount_acct.b_interestexp_acct vc_binterestexp_cbankaccount R
c_bankaccount_acct.b_interestrev_acct vc_binterestrev_cbankaccount R
c_bankaccount_acct.b_intransit_acct vc_bintransit_cbankaccount R
c_bankaccount_acct.b_paymentselect_acct vc_bpaymentselect_cbankaccount R
c_bankaccount_acct.b_revaluationgain_acct vc_brevaluationgain_cbankaccou R
c_bankaccount_acct.b_revaluationloss_acct vc_brevaluationloss_cbankaccou R
c_bankaccount_acct.b_settlementgain_acct vc_bsettlementgain_cbankaccoun R
c_bankaccount_acct.b_settlementloss_acct vc_bsettlementloss_cbankaccoun R
c_bankaccount_acct.b_unallocatedcash_acct vc_bunallocatedcash_cbankaccou R
c_bankaccount_acct.b_unidentified_acct vc_bunidentified_cbankaccount R
c_bp_customer_acct.c_prepayment_acct vc_cprepayment_cbpcustomer R
c_bp_customer_acct.c_receivable_acct vc_creceivable_cbpcustomer R
c_bp_customer_acct.c_receivable_services_acct creceivableservices_cbpcustome R
c_bp_employee_acct.e_expense_acct vc_eexpense_cbpemployee R
c_bp_employee_acct.e_prepayment_acct vc_eprepayment_cbpemployee R
c_bp_group_acct.c_prepayment_acct vc_cprepayment_cbpgroup R
c_bp_group_acct.c_receivable_acct vc_creceivable_cbpgroup R
c_bp_group_acct.c_receivable_services_acct creceivableservices_cbpgroupac R
c_bp_group_acct.notinvoicedreceipts_acct vc_notinvoicedreceipts_cbpgrou R
c_bp_group_acct.notinvoicedreceivables_acct vc_notinvoicedrec_cbpgroup R
c_bp_group_acct.notinvoicedrevenue_acct vc_notinvoicedrevenue_cbpgroup R
c_bp_group_acct.paydiscount_exp_acct vc_paydiscountexp_cbpgroup R
c_bp_group_acct.paydiscount_rev_acct vc_paydiscountrev_cbpgroup R
c_bp_group_acct.unearnedrevenue_acct vc_unearnedrevenue_cbpgroup R
c_bp_group_acct.v_liability_acct vc_vliability_cbpgroup R
c_bp_group_acct.v_liability_services_acct vc_vliabilityservices_cbpgroup R
c_bp_group_acct.v_prepayment_acct vc_vprepayment_cbpgroup R
c_bp_group_acct.writeoff_acct vc_writeoff_cbpgroup R
c_bp_vendor_acct.v_liability_acct vc_vliability_cbpvendor R
c_bp_vendor_acct.v_liability_services_acct vc_vliabilityservices_cbpvendo R
c_bp_vendor_acct.v_prepayment_acct vc_vprepayment_cbpvendor R
c_cashbook_acct.cb_asset_acct vc_cbasset_ccashbook R
c_cashbook_acct.cb_cashtransfer_acct vc_cbcashtransfer_ccashbook R
c_cashbook_acct.cb_differences_acct vc_cbdifferences_ccashbook R
c_cashbook_acct.cb_expense_acct vc_cbexpense_ccashbook R
c_cashbook_acct.cb_receipt_acct vc_cbreceipt_ccashbook R
c_charge_acct.ch_expense_acct vc_chexpense_ccharge R
c_charge_acct.ch_revenue_acct chrevenue_cchargeacct R
c_currency_acct.realizedgain_acct vc_realizedgain_ccurrency R
c_currency_acct.realizedloss_acct vc_realizedloss_ccurrency R
c_currency_acct.unrealizedgain_acct vc_unrealizedgain_ccurrency R
c_currency_acct.unrealizedloss_acct vc_unrealizedloss_ccurrency R
c_interorg_acct.intercompanyduefrom_acct vc_intercompanyduefrom_cintero R
c_interorg_acct.intercompanydueto_acct vc_intercompanydueto_cinterorg R
c_project_acct.pj_asset_acct vc_pjasset_cproject R
c_project_acct.pj_wip_acct vc_pjwip_cproject R
c_revenuerecognition_plan.p_revenue_acct vc_prevenue_crevenuerecognitio R
c_revenuerecognition_plan.unearnedrevenue_acct vc_unearnedrevenue_crevenuerec R
c_tax_acct.t_credit_acct vc_tcredit_ctax R
c_tax_acct.t_due_acct vc_tdue_ctax R
c_tax_acct.t_expense_acct vc_texpense_ctax R
c_tax_acct.t_liability_acct vc_tliability_ctax R
c_tax_acct.t_receivables_acct vc_trec_ctax R
c_withholding_acct.withholding_acct vc_withholding_cwithholding R
gl_journalline.alias_validcombination_id aliasvalidcombination_gljourna R
gl_journalline.c_validcombination_id cvc_gljournalline R
hr_attribute.hr_attribute_acct hrattribute_hrattribute R
hr_concept_acct.hr_expense_acct hrexpense_hrconceptacct R
hr_concept_acct.hr_revenue_acct hrrevenue_hrconceptacct R
hr_concept_acct.user2_id use_hrconceptacct R
hr_concept_category.hr_concept_acct hrconcept_hrconceptcategory R
i_asset.a_accumdepreciation_acct aaccumdepreciation_iasset R
i_asset.a_asset_acct aasset_iasset R
i_asset.a_depreciation_acct adepreciation_iasset R
i_fajournal.c_validcombination_id cvalidcombination_ifajournal R
i_gljournal.c_validcombination_id cvalidcombination_igljournal N
m_product_acct.p_asset_acct vc_passet_mproduct R
m_product_acct.p_averagecostvariance_acct paveragecostvariance_mproducta R
m_product_acct.p_burden_acct pburden_mproductacct R
m_product_acct.p_cogs_acct vc_pcogs_mproduct R
m_product_acct.p_costadjustment_acct pcostadjustment_mproductacct R
m_product_acct.p_costofproduction_acct pcostofproduction_mproductacct R
m_product_acct.p_expense_acct vc_pexpense_mproduct R
m_product_acct.p_floorstock_acct pfloorstock_mproductacct R
m_product_acct.p_inventoryclearing_acct pinventoryclearing_mproductacc R
m_product_acct.p_invoicepricevariance_acct vc_pinvoicepv_mproduct R
m_product_acct.p_labor_acct plabor_mproductacct R
m_product_acct.p_landedcostclearing_acct plandedcostclearingvc_mprodacc R
m_product_acct.p_methodchangevariance_acct pmethodchangevariance_mproduct R
m_product_acct.p_mixvariance_acct pmixvariance_mproductacct R
m_product_acct.p_outsideprocessing_acct poutsideprocessing_mproductacc R
m_product_acct.p_overhead_acct poverhead_mproductacct R
m_product_acct.p_purchasepricevariance_acct vc_ppurchasepv_mproduct R
m_product_acct.p_ratevariance_acct pratevariance_mproductacct R
m_product_acct.p_revenue_acct vc_prevenue_mproduct R
m_product_acct.p_scrap_acct pscrap_mproductacct R
m_product_acct.p_tradediscountgrant_acct vc_ptdiscountgrant_mproduct R
m_product_acct.p_tradediscountrec_acct vc_ptdiscountrec_mproduct R
m_product_acct.p_usagevariance_acct pusagevariance_mproductacct R
m_product_acct.p_wip_acct pwip_mproductacct R
m_product_category_acct.p_asset_acct vc_passet_mproductcategory R
m_product_category_acct.p_averagecostvariance_acct paveragecostvariance_mproductc R
m_product_category_acct.p_burden_acct pburden_mproductcategoryacct R
m_product_category_acct.p_cogs_acct vc_pcogs_mproductcategory R
m_product_category_acct.p_costadjustment_acct pcostadjustment_mproductcatego R
m_product_category_acct.p_costofproduction_acct pcostofproduction_mproductcate R
m_product_category_acct.p_expense_acct vc_pexpense_mproductcategory R
m_product_category_acct.p_floorstock_acct pfloorstock_mproductcategoryac R
m_product_category_acct.p_inventoryclearing_acct pinventoryclearing_mproductcat R
m_product_category_acct.p_invoicepricevariance_acct vc_pinvoicepv_mproductcategory R
m_product_category_acct.p_labor_acct plabor_mproductcategoryacct R
m_product_category_acct.p_landedcostclearing_acct plandedcostclearingvc_mprcatac R
m_product_category_acct.p_methodchangevariance_acct pmethodchangevariance_mprodcat R
m_product_category_acct.p_mixvariance_acct pmixvariance_mproductcategorya R
m_product_category_acct.p_outsideprocessing_acct poutsideprocessing_mproductcat R
m_product_category_acct.p_overhead_acct poverhead_mproductcategoryacct R
m_product_category_acct.p_purchasepricevariance_acct vc_ppurchasepv_mproductcategor R
m_product_category_acct.p_ratevariance_acct pratevariance_mproductcategory R
m_product_category_acct.p_revenue_acct vc_prevenue_mproductcategory R
m_product_category_acct.p_scrap_acct pscrap_mproductcategoryacct R
m_product_category_acct.p_tradediscountgrant_acct vc_ptdiscountgrant_mproductcat R
m_product_category_acct.p_tradediscountrec_acct vc_ptdiscountrec_mproductcateg R
m_product_category_acct.p_usagevariance_acct pusagevariance_mproductcategor R
m_product_category_acct.p_wip_acct pwip_mproductcategoryacct R
m_warehouse_acct.w_differences_acct vc_wdifferences_mwarehouse R
m_warehouse_acct.w_invactualadjust_acct vc_winvactualadjust_mwarehouse R
m_warehouse_acct.w_inventory_acct vc_winventory_mwarehouse R
m_warehouse_acct.w_revaluation_acct vc_wrevaluation_mwarehouse R
test.account_acct vc_account_test R
Valid Account Combination
ad_client_id numeric 10
ad_client.ad_client_id adclient_vc R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_vc R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
alias varchar 40  √  null Defines an alternate method of indicating an account combination.
combination varchar 60  √  null Unique combination of account elements
description varchar 255  √  null Optional short description of the record
isfullyqualified bpchar 1 'Y'::bpchar This account is fully qualified
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_cvalidcombination C
Rules for accounting
account_id numeric 10
c_elementvalue.c_elementvalue_id celementvalueaccount_vc C
Account used
m_product_id numeric 10  √  null
m_product.m_product_id mproduct_vc R
Product, Service, Item
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_vc R
Identifies a Business Partner
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_vc R
Performing or initiating organization
c_locfrom_id numeric 10  √  null
c_location.c_location_id mlocationfrom_vc R
Location that inventory was moved from
c_locto_id numeric 10  √  null
c_location.c_location_id mlocationto_vc R
Location that inventory was moved to
c_salesregion_id numeric 10  √  null
c_salesregion.c_salesregion_id csalesregion_vc R
Sales coverage region
c_project_id numeric 10  √  null
c_project.c_project_id cproject_vc R
Financial Project
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id socampaign_vc R
Marketing Campaign
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_cvalidcombination R
Business Activity
user1_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celementvalueuser1_vc R
User defined list element #1
user2_id numeric 10  √  null
c_elementvalue.c_elementvalue_id celementvalueuser2_vc R
User defined list element #2
c_subacct_id numeric 10  √  null
c_subacct.c_subacct_id csubacct_cvalidcombination R
Sub account for Element Value
userelement1_id numeric 10  √  null User defined accounting Element
userelement2_id numeric 10  √  null User defined accounting Element
c_validcombination_uu varchar 36  √  NULL::character varying C_ValidCombination_UU

Table contained 154 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_validcombination_id Primary key Asc c_validcombination_pkey
ad_client_id + alias Performance Asc/Asc c_validcombination_alias
c_acctschema_id + ad_org_id + account_id + c_subacct_id + m_product_id + c_bpartner_id + ad_orgtrx_id + c_locfrom_id + c_locto_id + c_salesregion_id + c_project_id + c_campaign_id + c_activity_id + user1_id + user2_id + userelement1_id + userelement2_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc c_validcombination_alt
c_validcombination_uu Must be unique Asc c_validcombination_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.