cof_rv_oportunidadevenda

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

ad_user_id

numeric

√

null

c_bpartner_id

numeric

√

null

c_campaign_id

numeric

√

null

c_currency_id

numeric

√

null

closedate

timestamp

29,6

√

null

cof_contract_id

numeric

√

null

cof_descricaoencerramento

varchar

255

√

null

cof_processing

bpchar

√

null

comments

text

2147483647

√

null

c_opportunity_id

numeric

√

null

c_order_id

numeric

√

null

cost

numeric

√

null

c_salesstage_id

numeric

√

null

description

varchar

255

√

null

documentno

varchar

√

null

expectedclosedate

timestamp

29,6

√

null

isactive

bpchar

√

null

isclosed

bpchar

√

null

opportunityamt

numeric

√

null

probability

numeric

√

null

processed

bpchar

√

null

salesrep_id

numeric

√

null

weightedamt

numeric

√

null

varchar

√

null

phone

varchar

√

null

phone2

varchar

√

null

cof_vendedorinterno_id

numeric

√

null

cof_responsavelindicacao_id

numeric

√

null

cof_totalordemvendaco

numeric

√

null

cof_totalordemvendaip

numeric

√

null

cof_totalordemvendadr

numeric

√

null

cof_totalordemvendacl

numeric

√

null

cof_totalordemvendavo

numeric

√

null

created

timestamp

29,6

√

null

c_city_id

numeric

√

null

address3

varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT op.ad_client_id,
    op.ad_org_id,
    op.ad_user_id,
    op.c_bpartner_id,
    op.c_campaign_id,
    op.c_currency_id,
    op.closedate,
    op.cof_contract_id,
    op.cof_descricaoencerramento,
    op.cof_processing,
    op.comments,
    op.c_opportunity_id,
    op.c_order_id,
    op.cost,
    op.c_salesstage_id,
    op.description,
    op.documentno,
    op.expectedclosedate,
    op.isactive,
    op.isclosed,
    op.opportunityamt,
    op.probability,
    op.processed,
    op.salesrep_id,
    ((op.opportunityamt * op.probability) / (100)::numeric) AS weightedamt,
    u.email,
    u.phone,
    u.phone2,
    op.cof_vendedorinterno_id,
    op.cof_responsavelindicacao_id,
    sum(COALESCE(ovl.linenetamt, (0)::numeric)) FILTER (WHERE (ov.docstatus = 'CO'::bpchar)) AS cof_totalordemvendaco,
    sum(COALESCE(ovl.linenetamt, (0)::numeric)) FILTER (WHERE (ov.docstatus = 'IP'::bpchar)) AS cof_totalordemvendaip,
    sum(COALESCE(ovl.linenetamt, (0)::numeric)) FILTER (WHERE (ov.docstatus = 'DR'::bpchar)) AS cof_totalordemvendadr,
    sum(COALESCE((ovl.qtyentered * ovl.priceentered), (0)::numeric)) FILTER (WHERE (ov.docstatus = 'CL'::bpchar)) AS cof_totalordemvendacl,
    sum(COALESCE((ovl.cof_qtdanulada * ovl.priceentered), (0)::numeric)) FILTER (WHERE (ov.docstatus = 'VO'::bpchar)) AS cof_totalordemvendavo,
    op.created,
    l.c_city_id,
    l.address3
   FROM (((((c_opportunity op
     LEFT JOIN ad_user u ON ((op.ad_user_id = u.ad_user_id)))
     LEFT JOIN c_order ov ON ((ov.c_opportunity_id = op.c_opportunity_id)))
     LEFT JOIN c_orderline ovl ON ((ovl.c_order_id = ov.c_order_id)))
     LEFT JOIN c_bpartner_location cbl ON ((cbl.c_bpartner_location_id = u.c_bpartner_location_id)))
     LEFT JOIN c_location l ON ((l.c_location_id = cbl.c_location_id)))
  GROUP BY op.ad_client_id, op.ad_org_id, op.ad_user_id, op.c_bpartner_id, op.c_campaign_id, op.c_currency_id, op.closedate, op.cof_contract_id, op.cof_descricaoencerramento, op.cof_processing, op.comments, op.c_opportunity_id, op.c_order_id, op.cost, op.c_salesstage_id, op.description, op.documentno, op.expectedclosedate, op.isactive, op.isclosed, op.opportunityamt, op.probability, op.processed, op.salesrep_id, ((op.opportunityamt * op.probability) / (100)::numeric), u.email, u.phone, u.phone2, op.cof_vendedorinterno_id, op.cof_responsavelindicacao_id, l.address3, l.c_city_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views