Table a_recurring_gift_detail
Description:
Store recipient information for the recurring gift.
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 a_recurring_gift, a_motivation_detail, a_recurring_gift_batch
a_batch_number_i
integer default: 0 NOT NULL
Number of the gift batch containing this detail. a_recurring_gift, a_recurring_gift_batch
a_gift_transaction_number_i
integer default: 0 NOT NULL
Identifies a gift transaction within a gift batch. a_recurring_gift
a_detail_number_i
integer default: 0 NOT NULL
Identifies a gift

a_recipient_ledger_number_n
bigint default: 0
This is used as a key field in most of the accounting system files p_partner
a_gift_amount_n
numeric (24, 10) default: 0
This is the amount in transaction currency. This field should be renamed to a_gift_transaction_amount_n, to be in analogy to a_gift_detail.a_gift_transaction_amount_n
a_motivation_group_code_c
varchar (16) NOT NULL
This defines a motivation group. a_motivation_detail
a_motivation_detail_code_c
varchar (16) NOT NULL
This defines the motivation detail within a motivation group. a_motivation_detail
a_comment_one_type_c
varchar (24)
Used to decide whose reports will see this comment
a_gift_comment_one_c
varchar (160)
This is a long description and is 80 characters long.
a_confidential_gift_flag_l
boolean default: '0' NOT NULL
Defines whether the donor wishes the recipient to know who gave the gift
a_tax_deductible_l
boolean default: '1'
Whether this gift is tax deductible
p_recipient_key_n
bigint default: 0 NOT NULL
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. p_partner
a_charge_flag_l
boolean default: '1'
To determine whether an admin fee on the transaction should be overwritten if it normally has a charge associated with it. Used for both local and ilt transaction.
p_mailing_code_c
varchar (50)
Mailing Code p_mailing
a_comment_two_type_c
varchar (24)
Used to decide whose reports will see this comment
a_gift_comment_two_c
varchar (160)
This is a long description and is 80 characters long.
a_comment_three_type_c
varchar (24)
Used to decide whose reports will see this comment
a_gift_comment_three_c
varchar (160)
This is a long description and is 80 characters long.
a_start_donations_d
date
Date that donor wants to begin giving this recurring donation
a_end_donations_d
date
Date that donor wants to stop giving this recurring donation
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
This identifies the current version of the record.


FOREIGN KEY
a_recurring_gift_detail_fk1: a_ledger_number_i;a_batch_number_i;a_gift_transaction_number_i => a_recurring_gift
a_recurring_gift_detail_fk2: a_ledger_number_i;a_motivation_group_code_c;a_motivation_detail_code_c => a_motivation_detail
a_recurring_gift_detail_fk3: p_recipient_key_n => p_partner
a_recurring_gift_detail_fk4: p_mailing_code_c => p_mailing
a_recurring_gift_detail_fk5: a_recipient_ledger_number_n => p_partner
a_recurring_gift_detail_fk6: a_ledger_number_i;a_batch_number_i => a_recurring_gift_batch
a_recurring_gift_detail_fkcr: s_created_by_c => s_user
a_recurring_gift_detail_fkmd: s_modified_by_c => s_user