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