fund_debit

57 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.fund_debit_id_seq'::regclass)
debit_attribution.fund_debit debit_attribution_fund_debit_fkey R
invoice_item.fund_debit invoice_item_fund_debit_fkey R
lineitem_detail.fund_debit lineitem_detail_fund_debit_fkey R
po_item.fund_debit po_item_fund_debit_fkey R
fund int4 10 null
fund.id fund_debit_fund_fkey R
origin_amount numeric 0 null
origin_currency_type text 2147483647 null
currency_type.code fund_debit_origin_currency_type_fkey R
amount numeric 0 null
encumbrance bool 1 true
debit_type text 2147483647 null
xfer_destination int4 10 √ null
fund.id fund_debit_xfer_destination_fkey R
create_time timestamptz 35,6 now()
invoice_entry int4 10 √ null
invoice_entry.id fund_debit_invoice_entry_fkey N

Indexes

Constraint Name Type Sort Column(s)
fund_debit_pkey Primary key Asc id
fund_debit_invoice_entry_idx Performance Asc invoice_entry

Relationships

Close relationships within degrees of separation