c_element

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_element_id numeric 10 null
c_acctschema_element.c_element_id celement_caschemaelement R
c_elementvalue.c_element_id celement_celementvalue C
cof_c_acct_ignoreelement.c_element_id celement_cofcacctignoreelement R
cof_c_sped_contabil.c_element_id celement_cofcspedcontabil R
cof_c_sped_contabil.cof_elementcostcentre_id cofelementcostcentre_cofcspedc R
cof_c_sped_contabil.cof_elementfrom_id cofelementfrom_cofcspedcontabi R
cof_c_sped_contribuicoes.c_element_id celement_cofcspedcontribuicoes R
cof_c_sped_contribuicoes.cof_elementfrom_id cofelementfrom_cofcspedcontrib R
cof_configexportcontab.c_element_id celement_cofconfigexportcontab N
cof_configexportcontab.cof_elementref_id cofelementref_cofconfigexportc N
cof_configexportcontabexcecoes.c_element_id celement_cofconfigexportcontabexcecoes N
cof_elementvaluereference.c_element_id Implied Constraint R
cof_elementvaluereference.cof_elementfrom_id cofelementfrom_cofelementvalue R
cof_rv_detalhesmovimentocusto.c_element_id Implied Constraint R
i_elementvalue.c_element_id celement_ielementvalue N
rv_fact_acct.c_element_id Implied Constraint R
t_rv_reconciliation.c_element_id Implied Constraint R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_celement R
ad_org_id numeric 10 null
ad_org.ad_org_id c_elementorg R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
vformat varchar 40 √ null
elementtype bpchar 1 null
isbalancing bpchar 1 'N'::bpchar
isnaturalaccount bpchar 1 'Y'::bpchar
ad_tree_id numeric 10 √ null
ad_tree.ad_tree_id adtree_celement N
c_element_uu varchar 36 √ NULL::character varying
cof_entity varchar 2 √ NULL::character varying
cof_isreference bpchar 1 √ 'N'::bpchar
cof_validto timestamp 29,6 √ null
cof_validfrom timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
c_element_pkey Primary key Asc c_element_id
c_element_name Must be unique Asc/Asc ad_client_id + name
c_element_uu_idx Must be unique Asc c_element_uu

Check Constraints

Constraint Name Constraint
c_element_isbalancing_check ((isbalancing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_element_isnaturalaccount_check ((isnaturalaccount = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_element_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_element_cof_isreference_check ((cof_isreference = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation