rv_c_invoice_week

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ad_client_id

numeric

√

null

ad_org_id

numeric

√

null

salesrep_id

numeric

√

null

dateinvoiced

date

√

null

linenetamt

numeric

√

null

linelistamt

numeric

√

null

linelimitamt

numeric

√

null

linediscountamt

numeric

√

null

c_doctype_id

numeric

√

null

c_doctype.c_doctype_id

Implied Constraint

docstatus

bpchar

√

null

user1_id

numeric

√

null

user2_id

numeric

√

null

c_bpartner_id

numeric

√

null

c_bpartner.c_bpartner_id

Implied Constraint

c_activity_id

numeric

√

null

c_activity.c_activity_id

Implied Constraint

producttype

bpchar

√

null

linediscount

numeric

√

null

lineoverlimitamt

numeric

√

null

lineoverlimit

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.salesrep_id,
    firstof((il.dateinvoiced)::timestamp with time zone, 'DY'::character varying) AS dateinvoiced,
    sum(il.linenetamt) AS linenetamt,
    sum(il.linelistamt) AS linelistamt,
    sum(il.linelimitamt) AS linelimitamt,
    sum(il.linediscountamt) AS linediscountamt,
    i.c_doctype_id,
    i.docstatus,
    COALESCE(il.user1_id, i.user1_id) AS user1_id,
    COALESCE(il.user2_id, i.user2_id) AS user2_id,
    i.c_bpartner_id,
    COALESCE(il.c_activity_id, i.c_activity_id) AS c_activity_id,
    p.producttype,
        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,
    il.issotrx
   FROM ((rv_c_invoiceline il
     JOIN c_invoice i ON ((i.c_invoice_id = il.c_invoice_id)))
     LEFT JOIN m_product p ON ((il.m_product_id = p.m_product_id)))
  GROUP BY il.ad_client_id, il.ad_org_id, il.salesrep_id, (firstof((il.dateinvoiced)::timestamp with time zone, 'DY'::character varying)), il.issotrx, i.c_currency_id, i.c_doctype_id, i.docstatus, i.c_bpartner_id, COALESCE(il.user1_id, i.user1_id), COALESCE(il.user2_id, i.user2_id), COALESCE(il.c_activity_id, i.c_activity_id), p.producttype;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views