rv_pp_order_transactions

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

isactive

bpchar

√

null

created

timestamp

29,6

√

null

createdby

numeric

√

null

updatedby

numeric

√

null

updated

timestamp

29,6

√

null

documentno

varchar

√

null

m_product_id

numeric

√

null

m_product.m_product_id

Implied Constraint

m_locator_id

numeric

√

null

m_locator.m_locator_id

Implied Constraint

movementdate

timestamp

29,6

√

null

pp_order_id

numeric

√

null

pp_order.pp_order_id

Implied Constraint

qtydelivered

numeric

√

null

qtyscrap

numeric

√

null

qtydeliveredline

numeric

√

null

qtyissueshouldbe

numeric

√

null

qtyscrapline

numeric

√

null

qtyissuescrapshouldbe

numeric

√

null

createdbyissue

numeric

√

null

updatedbyissue

numeric

√

null

qtytodeliver

numeric

√

null

differenceqty

numeric

√

null

issotrx

bpchar

√

null

dateordered

timestamp

29,6

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT DISTINCT o.ad_client_id,
    o.ad_org_id,
    o.isactive,
    o.created,
    o.createdby,
    o.updatedby,
    o.updated,
    o.documentno,
    ol.m_product_id,
    mt.m_locator_id,
    mt.movementdate,
    o.pp_order_id,
    o.qtydelivered,
    o.qtyscrap,
    ol.qtydelivered AS qtydeliveredline,
    ((o.qtydelivered * ol.qtybatch) / (100)::numeric) AS qtyissueshouldbe,
    ol.qtyscrap AS qtyscrapline,
    ((o.qtyscrap * ol.qtybatch) / (100)::numeric) AS qtyissuescrapshouldbe,
    mt.createdby AS createdbyissue,
    mt.updatedby AS updatedbyissue,
    ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)) AS qtytodeliver,
    ((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))) AS differenceqty,
    o.issotrx,
    o.dateordered
   FROM (((pp_order o
     JOIN pp_order_bomline ol ON ((ol.pp_order_id = o.pp_order_id)))
     JOIN pp_cost_collector cc ON ((cc.pp_order_bomline_id = ol.pp_order_bomline_id)))
     LEFT JOIN m_transaction mt ON ((mt.pp_cost_collector_id = cc.pp_cost_collector_id)))
  ORDER BY o.ad_client_id, o.ad_org_id, o.isactive, o.created, o.createdby, o.updatedby, o.updated, o.documentno, ol.m_product_id, mt.m_locator_id, mt.movementdate, o.pp_order_id, o.qtydelivered, o.qtyscrap, ol.qtydelivered, ((o.qtydelivered * ol.qtybatch) / (100)::numeric), ol.qtyscrap, ((o.qtyscrap * ol.qtybatch) / (100)::numeric), mt.createdby, mt.updatedby, ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)), ((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))), o.issotrx, o.dateordered;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views