m_inout_candidate_v

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

created

timestamp

29,6

√

null

updated

timestamp

29,6

√

null

isactive

bpchar

√

null

c_bpartner_id

numeric

√

null

c_order_id

numeric

√

null

documentno

varchar

√

null

dateordered

timestamp

29,6

√

null

c_doctype_id

numeric

√

null

poreference

varchar

2147483647

√

null

description

varchar

2147483647

√

null

salesrep_id

numeric

√

null

m_warehouse_id

numeric

√

null

m_inout_id

numeric

√

null

totallines

numeric

√

null

docsource

text

2147483647

√

null

m_inout_candidate_v_id

numeric

√

null

deliveryrule

bpchar

2147483647

√

null

c_bpartner_location_id

numeric

√

null

ad_user_id

numeric

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT o.ad_client_id,
    o.ad_org_id,
    o.created,
    o.updated,
    o.isactive,
    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,
    NULL::numeric AS m_inout_id,
    sum(((l.qtyordered - l.qtydelivered) * l.priceactual)) AS totallines,
    'O'::text AS docsource,
    o.c_order_id AS m_inout_candidate_v_id,
    o.deliveryrule,
    o.c_bpartner_location_id,
    o.ad_user_id
   FROM (c_order o
     JOIN c_orderline l ON ((o.c_order_id = l.c_order_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
          WHERE ((l.m_product_id = p.m_product_id) AND (p.isexcludeautodelivery = 'N'::bpchar))))) AND (l.qtyordered <> l.qtydelivered) AND ((l.m_product_id IS NOT NULL) OR (l.c_charge_id IS NOT NULL)) AND (NOT (EXISTS ( SELECT 1
           FROM (m_inoutline iol
             JOIN m_inout io ON ((iol.m_inout_id = io.m_inout_id)))
          WHERE ((iol.c_orderline_id = l.c_orderline_id) AND (io.docstatus = ANY (ARRAY['DR'::bpchar, 'IN'::bpchar, 'IP'::bpchar, 'WC'::bpchar])))))))
  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.created, o.updated, o.isactive, o.deliveryrule, o.c_bpartner_location_id, o.ad_user_id
UNION ALL
 SELECT rma.ad_client_id,
    rma.ad_org_id,
    rma.created,
    rma.updated,
    rma.isactive,
    rma.c_bpartner_id,
    rma.c_order_id,
    rma.documentno,
    rma.created AS dateordered,
    rma.c_doctype_id,
    NULL::character varying AS poreference,
    NULL::character varying AS description,
    NULL::numeric AS salesrep_id,
    io.m_warehouse_id,
    rma.inout_id AS m_inout_id,
    rma.amt AS totallines,
    'R'::text AS docsource,
    rma.m_rma_id AS m_inout_candidate_v_id,
    NULL::bpchar AS deliveryrule,
    io.c_bpartner_location_id,
    io.ad_user_id
   FROM ((((m_rma rma
     JOIN ad_org org ON ((rma.ad_org_id = org.ad_org_id)))
     JOIN c_doctype dt ON ((rma.c_doctype_id = dt.c_doctype_id)))
     JOIN c_bpartner bp ON ((rma.c_bpartner_id = bp.c_bpartner_id)))
     JOIN m_inout io ON ((rma.inout_id = io.m_inout_id)))
  WHERE ((rma.docstatus = 'CO'::bpchar) AND (dt.docbasetype = 'POO'::bpchar) AND (EXISTS ( SELECT 1
           FROM (m_rma r
             JOIN m_rmaline rl ON ((r.m_rma_id = rl.m_rma_id)))
          WHERE ((r.m_rma_id = rma.m_rma_id) AND (rl.isactive = 'Y'::bpchar) AND (rl.m_inoutline_id > (0)::numeric) AND (rl.qtydelivered < rl.qty)))) AND (NOT (EXISTS ( SELECT 1
           FROM m_inout oio
          WHERE ((oio.m_rma_id = rma.m_rma_id) AND (oio.docstatus = ANY (ARRAY['IP'::bpchar, 'CO'::bpchar, 'CL'::bpchar])))))) AND (NOT (EXISTS ( SELECT 1
           FROM ((m_inout oio
             JOIN m_inoutline il ON ((il.m_inout_id = oio.m_inout_id)))
             JOIN m_rmaline rl ON ((rl.m_rmaline_id = il.m_rmaline_id)))
          WHERE ((rl.m_rma_id = rma.m_rma_id) AND (oio.docstatus = ANY (ARRAY['IP'::bpchar, 'CO'::bpchar, 'CL'::bpchar])))))));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views