cof_rv_infodevolucao

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

createdby

numeric

√

null

updatedby

numeric

√

null

isactive

bpchar

√

null

m_inout_id

numeric

√

null

m_inout.m_inout_id

Implied Constraint

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

cof_rmasid

text

2147483647

√

null

lbr_docfiscal_id

numeric

√

null

lbr_docfiscal.lbr_docfiscal_id

Implied Constraint

movementdate

timestamp

29,6

√

null

ide_dhemi

timestamp

29,6

√

null

movementqty

numeric

√

null

cof_possuidocfiscal

text

2147483647

√

null

cof_qtddevolvida

numeric

√

null

cof_saldodevolucao

numeric

√

null

priceentered

numeric

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

lbr_ncm_id

numeric

√

null

lbr_ncm.lbr_ncm_id

Implied Constraint

cof_rv_infodevolucao_id

numeric

√

null

m_inoutline_id

numeric

√

null

m_inoutline.m_inoutline_id

Implied Constraint

c_order_id

numeric

√

null

c_order.c_order_id

Implied Constraint

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT iol.ad_client_id,
    iol.ad_org_id,
    iol.created,
    iol.updated,
    iol.createdby,
    iol.updatedby,
    iol.isactive,
    iol.m_inout_id,
    iol.m_product_id,
    string_agg((rma.documentno)::text, ','::text) AS cof_rmasid,
    i.lbr_docfiscal_id,
    io.movementdate,
    df.ide_dhemi,
    iol.movementqty,
        CASE
            WHEN (df.lbr_docfiscal_id > (0)::numeric) THEN 'Y'::text
            ELSE 'N'::text
        END AS cof_possuidocfiscal,
    COALESCE(sum(rml.qty), (0)::numeric) AS cof_qtddevolvida,
    (iol.movementqty - COALESCE(sum(rml.qty), (0)::numeric)) AS cof_saldodevolucao,
    il.priceentered,
    io.c_bpartner_id,
    p.lbr_ncm_id,
    iol.m_inoutline_id AS cof_rv_infodevolucao_id,
    iol.m_inoutline_id,
    COALESCE(io.c_order_id, i.c_order_id, rma.c_order_id, df.c_order_id) AS c_order_id
   FROM ((((((((m_inoutline iol
     LEFT JOIN m_product p ON ((p.m_product_id = iol.m_product_id)))
     LEFT JOIN m_inout io ON ((io.m_inout_id = iol.m_inout_id)))
     LEFT JOIN c_invoiceline il ON ((il.m_inoutline_id = iol.m_inoutline_id)))
     LEFT JOIN c_invoice i ON ((i.c_invoice_id = il.c_invoice_id)))
     LEFT JOIN lbr_docfiscal_line dfl ON ((dfl.c_invoiceline_id = il.c_invoiceline_id)))
     LEFT JOIN lbr_docfiscal df ON ((df.lbr_docfiscal_id = dfl.lbr_docfiscal_id)))
     LEFT JOIN m_rmaline rml ON ((rml.m_inoutline_id = iol.m_inoutline_id)))
     LEFT JOIN m_rma rma ON ((rma.m_rma_id = rml.m_rma_id)))
  WHERE ((iol.movementqty <> (0)::numeric) AND (io.docstatus = ANY (ARRAY['CO'::bpchar, 'CL'::bpchar])) AND (i.docstatus = ANY (ARRAY['CO'::bpchar, 'CL'::bpchar])) AND (io.issotrx = 'Y'::bpchar) AND (io.movementtype = 'C-'::bpchar))
  GROUP BY iol.ad_client_id, iol.ad_org_id, iol.created, iol.updated, iol.createdby, iol.updatedby, iol.isactive, io.movementdate, io.c_bpartner_id, df.lbr_docfiscal_id, df.ide_dhemi, iol.m_product_id, io.m_inout_id, p.lbr_ncm_id, iol.movementqty, il.priceentered, iol.m_inoutline_id, i.lbr_docfiscal_id, i.c_order_id, rma.c_order_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views