Table openpetra_trunk.public.a_gift
Information on the donor's giving. Points to the gift detail records.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
a_ledger_number_i int4 10 0
a_gift_detail.a_ledger_number_i a_gift_detail_fk1 R
s_group_gift.a_ledger_number_i s_group_gift_fk2 R
a_gift_batch.a_ledger_number_i a_gift_fk1 R
This is used as a key field in most of the accounting system files. The four digit ledger number of the gift.
a_batch_number_i int4 10 0
a_gift_detail.a_batch_number_i a_gift_detail_fk1 R
s_group_gift.a_batch_number_i s_group_gift_fk2 R
a_gift_batch.a_batch_number_i a_gift_fk1 R
identifes which batch a transaction belongs to
a_gift_transaction_number_i int4 10 0
a_gift_detail.a_gift_transaction_number_i a_gift_detail_fk1 R
s_group_gift.a_gift_transaction_number_i s_group_gift_fk2 R
Identifies a transaction within a journal within a batch within a ledger
a_gift_status_c varchar 24  √  null
a_date_entered_d date 13 ('now'::text)::date
a_home_admin_charges_flag_l bool 1 true Used to get a yes no response from the user
a_ilt_admin_charges_flag_l bool 1 true Used to get a yes no response from the user
a_receipt_letter_code_c varchar 16  √  null
a_method_of_giving_code_c varchar 24  √  null
a_method_of_giving.a_method_of_giving_code_c a_gift_fk2 R
Defines how a gift is given.
a_method_of_payment_code_c varchar 16  √  null
a_method_of_payment.a_method_of_payment_code_c a_gift_fk3 R
This is how the partner paid. Eg cash, Cheque etc
p_donor_key_n numeric 10 0
p_partner.p_partner_key_n a_gift_fk4 R
This is the partner key of the donor.
a_admin_charge_l bool 1  √  false NOT USED AT ALL
a_receipt_number_i int4 10  √  0 Gift Receipt Number
a_last_detail_number_i int4 10 0 Identifies the last gift detail entered
a_reference_c varchar 20  √  null Reference number/code for the transaction
a_first_time_gift_l bool 1  √  false Flag to indicate Donors first gift
a_receipt_printed_l bool 1 false Indicates whether or not the receipt has been printed for this gift
a_restricted_l bool 1  √  false Indicates whether or not the gift has restricted access. If it does then the access will be controlled by s_group_gift
p_banking_details_key_i int4 10 0 Bank or credit card account used for making this gift transaction.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_gift_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_gift_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 565.530 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i Primary key Asc/Asc/Asc a_gift_pk
a_ledger_number_i + a_date_entered_d Performance Asc/Asc a_date_entered0
p_donor_key_n + a_ledger_number_i Performance Asc/Asc a_donor1
a_ledger_number_i + a_batch_number_i Performance Asc/Asc inx_a_gift_fk1_key1
a_method_of_giving_code_c Performance Asc inx_a_gift_fk2_key2
a_method_of_payment_code_c Performance Asc inx_a_gift_fk3_key3
p_donor_key_n Performance Asc inx_a_gift_fk4_key4
s_created_by_c Performance Asc inx_a_gift_fkcr_key5
s_modified_by_c Performance Asc inx_a_gift_fkmd_key6
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i Must be unique Asc/Asc/Asc inx_a_gift_pk0

Close relationships  within of separation: