m_inoutlinema_returned

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

m_inoutline_id

numeric

√

null

m_inoutline.m_inoutline_id

Implied Constraint

m_attributesetinstance_id

numeric

√

null

m_attributesetinstance.m_attributesetinstance_id

Implied Constraint

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

isactive

bpchar

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updated

timestamp

29,6

√

null

updatedby

numeric

√

null

movementqty

numeric

√

null

m_inoutlinema_uu

varchar

√

null

datematerialpolicy

timestamp

29,6

√

null

isautogenerated

bpchar

√

null

returnedqty

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT sma.m_inoutline_id,
    sma.m_attributesetinstance_id,
    sma.ad_client_id,
    sma.ad_org_id,
    sma.isactive,
    sma.created,
    sma.createdby,
    sma.updated,
    sma.updatedby,
    sma.movementqty,
    sma.m_inoutlinema_uu,
    sma.datematerialpolicy,
    sma.isautogenerated,
    sum(crma.movementqty) AS returnedqty
   FROM ((((((m_inoutlinema sma
     JOIN m_inoutline sl ON ((sma.m_inoutline_id = sl.m_inoutline_id)))
     JOIN m_inout sio ON ((sio.m_inout_id = sl.m_inout_id)))
     LEFT JOIN m_rmaline rl ON ((rl.m_inoutline_id = sl.m_inoutline_id)))
     LEFT JOIN m_inoutline crl ON ((rl.m_rmaline_id = crl.m_rmaline_id)))
     LEFT JOIN m_inout cr ON (((cr.m_inout_id = crl.m_inout_id) AND (NOT (cr.docstatus = ANY (ARRAY['CO'::bpchar, 'RE'::bpchar]))))))
     LEFT JOIN m_inoutlinema crma ON (((crma.m_inoutline_id = crl.m_inoutline_id) AND (sma.m_attributesetinstance_id = crma.m_attributesetinstance_id))))
  GROUP BY sma.m_attributesetinstance_id, sma.m_inoutline_id, sma.ad_client_id, sma.ad_org_id, sma.isactive, sma.created, sma.createdby, sma.updated, sma.updatedby, sma.movementqty, sma.m_inoutlinema_uu, sma.datematerialpolicy, sma.isautogenerated;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views