Table a_gift_detail
Description:
The gift recipient information for a gift. A single gift can be split among more than one recipient. A gift detail record is created for each recipient.
PRIMARY KEY
a_ledger_number_i
integer default: 0 NOT NULL
The four digit ledger number of the gift. a_gift, a_motivation_detail, a_cost_centre, a_gift_batch, a_account, a_account
a_batch_number_i
integer default: 0 NOT NULL
Number of the gift batch containing this detail. a_gift, a_gift_batch
a_gift_transaction_number_i
integer default: 0 NOT NULL
Identifies a gift transaction within a gift batch. a_gift
a_detail_number_i
integer default: 0 NOT NULL
Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient.

a_recipient_ledger_number_n
bigint default: 0 NOT NULL
The partner key of the commitment field (the unit) of the recipient of the gift. This is not the ledger number but rather the partner key of the unit associated with the ledger. p_partner
a_gift_amount_n
numeric (24, 10) default: 0
This is a number of currency units of the ledger base currency.
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
The partner key of the recipient of the gift. 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.
a_cost_centre_code_c
varchar (24)
This identifies which cost centre an account is applied to. A cost centre can be a partner. a_cost_centre
a_account_code_c
varchar (16)
This identifies the account the financial transaction must be stored against a_account
a_gift_amount_intl_n
numeric (24, 10) default: 0
This is a number of currency units in the International Currency
a_modified_detail_l
boolean default: '0'
Indicates whether this gift detail has a matching inverse detail record because a modification was made
a_modified_detail_key_c
varchar (48)
Stores the concatenated primary key fields of the originating gift detail, of which this gift detail is the inverse.
a_fixed_gift_destination_l
boolean default: '0'
Indicates whether this gift detail's gift destination can be changed. Used for gift adjustments with family recipients.
a_gift_transaction_amount_n
numeric (24, 10) default: 0 NOT NULL
This is a number of currency units in the entered Currency
a_ich_number_i
integer default: 0 NOT NULL
identifes the ICH process number
p_mailing_code_c
varchar (50)
Mailing Code of the mailing that the gift was a response to. 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_tax_deductible_account_code_c
varchar (16)
Account Code to be used for the Tax deductible portion of this Gift a_account
a_tax_deductible_pct_n
numeric (5, 2)
Percentage of gift amount that is tax-deductible
a_tax_deductible_amount_n
numeric (24, 10) default: 0
Tax deductible portion of gift
a_tax_deductible_amount_base_n
numeric (24, 10) default: 0
Tax deductible portion of gift (Base Currency)
a_tax_deductible_amount_intl_n
numeric (24, 10) default: 0
Tax deductible portion of gift (Intl Currency)
a_non_deductible_amount_n
numeric (24, 10) default: 0
Non tax-deductible portion of gift
a_non_deductible_amount_base_n
numeric (24, 10) default: 0
Non tax-deductible portion of gift (Base Currency)
a_non_deductible_amount_intl_n
numeric (24, 10) default: 0
Non tax-deductible portion of gift (Intl Currency)
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_gift_detail_fk1: a_ledger_number_i;a_batch_number_i;a_gift_transaction_number_i => a_gift
a_gift_detail_fk2: a_ledger_number_i;a_motivation_group_code_c;a_motivation_detail_code_c => a_motivation_detail
a_gift_detail_fk3: p_recipient_key_n => p_partner
a_gift_detail_fk4: p_mailing_code_c => p_mailing
a_gift_detail_fk5: a_recipient_ledger_number_n => p_partner
a_gift_detail_fk6: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre
a__gift_detail_fk7: a_ledger_number_i;a_batch_number_i => a_gift_batch
a_gift_detail_fk8: a_ledger_number_i;a_account_code_c => a_account
a_gift_detail_fk9: a_ledger_number_i;a_tax_deductible_account_code_c => a_account
a_gift_detail_fkcr: s_created_by_c => s_user
a_gift_detail_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_processed_fee