rv_c_invoice_vendormonth

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

m_product_category_id

numeric

√

null

m_product_category.m_product_category_id

Implied Constraint

dateinvoiced

date

√

null

linenetamt

numeric

√

null

linelistamt

numeric

√

null

linelimitamt

numeric

√

null

linediscountamt

numeric

√

null

linediscount

numeric

√

null

lineoverlimitamt

numeric

√

null

lineoverlimit

numeric

√

null

qtyinvoiced

numeric

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT il.ad_client_id,
    il.ad_org_id,
    po.c_bpartner_id,
    il.m_product_category_id,
    firstof((il.dateinvoiced)::timestamp with time zone, 'MM'::character varying) AS dateinvoiced,
    sum(il.linenetamt) AS linenetamt,
    sum(il.linelistamt) AS linelistamt,
    sum(il.linelimitamt) AS linelimitamt,
    sum(il.linediscountamt) AS linediscountamt,
        CASE
            WHEN (sum(il.linelistamt) = (0)::numeric) THEN (0)::numeric
            ELSE currencyround((((sum(il.linelistamt) - sum(il.linenetamt)) / sum(il.linelistamt)) * (100)::numeric), i.c_currency_id, 'N'::character varying)
        END AS linediscount,
    sum(il.lineoverlimitamt) AS lineoverlimitamt,
        CASE
            WHEN (sum(il.linenetamt) = (0)::numeric) THEN (0)::numeric
            ELSE ((100)::numeric - currencyround((((sum(il.linenetamt) - sum(il.lineoverlimitamt)) / sum(il.linenetamt)) * (100)::numeric), i.c_currency_id, 'N'::character varying))
        END AS lineoverlimit,
    sum(il.qtyinvoiced) AS qtyinvoiced
   FROM ((rv_c_invoiceline il
     JOIN c_invoice i ON ((i.c_invoice_id = il.c_invoice_id)))
     JOIN m_product_po po ON ((il.m_product_id = po.m_product_id)))
  WHERE (il.issotrx = 'Y'::bpchar)
  GROUP BY il.ad_client_id, il.ad_org_id, po.c_bpartner_id, il.m_product_category_id, (firstof((il.dateinvoiced)::timestamp with time zone, 'MM'::character varying)), i.c_currency_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views