fund

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.fund_id_seq'::regclass)
distribution_formula_entry.fund distribution_formula_entry_fund_fkey R
fund_allocation.fund fund_allocation_fund_fkey C
fund_debit.fund fund_debit_fund_fkey R
fund_debit.xfer_destination fund_debit_xfer_destination_fkey R
fund_tag_map.fund fund_tag_map_fund_fkey R
fund_transfer.dest_fund fund_transfer_dest_fund_fkey R
fund_transfer.src_fund fund_transfer_src_fund_fkey R
invoice_item.fund invoice_item_fund_fkey R
lineitem_detail.fund lineitem_detail_fund_fkey R
po_item.fund po_item_fund_fkey R
org int4 10 null
org_unit.id fund_org_fkey C
name text 2147483647 null
year int4 10 EXTRACT(year FROM now())
currency_type text 2147483647 null
currency_type.code fund_currency_type_fkey R
code text 2147483647 null
rollover bool 1 false
propagate bool 1 true
active bool 1 true
balance_warning_percent int4 10 √ null
balance_stop_percent int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
fund_pkey Primary key Asc id
code_once_per_org_year Must be unique Asc/Asc/Asc org + code + year
name_once_per_org_year Must be unique Asc/Asc/Asc org + name + year

Check Constraints

Constraint Name Constraint
acq_fund_rollover_implies_propagate ((propagate OR (NOT rollover)))

Relationships

Close relationships within degrees of separation