| 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 default: CURRENT_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 | ||