c_elementvalue

1835 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_elementvalue_id numeric 10 null
c_acctschema_element.c_elementvalue_id celementvalue_caschemaelement R
c_allocationline.cof_elementvalue_id cofelementvalue_callocationlin R
c_bankaccount.cof_user2_id cofuser2_cbankaccount R
c_bankaccount.user2_id user2_cbankaccount R
c_cash.user1_id celementvalueuser1_ccash R
c_cash.user2_id celementvalueuser2_ccash R
c_cashplan.user1_id user1_ccashplan R
c_cashplan.user2_id user2_ccashplan R
c_cashplanline.user1_id user1_ccashplanline R
c_cashplanline.user2_id user2_ccashplanline R
c_doctype.user1_id user1_cdoctype R
c_doctype.user2_id user2_cdoctype R
c_elementvalue.cof_codagl_id cofcodagl_celementvalue R
c_elementvalue_trl.c_elementvalue_id celementvalue_cevaluetrl C
c_invoice.user1_id celementvalueuser1_cinvoice R
c_invoice.user2_id celementvalueuser2_cinvoice R
c_invoicebatchline.user1_id celementvalueu1_cinvoicebline R
c_invoicebatchline.user2_id celementvalueu2_cinvoicebline R
c_invoiceline.user1_id celemenrvalueuser1_cinvline R
c_invoiceline.user2_id celemenrvalueuser2_cinvline R
c_order.user1_id celementvalueuser1_corder R
c_order.user2_id celemenrvalueuser2_corder R
c_orderline.user1_id celemenrvalueuser1_corderline R
c_orderline.user2_id celemenrvalueuser2_corderline R
c_payment.user1_id celementvalueuser1_cpayment R
c_payment.user2_id celementvalueuser2_cpayment R
c_paymenttransaction.user1_id user1_cpaymenttransaction R
c_paymenttransaction.user2_id user2_cpaymenttransaction R
c_subacct.c_elementvalue_id celementvalue_csubacct C
c_validcombination.account_id celementvalueaccount_vc C
c_validcombination.user1_id celementvalueuser1_vc R
c_validcombination.user2_id celementvalueuser2_vc R
cof_c_acct_ignoreelement.c_elementvalue_id celementvalue_cofcacctignoreel R
cof_c_controlcheck.user1_id user1_cofccontrolcheck R
cof_c_controlcheck.user2_id user2_cofccontrolcheck R
cof_c_sped_fiscal.cof_excludeuser2_id cofexcludeuser2_cofcspedfiscal R
cof_c_sped_fiscal.user2_id user2_cofcspedfiscal R
cof_configexportcontabcontas.c_elementvalue_id celementvalue_cofconfigexportcontabcontas N
cof_configexportcontabcustos.c_elementvalue_id celementvalue_cofconfigexportcontabcustos N
cof_configexportcontabexcecoes.c_elementvalue_id celementvalue_cofconfigexportcontabexcecoes N
cof_configrateiolinha.user1_id user1_cofconfigrateiolinha R
cof_configrateiolinha.user2_id user2_cofconfigrateiolinha R
cof_contract.user1_id user1_cofcontract R
cof_contract.user2_id user2_cofcontract R
cof_elementvaluereference.c_elementvalue_id celementvalue_cofelementvaluer R
cof_orcamentoconfig.account_id account_coforcamentoconfig R
cof_orcamentoconfig.user1_id user1_coforcamentoconfig R
cof_orcamentoconfig.user2_id user2_coforcamentoconfig R
cof_ordemservico.user1_id user1_cofordemservico R
cof_ordemservico.user2_id user2_cofordemservico R
cof_pp_planomestreprod.user1_id user1_cofppplanomestreprod R
cof_pp_recursos.user1_id user1_cofpprecursos R
cof_preferenciaxml.user1_id user1_cofpreferenciaxml R
cof_preferenciaxml.user2_id user2_cofpreferenciaxml R
dd_order.user1_id user1_ddorder R
dd_order.user2_id user2_ddorder R
dd_orderline.user1_id user1_ddorderline R
dd_orderline.user2_id user2_ddorderline R
fact_acct.account_id celementvalue_factacct R
fact_acct.user1_id celementvalueuser1_factacct R
fact_acct.user2_id celementvalueuser2_factacct R
fact_acct_summary.account_id account_factacctsummary R
fact_acct_summary.user1_id user1_factacctsummary R
fact_acct_summary.user2_id user2_factacctsummary R
gl_distribution.account_id cevalueacct_gldist R
gl_distribution.user1_id cevalueuser1_gldist R
gl_distribution.user2_id cevalueuser2_gldist R
gl_distributionline.account_id cevalueacct_gldistline R
gl_distributionline.user1_id cevalueuser1_gldistline R
gl_distributionline.user2_id cevalueuser2_gldistline R
gl_fundrestriction.c_elementvalue_id celementvalue_glfundrestr R
gl_journalgenerator.c_elementvalueadjustcr_id celementvalueadjustcr_qssjourn R
gl_journalgenerator.c_elementvalueadjustdr_id celementvalueadjustdr_qssjourn R
gl_journalgeneratorline.c_elementvaluecr_id celementvaluecr_qssjournalgene R
gl_journalgeneratorline.c_elementvaluedr_id celementvaluedr_qssjournalgene R
gl_journalgeneratorsource.c_elementvalue_id celementvalue_qssjournalgenera R
gl_journalline.account_id account_gljournalline R
gl_journalline.user1_id user1_gljournalline R
gl_journalline.user2_id user2_gljournalline R
hr_concept_acct.user1_id user1_hrconceptacct R
hr_movement.user1_id user1_hrmovement R
hr_movement.user2_id user2_hrmovement R
i_elementvalue.c_elementvalue_id celementvalue_ielementvalue N
i_elementvalue.parentelementvalue_id cevalueparent_ielementvalue N
i_fajournal.account_id account_ifajournal R
i_fajournal.user1_id user1_ifajournal R
i_fajournal.user2_id user2_ifajournal R
i_gljournal.account_id celvalueaccount_igljournal N
i_gljournal.user1_id cevalueuser1_igljournal N
i_gljournal.user2_id celvalueuser2_igljournal N
i_reportline.c_elementvalue_id celementvalue_ireportline N
m_inout.user1_id celementvalueuser1_minout R
m_inout.user2_id celementvalueuser2_minout R
m_inoutline.user1_id celemenrvalueuser1_minoutline R
m_inoutline.user2_id celemenrvalueuser2_minoutline R
m_inventory.user1_id celementvalueuser1_minvent R
m_inventory.user2_id celementvalueuser2_minvent R
m_movement.user1_id celementvalueuser1_mmove R
m_movement.user2_id celementvalueuser2_mmove R
m_production.user1_id celementvalueuser1_mprod R
m_production.user2_id celementvalueuser2_mprod R
m_productionline.user1_id user1_mproductionline R
m_productionline.user2_id user2_mproductionline R
pa_ratioelement.account_id celementvalue_paratioelement R
pa_reportcolumn.c_elementvalue_id celementvalue_pareportcolumn R
pa_reportsource.c_elementvalue_id celementvalue_pareportsource R
pp_order.user1_id user1_pporder R
pp_order.user2_id user2_pporder R
rv_fact_acct.c_elementvalue_id Implied Constraint R
t_cashflow.c_elementvalue_id Implied Constraint R
t_rv_reconciliation.c_elementvalue_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_celementvalue R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_celementvalue R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 120 null
description varchar 255 √ null
accounttype bpchar 1 null
accountsign bpchar 1 null
isdoccontrolled bpchar 1 √ 'N'::bpchar
c_element_id numeric 10 null
c_element.c_element_id celement_celementvalue C
issummary bpchar 1 'N'::bpchar
validfrom timestamp 29,6 √ null
validto timestamp 29,6 √ null
postactual bpchar 1 'Y'::bpchar
postbudget bpchar 1 'Y'::bpchar
postencumbrance bpchar 1 'Y'::bpchar
poststatistical bpchar 1 'Y'::bpchar
isbankaccount bpchar 1 √ 'N'::bpchar
c_bankaccount_id numeric 10 √ null
c_bankaccount.c_bankaccount_id cbankaccount_celementvalue R
isforeigncurrency bpchar 1 √ 'N'::bpchar
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_celementvalue R
c_elementvalue_uu varchar 36 √ NULL::character varying
cof_accountnature varchar 2 √ NULL::character varying
cof_validto timestamp 29,6 √ null
cof_validfrom timestamp 29,6 √ null
cof_elementvaluetype bpchar 1 √ NULL::bpchar
cof_isdetailed bpchar 1 √ 'N'::bpchar
isdetailbpartner bpchar 1 'N'::bpchar
isdetailproduct bpchar 1 'N'::bpchar
bpartnertype bpchar 1 √ NULL::bpchar
cof_codagl_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id cofcodagl_celementvalue R
cof_indcodagl bpchar 1 √ 'D'::bpchar
cof_cod_agl varchar 60 √ NULL::character varying
cof_cod_agl_sup varchar 60 √ NULL::character varying
cof_nivel_agl varchar 60 √ NULL::character varying
cof_codigoresumido varchar 40 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_elementvalue_pkey Primary key Asc c_elementvalue_id
c_elementvalue_name Performance Asc name
c_elementvalue_uu_idx Must be unique Asc c_elementvalue_uu
c_elementvalue_value Must be unique Asc/Asc c_element_id + value

Check Constraints

Constraint Name Constraint
c_elementvalue_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_isdetailproduct_check ((isdetailproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_isforeigncurrency_check ((isforeigncurrency = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_postactual_check ((postactual = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_postbudget_check ((postbudget = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_postencumbrance_check ((postencumbrance = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_isdetailbpartner_check ((isdetailbpartner = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_poststatistical_check ((poststatistical = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_cof_isdetailed_check ((cof_isdetailed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_isbankaccount_check ((isbankaccount = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_elementvalue_isdoccontrolled_check ((isdoccontrolled = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation