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
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