cof_m_inout_candidate_v

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

c_order_id

numeric

√

null

c_order.c_order_id

Implied Constraint

documentno

varchar

√

null

dateordered

timestamp

29,6

√

null

c_doctype_id

numeric

√

null

c_doctype.c_doctype_id

Implied Constraint

poreference

varchar

√

null

description

varchar

500

√

null

salesrep_id

numeric

√

null

m_warehouse_id

numeric

√

null

m_warehouse.m_warehouse_id

Implied Constraint

c_bpartner_location_id

numeric

√

null

c_bpartner_location.c_bpartner_location_id

Implied Constraint

ad_user_id

numeric

√

null

totallines

numeric

√

null

qtdestocado

int8

√

null

qtdnaoestocado

int8

√

null

qtdexecutado

int8

√

null

qtdnaoexecutado

int8

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT o.ad_client_id,
    o.ad_org_id,
    o.c_bpartner_id,
    o.c_order_id,
    o.documentno,
    o.dateordered,
    o.c_doctype_id,
    o.poreference,
    o.description,
    o.salesrep_id,
    l.m_warehouse_id,
    o.c_bpartner_location_id,
    o.ad_user_id,
    sum(((l.qtyordered - l.qtydelivered) * l.priceactual)) AS totallines,
    sum(
        CASE
            WHEN ((p.producttype = 'I'::bpchar) AND (p.isstocked = 'Y'::bpchar)) THEN 1
            ELSE 0
        END) AS qtdestocado,
    sum(
        CASE
            WHEN ((p.producttype = 'I'::bpchar) AND (p.isstocked = 'N'::bpchar)) THEN 1
            ELSE 0
        END) AS qtdnaoestocado,
    sum(
        CASE
            WHEN ((p.producttype = 'S'::bpchar) AND (p.cof_executado = 'Y'::bpchar)) THEN 1
            ELSE 0
        END) AS qtdexecutado,
    sum(
        CASE
            WHEN ((p.producttype = 'S'::bpchar) AND (p.cof_executado = 'N'::bpchar)) THEN 1
            ELSE 0
        END) AS qtdnaoexecutado
   FROM ((c_order o
     JOIN c_orderline l ON ((o.c_order_id = l.c_order_id)))
     LEFT JOIN m_product p ON ((p.m_product_id = l.m_product_id)))
  WHERE ((o.docstatus = 'CO'::bpchar) AND (o.isdelivered = 'N'::bpchar) AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
           FROM c_doctype
          WHERE ((c_doctype.docbasetype = 'SOO'::bpchar) AND (c_doctype.docsubtypeso <> ALL (ARRAY['ON'::bpchar, 'OB'::bpchar, 'WR'::bpchar]))))) AND (o.deliveryrule <> 'M'::bpchar) AND ((l.m_product_id IS NULL) OR (EXISTS ( SELECT 1
           FROM m_product p_1
          WHERE ((l.m_product_id = p_1.m_product_id) AND (p_1.isexcludeautodelivery = 'N'::bpchar))))) AND (l.qtyordered <> l.qtydelivered) AND (o.isdropship = 'N'::bpchar) AND ((l.m_product_id IS NOT NULL) OR (l.c_charge_id IS NOT NULL)))
  GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.c_doctype_id, o.poreference, o.description, o.salesrep_id, l.m_warehouse_id, o.c_bpartner_location_id, o.ad_user_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views