cof_c_acct_ignoreelement

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_c_acct_ignoreelement_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
updated timestamp 29,6 statement_timestamp()
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofcacctignoreelement R
updatedby numeric 10 null
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_cofcacctignoreelem C
elementtype varchar 2 null
name varchar 60 null
c_element_id numeric 10 √ null
c_element.c_element_id celement_cofcacctignoreelement R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofcacctignoreelement R
org_id numeric 10 √ null
ad_org.ad_org_id org_cofcacctignoreelement R
c_elementvalue_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalue_cofcacctignoreel R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_cofcacctignoreelement R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_cofcacctignoreelemen R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_cofcacctignoreelemen R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_cofcacctignoreele R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_cofcacctignoreelement R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_cofcacctignoreelemen R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cofcacctignoreelemen R
ad_column_id numeric 10 √ null
ad_column.ad_column_id adcolumn_cofcacctignoreelement R
cof_c_acct_ignoreelement_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cof_c_acct_ignoreelement_key Primary key Asc cof_c_acct_ignoreelement_id
cof_c_acct_ignoreelement_uuidx Must be unique Asc cof_c_acct_ignoreelement_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation