rv_c_invoice_productqtr

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

m_product_id

numeric

√

null

m_product.m_product_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

issotrx

bpchar

√

null

Relationships

Close relationships within degrees of separation

One
One implied

View Definition

SELECT il.ad_client_id,
    il.ad_org_id,
    il.m_product_id,
    firstof((il.dateinvoiced)::timestamp with time zone, 'Q'::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,
    il.issotrx
   FROM (rv_c_invoiceline il
     JOIN c_invoice i ON ((i.c_invoice_id = il.c_invoice_id)))
  GROUP BY il.ad_client_id, il.ad_org_id, il.m_product_id, (firstof((il.dateinvoiced)::timestamp with time zone, 'Q'::character varying)), il.issotrx, i.c_currency_id;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views