lineitem_summary

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

lineitem

int8

19

√

null

item_count

int8

19

√

null

recv_count

int8

19

√

null

cancel_count

int8

19

√

null

delay_count

int8

19

√

null

invoice_count

int8

19

√

null

claim_count

int8

19

√

null

estimated_amount

numeric

8,2

√

null

encumbrance_amount

numeric

8,2

√

null

paid_amount

numeric

8,2

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT li.id AS lineitem,
    ( SELECT count(lid.id) AS count
           FROM acq.lineitem_detail lid
          WHERE (lid.lineitem = li.id)) AS item_count,
    ( SELECT count(lid.id) AS count
           FROM acq.lineitem_detail lid
          WHERE ((lid.recv_time IS NOT NULL) AND (lid.lineitem = li.id))) AS recv_count,
    ( SELECT count(lid.id) AS count
           FROM (acq.lineitem_detail lid
             JOIN acq.cancel_reason acqcr ON ((acqcr.id = lid.cancel_reason)))
          WHERE ((acqcr.keep_debits IS FALSE) AND (lid.lineitem = li.id))) AS cancel_count,
    ( SELECT count(lid.id) AS count
           FROM (acq.lineitem_detail lid
             JOIN acq.cancel_reason acqcr ON ((acqcr.id = lid.cancel_reason)))
          WHERE ((acqcr.keep_debits IS TRUE) AND (lid.lineitem = li.id))) AS delay_count,
    ( SELECT count(lid.id) AS count
           FROM (acq.lineitem_detail lid
             JOIN acq.fund_debit debit ON ((lid.fund_debit = debit.id)))
          WHERE ((NOT debit.encumbrance) AND (lid.lineitem = li.id))) AS invoice_count,
    ( SELECT count(DISTINCT lid.id) AS count
           FROM (acq.lineitem_detail lid
             JOIN acq.claim claim ON ((claim.lineitem_detail = lid.id)))
          WHERE (lid.lineitem = li.id)) AS claim_count,
    ( SELECT (((count(lid.id))::numeric * li.estimated_unit_price))::numeric(8,2) AS "numeric"
           FROM acq.lineitem_detail lid
          WHERE ((lid.cancel_reason IS NULL) AND (lid.lineitem = li.id))) AS estimated_amount,
    ( SELECT (sum(debit.amount))::numeric(8,2) AS sum
           FROM (acq.lineitem_detail lid
             JOIN acq.fund_debit debit ON ((lid.fund_debit = debit.id)))
          WHERE (debit.encumbrance AND (lid.lineitem = li.id))) AS encumbrance_amount,
    ( SELECT (sum(debit.amount))::numeric(8,2) AS sum
           FROM (acq.lineitem_detail lid
             JOIN acq.fund_debit debit ON ((lid.fund_debit = debit.id)))
          WHERE ((NOT debit.encumbrance) AND (lid.lineitem = li.id))) AS paid_amount
   FROM acq.lineitem li;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views