cof_rv_gestaoxconsumo

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

cof_pp_planomestreprod_id

numeric

√

null

cof_pp_planomestreprod.cof_pp_planomestreprod_id

Implied Constraint

data

timestamp

29,6

√

null

produto_pmp

varchar

255

√

null

cof_producttype_id

numeric

√

null

cof_producttype.cof_producttype_id

Implied Constraint

tipo

varchar

√

null

cof_productclass_id

numeric

√

null

cof_productclass.cof_productclass_id

Implied Constraint

classe

varchar

√

null

cof_productgroup_id

numeric

√

null

cof_productgroup.cof_productgroup_id

Implied Constraint

grupo

varchar

√

null

materia_prima

varchar

255

√

null

quantidade

numeric

√

null

tipo_movimento

text

2147483647

√

null

m_movementline_id

numeric

√

null

ordem_producao

varchar

2147483647

√

null

ad_org_id

numeric

√

null

ad_client_id

numeric

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

isactive

bpchar

√

null

pa_id

numeric

√

null

mp_id

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT tmp.cof_pp_planomestreprod_id,
    tmp.data,
    tmp.produto_pmp,
    tmp.cof_producttype_id,
    tmp.tipo,
    tmp.cof_productclass_id,
    tmp.classe,
    tmp.cof_productgroup_id,
    tmp.grupo,
    tmp.materia_prima,
    tmp.quantidade,
    tmp.tipo_movimento,
    tmp.m_movementline_id,
    tmp.ordem_producao,
    tmp.ad_org_id,
    tmp.ad_client_id,
    tmp.created,
    tmp.createdby,
    tmp.updated,
    tmp.updatedby,
    tmp.isactive,
    tmp.pa_id,
    tmp.mp_id
   FROM ( SELECT pmp.ad_org_id,
            pmp.ad_client_id,
            pmp.created,
            pmp.createdby,
            pmp.updated,
            pmp.updatedby,
            pmp.isactive,
            pmp.cof_pp_planomestreprod_id,
            c.created AS data,
            pmpp.m_product_id AS pa_id,
            pmpp.name AS produto_pmp,
            pt.cof_producttype_id,
            pt.name AS tipo,
            pc.cof_productclass_id,
            pc.name AS classe,
            pg.cof_productgroup_id,
            pg.name AS grupo,
            p.m_product_id AS mp_id,
            p.name AS materia_prima,
            (COALESCE(c.cof_pp_quantidadeutilizada, (0)::numeric) * ('-1'::integer)::numeric) AS quantidade,
            'Consumo'::text AS tipo_movimento,
            NULL::numeric AS m_movementline_id,
            op.documentno AS ordem_producao
           FROM ((((((((cof_pp_consumomateriaprima c
             JOIN m_productionline pl ON ((c.m_productionline_id = pl.m_productionline_id)))
             JOIN m_production op ON ((op.m_production_id = pl.m_production_id)))
             JOIN m_product p ON ((p.m_product_id = c.m_product_id)))
             JOIN cof_pp_planomestreprod pmp ON ((pmp.cof_pp_planomestreprod_id = c.cof_pp_planomestreprod_id)))
             JOIN m_product pmpp ON ((pmpp.m_product_id = pmp.m_product_id)))
             JOIN cof_productgroup pg ON ((pmpp.cof_productgroup_id = pg.cof_productgroup_id)))
             JOIN cof_producttype pt ON ((pg.cof_producttype_id = pt.cof_producttype_id)))
             JOIN cof_productclass pc ON ((pg.cof_productclass_id = pc.cof_productclass_id)))
        UNION
         SELECT pmp.ad_org_id,
            pmp.ad_client_id,
            pmp.created,
            pmp.createdby,
            pmp.updated,
            pmp.updatedby,
            pmp.isactive,
            pmp.cof_pp_planomestreprod_id,
            g.created AS data,
            pmpp.m_product_id AS pa_id,
            pmpp.name AS produto_pmp,
            pt.cof_producttype_id,
            pt.name AS tipo,
            pc.cof_productclass_id,
            pc.name AS classe,
            pg.cof_productgroup_id,
            pg.name AS grupo,
            p.m_product_id AS mp_id,
            p.name AS materia_prima,
            COALESCE(g.cof_pp_quantidaderequisitada, (0)::numeric) AS quantidade,
            'Gestão'::text AS tipo_movimento,
            g.m_movementline_id,
            NULL::character varying AS ordem_producao
           FROM ((((((cof_pp_gestaomp g
             JOIN m_product p ON ((p.m_product_id = g.m_product_id)))
             JOIN cof_pp_planomestreprod pmp ON ((pmp.cof_pp_planomestreprod_id = g.cof_pp_planomestreprod_id)))
             JOIN m_product pmpp ON ((pmpp.m_product_id = pmp.m_product_id)))
             JOIN cof_productgroup pg ON ((pmpp.cof_productgroup_id = pg.cof_productgroup_id)))
             JOIN cof_producttype pt ON ((pg.cof_producttype_id = pt.cof_producttype_id)))
             JOIN cof_productclass pc ON ((pg.cof_productclass_id = pc.cof_productclass_id)))
  ORDER BY 8, 19) tmp;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views