invoice_entry

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.invoice_entry_id_seq'::regclass)
fund_debit.invoice_entry fund_debit_invoice_entry_fkey N
invoice int4 10 null
invoice.id invoice_entry_invoice_fkey C
purchase_order int4 10 √ null
purchase_order.id invoice_entry_purchase_order_fkey N
lineitem int4 10 √ null
lineitem.id invoice_entry_lineitem_fkey N
inv_item_count int4 10 null
phys_item_count int4 10 √ null
note text 2147483647 √ null
billed_per_item bool 1 √ null
cost_billed numeric 8,2 √ null
actual_cost numeric 8,2 √ null
amount_paid numeric 8,2 √ null

Indexes

Constraint Name Type Sort Column(s)
invoice_entry_pkey Primary key Asc id
ie_inv_idx Performance Asc invoice
ie_li_idx Performance Asc lineitem
ie_po_idx Performance Asc purchase_order

Relationships

Close relationships within degrees of separation