Table a_gift
Description:
Information on the donor's giving. Points to the gift detail records.
PRIMARY KEY
a_ledger_number_i
integer default: 0 NOT NULL
This is used as a key field in most of the accounting system files. The four digit ledger number of the gift. a_gift_batch
a_batch_number_i
integer default: 0 NOT NULL
identifes which batch a transaction belongs to a_gift_batch
a_gift_transaction_number_i
integer default: 0 NOT NULL
Identifies a transaction within a journal within a batch within a ledger

a_gift_status_c
varchar (24)
a_date_entered_d
date default: CURRENT_DATE NOT NULL
a_home_admin_charges_flag_l
boolean default: '1' NOT NULL
Used to get a yes no response from the user
a_ilt_admin_charges_flag_l
boolean default: '1' NOT NULL
Used to get a yes no response from the user
a_link_to_previous_gift_l
boolean default: '0' NOT NULL
Indicates that this gift is linked to the previous gift transaction number. For adjustments this links the new transaction to the reversal one. Set by the system.
a_print_receipt_l
boolean default: '1' NOT NULL
Indicates whether this gift should be included on receipts. For adjustments this field can be set to No to suppress printing.
a_receipt_letter_code_c
varchar (16)
a_method_of_giving_code_c
varchar (24)
Defines how a gift is given. a_method_of_giving
a_method_of_payment_code_c
varchar (16)
This is how the partner paid. Eg cash, Cheque etc a_method_of_payment
p_donor_key_n
bigint default: 0 NOT NULL
This is the partner key of the donor. p_partner
a_admin_charge_l
boolean default: '0'
NOT USED AT ALL
a_receipt_number_i
integer default: 0
Gift Receipt Number
a_last_detail_number_i
integer default: 0 NOT NULL
Identifies the last gift detail entered
a_reference_c
varchar (20)
Reference number/code for the transaction
a_first_time_gift_l
boolean default: '0'
Flag to indicate Donors first gift
a_receipt_printed_l
boolean default: '0' NOT NULL
Indicates whether or not the receipt has been printed for this gift
a_restricted_l
boolean default: '0'
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
integer default: 0 NOT NULL
Bank or credit card account used for making this gift transaction.
s_date_created_d
date default: CURRENT_DATE
The date the record was created.
s_created_by_c
varchar (20)
User ID of who created this record. s_user
s_date_modified_d
date
The date the record was modified.
s_modified_by_c
varchar (20)
User ID of who last modified this record. s_user
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP
This identifies the current version of the record.


FOREIGN KEY
a_gift_fk1: a_ledger_number_i;a_batch_number_i => a_gift_batch
a_gift_fk2: a_method_of_giving_code_c => a_method_of_giving
a_gift_fk3: a_method_of_payment_code_c => a_method_of_payment
a_gift_fk4: p_donor_key_n => p_partner
a_gift_fkcr: s_created_by_c => s_user
a_gift_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_gift_detail, s_group_gift