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