c_validcombination

784 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_validcombination_id numeric 10 null
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.cof_p_estoqueemterceiro_acct cofpestoqueemterceiroacct_cacc R
c_acctschema_default.cof_p_estoqueterceiro_acct cofpestoqueterceiroacct_caccts R
c_acctschema_default.cof_p_inventoryclearing_acct cofpinventoryclearingacct_cacc R
c_acctschema_default.cof_t_deson_acct coftdesonacct_cacctschemadefau 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.t_withhold_acct twithholdacct_cacctschemadefau 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_invoice.c_elementvalue_id celementvalue_cinvoice 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.cof_t_deson_acct coftdesonacct_ctaxacct 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_tax_acct.t_withhold_acct twithholdacct_ctaxacct R
c_withholding_acct.withholding_acct vc_withholding_cwithholding R
cof_c_sped_contribuicoes.c_elementvalue_id celementvalue_cofcspedcontribu R
gl_journalline.alias_validcombination_id aliasvalidcombination_gljourna R
gl_journalline.c_validcombination_id cvc_gljournalline R
gl_journalline_acct_v.c_validcombination_id Implied Constraint 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.cof_p_estoqueemterceiro_acct cofpestoqueemterceiroacct_mproductacct R
m_product_acct.cof_p_estoqueterceiro_acct cofpestoqueterceiroacct_mproductacct R
m_product_acct.cof_p_inventoryclearing_acct cofpinventoryclearingacct_mproductacct R
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.cof_p_estoqueemterceiro_acct cofpestoqueemterceiroacct_mproductcategoryacct R
m_product_category_acct.cof_p_estoqueterceiro_acct cofpestoqueterceiroacct_mproductcategoryacct R
m_product_category_acct.cof_p_inventoryclearing_acct cofpinventoryclearingacct_mproductcategoryacct 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
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_vc R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_vc R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
alias varchar 40 √ null
combination varchar 60 √ null
description varchar 255 √ null
isfullyqualified bpchar 1 'Y'::bpchar
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_cvalidcombination C
account_id numeric 10 null
c_elementvalue.c_elementvalue_id celementvalueaccount_vc C
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_vc R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_vc R
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_vc R
c_locfrom_id numeric 10 √ null
c_location.c_location_id mlocationfrom_vc R
c_locto_id numeric 10 √ null
c_location.c_location_id mlocationto_vc R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_vc R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_vc R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id socampaign_vc R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cvalidcombination R
user1_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser1_vc R
user2_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalueuser2_vc R
c_subacct_id numeric 10 √ null
c_subacct.c_subacct_id csubacct_cvalidcombination R
userelement1_id numeric 10 √ null
userelement2_id numeric 10 √ null
c_validcombination_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_validcombination_pkey Primary key Asc c_validcombination_id
c_validcombination_alias Performance Asc/Asc ad_client_id + alias
c_validcombination_alt Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc 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
c_validcombination_uu_idx Must be unique Asc c_validcombination_uu

Check Constraints

Constraint Name Constraint
c_validcombination_isfullyqualified_check ((isfullyqualified = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_validcombination_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation