| Table a_ep_match |
|
Description: the matches that can be used to identify recurring gift or GL transactions |
| PRIMARY KEY | ||
|
a_ep_match_key_i
integer NOT NULL | this is a sequence to easily identify which transaction has been matched and how | |
| UNIQUE KEY | ||
|
a_match_text_c
varchar (200) NOT NULL | this is a separated list of all the recurring details of a_ep_transaction (ie. name, bank account, sort code, IBAN, amount, description) | |
|
a_detail_i
integer default: 0 NOT NULL | the match can be applied to split gifts as well | |
|
a_ledger_number_i
integer default: 0 NOT NULL | The four digit ledger number of the gift. | a_motivation_detail, a_cost_centre, a_account |
|
a_action_c
varchar (40) NOT NULL | What to do with this match: gift, GL, or discard | |
|
a_recent_match_d
date default: CURRENT_DATE NOT NULL | The date when this match was recently applied; useful for purging old entries | |
|
a_recipient_ledger_number_n
bigint default: 0 | 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_motivation_group_code_c
varchar (16) | This defines a motivation group. | a_motivation_detail |
|
a_motivation_detail_code_c
varchar (16) | 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 deductaible | |
|
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 |
|
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_gift_transaction_amount_n
numeric (24, 10) default: 0 NOT NULL | This is a number of currency units in the entered Currency | |
|
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_receipt_letter_code_c
varchar (20) | ||
|
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_narrative_c
varchar (240) | ||
|
a_reference_c
varchar (20) | Reference number/code for the transaction | |
|
p_donor_short_name_c
varchar (500) | short name of the donor; will be used for generating export files | |
|
p_recipient_short_name_c
varchar (500) | short name of recipient | |
|
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 | |
|
a_account_code_c
varchar (16) | This identifies the account the financial transaction must be stored against | a_account |
|
a_key_ministry_key_n
bigint | Key ministry to which this transaction applies (just for fund transfers) | p_unit |
|
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_ep_match_fk1: a_ledger_number_i;a_motivation_group_code_c;a_motivation_detail_code_c => a_motivation_detail a_ep_match_fk2: p_recipient_key_n => p_partner a_ep_match_fk3: p_mailing_code_c => p_mailing a_ep_match_fk4: a_recipient_ledger_number_n => p_partner a_ep_match_fk5: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre a_ep_match_fk6: a_method_of_giving_code_c => a_method_of_giving a_ep_match_fk7: a_method_of_payment_code_c => a_method_of_payment a_ep_match_fk8: p_donor_key_n => p_partner a_ep_match_fk9: a_ledger_number_i;a_account_code_c => a_account a_ep_match_fk10: a_key_ministry_key_n => p_unit a_ep_match_fkcr: s_created_by_c => s_user a_ep_match_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY a_ep_transaction | ||