c_acctschema_element

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_acctschema_element_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
ad_org_id numeric 10 null
ad_org.ad_org_id adorgid_c_aschemaelement R
updatedby numeric 10 null
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_caschemaelement C
elementtype bpchar 2 null
name varchar 60 null
seqno numeric 10 null
c_element_id numeric 10 √ null
c_element.c_element_id celement_caschemaelement R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_caschemaelement R
ismandatory bpchar 1 'N'::bpchar
isbalanced bpchar 1 'N'::bpchar
org_id numeric 10 √ null
ad_org.ad_org_id adorg_caschemaelement R
c_elementvalue_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalue_caschemaelement R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_caschemaelement R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbuspartner_caschemaelement R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_caschemaelement R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_caschemaelement R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_caschemaelement R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id socampaign_caschemaelement R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_cacctschemaelement R
ad_column_id numeric 10 √ null
ad_column.ad_column_id adcolumn_cacctschemaelement R
c_acctschema_element_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_acctschema_element_pkey Primary key Asc c_acctschema_element_id
c_acctschema_element_schema Performance Asc c_acctschema_id
c_acctschema_element_uu_idx Must be unique Asc c_acctschema_element_uu

Check Constraints

Constraint Name Constraint
c_acctschema_element_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_element_isbalanced_check ((isbalanced = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_element_ismandatory_check ((ismandatory = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation