cof_inoutline_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_order_id

numeric

√

null

documentno

varchar

√

null

dateordered

timestamp

29,6

√

null

datepromised

timestamp

29,6

√

null

c_doctype_id

numeric

√

null

poreference

varchar

√

null

description

varchar

500

√

null

salesrep_id

numeric

√

null

m_warehouse_id

numeric

√

null

c_bpartner_location_id

numeric

√

null

ad_user_id

numeric

√

null

m_product_id

numeric

√

null

isactive

bpchar

√

null

qtyordered

numeric

√

null

qtydelivered

numeric

√

null

qtytodeliver

numeric

√

null

c_orderline_id

numeric

√

null

bomqtyordered

numeric

√

null

qtyonhand

numeric

√

null

qtyreserved

numeric

√

null

qtyunconfirmed

numeric

√

null

qtyunconfirmedmove

numeric

√

null

cof_m_shipregion_id

numeric

√

null

cof_qtdentregafutura

numeric

√

null

cof_entregaparcial

bpchar

√

null

cof_liberarentregafutura

bpchar

√

null

cof_isgeneratenftransp

bpchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT o.ad_client_id,
    o.ad_org_id,
    o.c_bpartner_id,
    o.c_order_id,
    o.documentno,
    o.dateordered,
    o.datepromised,
    o.c_doctype_id,
    o.poreference,
    o.description,
    o.salesrep_id,
    l.m_warehouse_id,
    o.c_bpartner_location_id,
    o.ad_user_id,
    l.m_product_id,
    l.isactive,
    l.qtyordered,
    l.qtydelivered,
    (l.qtyordered - l.qtydelivered) AS qtytodeliver,
    l.c_orderline_id,
    bomqtyordered(l.m_product_id, l.m_warehouse_id, (0)::numeric) AS bomqtyordered,
    bomqtyonhand(l.m_product_id, l.m_warehouse_id, (0)::numeric) AS qtyonhand,
    bomqtyreserved(l.m_product_id, l.m_warehouse_id, (0)::numeric) AS qtyreserved,
    ( SELECT sum(c.targetqty) AS sum
           FROM ((m_inoutlineconfirm c
             JOIN m_inoutline il ON ((c.m_inoutline_id = il.m_inoutline_id)))
             JOIN m_inout i ON ((il.m_inout_id = i.m_inout_id)))
          WHERE ((c.processed = 'N'::bpchar) AND (i.m_warehouse_id = l.m_warehouse_id) AND (il.m_product_id = l.m_product_id))) AS qtyunconfirmed,
    ( SELECT sum(c.targetqty) AS sum
           FROM ((m_movementlineconfirm c
             JOIN m_movementline ml ON ((c.m_movementline_id = ml.m_movementline_id)))
             JOIN m_locator lo ON ((ml.m_locatorto_id = lo.m_locator_id)))
          WHERE ((c.processed = 'N'::bpchar) AND (lo.m_warehouse_id = l.m_warehouse_id) AND (ml.m_product_id = l.m_product_id))) AS qtyunconfirmedmove,
    o.cof_m_shipregion_id,
    l.cof_qtdentregafutura,
    l.cof_entregaparcial,
    o.cof_liberarentregafutura,
    o.cof_isgeneratenftransp
   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 (o.isdropship = 'N'::bpchar) 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])))))));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views