fund_transfer

-1 rows


Description

Fund Transfer Each row represents the transfer of money from a source fund to a destination fund. There should be corresponding entries in acq.fund_allocation. The purpose of acq.fund_transfer is to record how much money moved from which fund to which other fund.

The presence of two amount fields, rather than one, reflects the possibility that the two funds are denominated in different currencies. If they use the same currency type, the two amounts should be the same.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.fund_transfer_id_seq'::regclass)
src_fund int4 10 null
fund.id fund_transfer_src_fund_fkey R
src_amount numeric 0 null
dest_fund int4 10 √ null
fund.id fund_transfer_dest_fund_fkey R
dest_amount numeric 0 √ null
transfer_time timestamptz 35,6 now()
transfer_user int4 10 null
usr.id fund_transfer_transfer_user_fkey R
note text 2147483647 √ null
funding_source_credit int4 10 null
funding_source_credit.id fund_transfer_funding_source_credit_fkey R

Indexes

Constraint Name Type Sort Column(s)
fund_transfer_pkey Primary key Asc id
acqftr_usr_idx Performance Asc transfer_user

Relationships

Close relationships within degrees of separation