cof_rv_etiquetaxestoque

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_org_id

numeric

√

null

ad_client_id

numeric

√

null

m_product_id

numeric

√

null

value

varchar

510

√

null

description

varchar

255

√

null

cof_producttype_id

numeric

√

null

cof_productclass_id

numeric

√

null

cof_productgroup_id

numeric

√

null

c_uom_id

numeric

√

null

cof_conversionfactor1

numeric

√

null

cof_conversionfactor2

numeric

√

null

m_warehouse_id

numeric

√

null

qtyonhand

numeric

√

null

cof_qtyapentrada

numeric

√

null

cof_qtyape

int8

√

null

cof_qtyapsaida

numeric

√

null

cof_qtyaps

int8

√

null

cof_qtyentrada

numeric

√

null

cof_qtye

int8

√

null

cof_qtysaida

numeric

√

null

cof_qtys

int8

√

null

cof_qtyprinted

numeric

√

null

cof_qtyp

int8

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT p.ad_org_id,
    p.ad_client_id,
    p.m_product_id,
    p.value,
    p.description,
    p.cof_producttype_id,
    p.cof_productclass_id,
    p.cof_productgroup_id,
    p.c_uom_id,
    p.cof_conversionfactor1,
    p.cof_conversionfactor2,
    st.m_warehouse_id,
    sum(st.qtyonhand) AS qtyonhand,
    lbs.cof_qtyapentrada,
    lbs.cof_qtyape,
    lbs.cof_qtyapsaida,
    lbs.cof_qtyaps,
    lbs.cof_qtyentrada,
    lbs.cof_qtye,
    lbs.cof_qtysaida,
    lbs.cof_qtys,
    lbs.cof_qtyprinted,
    lbs.cof_qtyp
   FROM ((m_product p
     LEFT JOIN rv_storage st ON ((st.m_product_id = p.m_product_id)))
     LEFT JOIN ( SELECT sum(lb.qty) FILTER (WHERE ((lb.status)::text = 'EI'::text)) AS cof_qtyapentrada,
            count(lb.cof_label_id) FILTER (WHERE ((lb.status)::text = 'EI'::text)) AS cof_qtyape,
            sum(lb.qty) FILTER (WHERE ((lb.status)::text = 'EO'::text)) AS cof_qtyapsaida,
            count(lb.cof_label_id) FILTER (WHERE ((lb.status)::text = 'EO'::text)) AS cof_qtyaps,
            sum(lb.qty) FILTER (WHERE ((lb.status)::text = 'IN'::text)) AS cof_qtyentrada,
            count(lb.cof_label_id) FILTER (WHERE ((lb.status)::text = 'IN'::text)) AS cof_qtye,
            sum(lb.qty) FILTER (WHERE ((lb.status)::text = 'OU'::text)) AS cof_qtysaida,
            count(lb.cof_label_id) FILTER (WHERE ((lb.status)::text = 'OU'::text)) AS cof_qtys,
            sum(lb.qty) FILTER (WHERE ((lb.status)::text = 'PR'::text)) AS cof_qtyprinted,
            count(lb.cof_label_id) FILTER (WHERE ((lb.status)::text = 'PR'::text)) AS cof_qtyp,
            lb.m_product_id,
            l.m_warehouse_id
           FROM (cof_label lb
             LEFT JOIN m_locator l ON ((l.m_locator_id = lb.m_locator_id)))
          GROUP BY lb.m_product_id, l.m_warehouse_id) lbs ON (((lbs.m_product_id = p.m_product_id) AND (lbs.m_warehouse_id = st.m_warehouse_id))))
  GROUP BY p.m_product_id, p.value, p.description, p.cof_producttype_id, p.cof_productclass_id, p.cof_productgroup_id, p.c_uom_id, p.cof_conversionfactor1, p.cof_conversionfactor2, st.m_warehouse_id, lbs.cof_qtyapentrada, lbs.cof_qtyape, lbs.cof_qtyapsaida, lbs.cof_qtyaps, lbs.cof_qtyentrada, lbs.cof_qtye, lbs.cof_qtysaida, lbs.cof_qtys, lbs.cof_qtyprinted, lbs.cof_qtyp;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views