cof_rv_infoembdes

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

cof_rv_infoembdes_id

numeric

√

null

documentno

varchar

2147483647

√

null

cof_identificador

varchar

2147483647

√

null

cof_fase

varchar

2147483647

√

null

cof_situacaoembarque

varchar

2147483647

√

null

cof_documentobase

text

2147483647

√

null

issotrx

bpchar

√

null

isactive

bpchar

√

null

cof_data

timestamp

29,6

√

null

lbr_rg

varchar

2147483647

√

null

phone

varchar

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT pl.ad_client_id,
    pl.ad_org_id,
    (('1'::text || pl.cof_packinglist_id))::numeric AS cof_rv_infoembdes_id,
    pl.documentno,
    pl.cof_packinglist_uu AS cof_identificador,
    pl.cof_fase,
    pl.cof_situacaoembarque,
    'P'::text AS cof_documentobase,
    pl.issotrx,
    pl.isactive,
    pl.cof_packingdate AS cof_data,
    d.lbr_rg,
    d.phone
   FROM (cof_packinglist pl
     LEFT JOIN cof_driver d ON ((d.cof_driver_id = pl.cof_driver_id)))
UNION ALL
 SELECT d.ad_client_id,
    d.ad_org_id,
    (('2'::text || d.cof_dfe_id))::numeric AS cof_rv_infoembdes_id,
    ''::character varying AS documentno,
    d.infnfe_id AS cof_identificador,
    ''::character varying AS cof_fase,
    NULL::character varying AS cof_situacaoembarque,
    'D'::text AS cof_documentobase,
    d.issotrx,
    d.isactive,
    d.datedoc AS cof_data,
    NULL::character varying AS lbr_rg,
    NULL::character varying AS phone
   FROM (cof_dfe d
     LEFT JOIN cof_packinglist_line pll ON ((pll.cof_dfe_id = d.cof_dfe_id)))
  WHERE ((pll.cof_dfe_id IS NULL) AND (d.documenttype = '0'::bpchar))
UNION ALL
 SELECT r.ad_client_id,
    r.ad_org_id,
    (('3'::text || r.m_rma_id))::numeric AS cof_rv_infoembdes_id,
    r.documentno,
    r.m_rma_uu AS cof_identificador,
    ''::character varying AS cof_fase,
    NULL::character varying AS cof_situacaoembarque,
    'R'::text AS cof_documentobase,
    r.issotrx,
    r.isactive,
    r.created AS cof_data,
    NULL::character varying AS lbr_rg,
    NULL::character varying AS phone
   FROM ((m_rma r
     LEFT JOIN cof_packinglist_line pll ON ((pll.m_rma_id = r.m_rma_id)))
     LEFT JOIN m_inout io ON (((io.m_rma_id = r.m_rma_id) AND (io.docstatus = 'CO'::bpchar))))
  WHERE ((pll.m_rma_id IS NULL) AND (io.m_rma_id IS NULL) AND (r.docstatus = 'CO'::bpchar))
UNION ALL
 SELECT c.ad_client_id,
    c.ad_org_id,
    (('4'::text || c.c_order_id))::numeric AS cof_rv_infoembdes_id,
    c.documentno,
    c.c_order_uu AS cof_identificador,
    ''::character varying AS cof_fase,
    NULL::character varying AS cof_situacaoembarque,
    'O'::text AS cof_documentobase,
    c.issotrx,
    c.isactive,
    c.dateordered AS cof_data,
    NULL::character varying AS lbr_rg,
    NULL::character varying AS phone
   FROM ((c_order c
     LEFT JOIN cof_packinglist_line pll ON ((pll.c_order_id = c.c_order_id)))
     LEFT JOIN c_orderline cl ON ((cl.c_order_id = c.c_order_id)))
  WHERE ((pll.c_order_id IS NULL) AND (c.issotrx = 'N'::bpchar) AND (c.docstatus = 'CO'::bpchar))
  GROUP BY c.c_order_id
 HAVING (sum((cl.qtyordered - cl.qtyinvoiced)) > (0)::numeric)
  ORDER BY 7, 8;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views