c_opportunity

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_opportunity_id numeric 10 null
c_contactactivity.c_opportunity_id copportunity_ccontactactivity R
c_order.c_opportunity_id copportunity_corder R
cof_activity.c_opportunity_id copportunity_cofactivity R
cof_rv_mapa_pedido.c_opportunity_id Implied Constraint R
cof_rv_oportunidadevenda.c_opportunity_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
documentno varchar 60 null
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id cbpartner_copportunity R
ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id aduser_copportunity R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_copportunity R
closedate timestamp 29,6 √ null
expectedclosedate timestamp 29,6 null
salesrep_id numeric 10 √ NULL::numeric
ad_user.ad_user_id salesrep_copportunity R
opportunityamt numeric 0 null
comments text 2147483647 √ null
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_copportunity R
cost numeric 0 √ null
c_salesstage_id numeric 10 null
c_salesstage.c_salesstage_id csalesstage_copportunity R
probability numeric 0 null
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_copportunity R
c_opportunity_uu varchar 36 √ NULL::character varying
isclosed bpchar 1 √ 'N'::bpchar
cof_descricaoencerramento varchar 255 √ NULL::character varying
processed bpchar 1 √ NULL::bpchar
cof_processing bpchar 1 √ NULL::bpchar
cof_contract_id numeric 10 √ NULL::numeric
cof_contract.cof_contract_id cofcontract_copportunity R
cof_codigoencerramento varchar 3 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_opportunity_key Primary key Asc c_opportunity_id
c_opportunity_uu_idx Must be unique Asc c_opportunity_uu

Check Constraints

Constraint Name Constraint
c_opportunity_isclosed_check ((isclosed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_opportunity_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_opportunity_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation