cof_rv_detalhesmovimentocusto

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

c_acctschema_id

numeric

√

null

ad_org_id

numeric

√

null

ad_client_id

numeric

√

null

created

timestamp

29,6

√

null

m_costtype_id

numeric

√

null

m_costtype.m_costtype_id

Implied Constraint

m_costdetail_id

numeric

√

null

m_costdetail.m_costdetail_id

Implied Constraint

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

cof_producttype_id

numeric

√

null

cof_producttype.cof_producttype_id

Implied Constraint

cof_productclass_id

numeric

√

null

cof_productclass.cof_productclass_id

Implied Constraint

cof_productgroup_id

numeric

√

null

cof_productgroup.cof_productgroup_id

Implied Constraint

qty

numeric

√

null

deltaamt

numeric

√

null

oldqty

numeric

√

null

oldcqty

numeric

√

null

newqty

numeric

√

null

newcqty

numeric

√

null

description

varchar

255

√

null

m_inventoryline_id

numeric

√

null

m_inventoryline.m_inventoryline_id

Implied Constraint

m_costelement_id

numeric

√

null

m_costelement.m_costelement_id

Implied Constraint

m_attributesetinstance_id

numeric

√

null

m_attributesetinstance.m_attributesetinstance_id

Implied Constraint

amt

numeric

√

null

deltaqty

numeric

√

null

oldcostprice

numeric

√

null

oldcamt

numeric

√

null

newcostprice

numeric

√

null

newcamt

numeric

√

null

cof_tipomovimento

text

2147483647

√

null

documentno

varchar

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

user1_id

numeric

√

null

user2_id

numeric

√

null

c_element_id

numeric

√

null

c_element.c_element_id

Implied Constraint

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT mc.c_acctschema_id,
    mc.ad_org_id,
    mc.ad_client_id,
    mc.created,
    mc.m_costtype_id,
    mc.m_costdetail_id,
    mc.m_product_id,
    p.cof_producttype_id,
    p.cof_productclass_id,
    p.cof_productgroup_id,
    mc.qty,
    mc.deltaamt,
    mc.oldqty,
    mc.oldcqty,
    mc.newqty,
    mc.newcqty,
    mc.description,
    mc.m_inventoryline_id,
    mc.m_costelement_id,
    mc.m_attributesetinstance_id,
    mc.amt,
    mc.deltaqty,
    mc.oldcostprice,
    mc.oldcamt,
    mc.newcostprice,
    mc.newcamt,
        CASE
            WHEN (mc.c_orderline_id IS NOT NULL) THEN 'Pedido de Compra'::text
            WHEN (mc.c_invoiceline_id IS NOT NULL) THEN 'Fatura'::text
            WHEN (mc.m_inoutline_id IS NOT NULL) THEN 'Recebimento de Material'::text
            WHEN (mc.m_movementline_id IS NOT NULL) THEN 'Movimentação de Estoque'::text
            WHEN (mc.m_inventoryline_id IS NOT NULL) THEN 'Estoque Físico'::text
            WHEN (mc.m_productionline_id IS NOT NULL) THEN 'Ordem de Produção'::text
            ELSE NULL::text
        END AS cof_tipomovimento,
    COALESCE(o.documentno, inv.documentno, miout.documentno, mv.documentno, minv.documentno, mp.documentno) AS documentno,
    COALESCE(o.c_bpartner_id, inv.c_bpartner_id, miout.c_bpartner_id, mv.c_bpartner_id, mp.c_bpartner_id) AS c_bpartner_id,
    COALESCE(o.user1_id, inv.user1_id, miout.user1_id, mv.user1_id, minv.user1_id, mp.user1_id) AS user1_id,
    COALESCE(o.user2_id, inv.user2_id, miout.user2_id, mv.user2_id, minv.user2_id, mp.user2_id) AS user2_id,
    ( SELECT ce.c_element_id
           FROM c_elementvalue ce
          WHERE (ce.c_elementvalue_id = COALESCE(o.user1_id, inv.user1_id, miout.user1_id, mv.user1_id, minv.user1_id, mp.user1_id))) AS c_element_id
   FROM (((((((m_costmovement_v mc
     LEFT JOIN m_product p ON ((p.m_product_id = mc.m_product_id)))
     LEFT JOIN c_order o ON (((mc.c_orderline_id IS NOT NULL) AND (o.c_order_id = ( SELECT a.c_order_id
           FROM c_orderline a
          WHERE (a.c_orderline_id = mc.c_orderline_id))))))
     LEFT JOIN c_invoice inv ON (((mc.c_invoiceline_id IS NOT NULL) AND (inv.c_invoice_id = ( SELECT b.c_invoice_id
           FROM c_invoiceline b
          WHERE (b.c_invoiceline_id = mc.c_invoiceline_id))))))
     LEFT JOIN m_inout miout ON (((mc.m_inoutline_id IS NOT NULL) AND (miout.m_inout_id = ( SELECT c.m_inout_id
           FROM m_inoutline c
          WHERE (c.m_inoutline_id = mc.m_inoutline_id))))))
     LEFT JOIN m_movement mv ON (((mc.m_movementline_id IS NOT NULL) AND (mv.m_movement_id = ( SELECT d.m_movement_id
           FROM m_movementline d
          WHERE (d.m_movementline_id = mc.m_movementline_id))))))
     LEFT JOIN m_inventory minv ON (((mc.m_inventoryline_id IS NOT NULL) AND (minv.m_inventory_id = ( SELECT e.m_inventory_id
           FROM m_inventoryline e
          WHERE (e.m_inventoryline_id = mc.m_inventoryline_id))))))
     LEFT JOIN m_production mp ON (((mc.m_productionline_id IS NOT NULL) AND (mp.m_production_id = ( SELECT f.m_production_id
           FROM m_productionline f
          WHERE (f.m_productionline_id = mc.m_productionline_id))))));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views