| Table a_ep_transaction |
|
Description: the transactions from the recently imported bank statements; they should help to identify the other party of the transaction (donor, etc) and the purpose of the transaction |
| PRIMARY KEY | ||
|
a_statement_key_i
integer NOT NULL | this transaction belongs to that statement | a_ep_statement |
|
a_order_i
integer NOT NULL | to complete the primary key | |
|
a_detail_key_i
integer default: -1 NOT NULL | a transaction can be split in order to support mixed GL and Gift records | |
|
a_number_on_paper_statement_i
integer default: -1 | can be different from order, since the paper statements can have different order than the electronic statement | |
|
a_match_text_c
varchar (200) | this is a calculated text that uniquely identifies this transaction so that it can be recognised next month. TODO: should have a link table a_ep_match between a_ep_transaction and a_ep_match_detail | |
|
a_account_name_c
varchar (160) | This can be a summary of title, first name, last name etc. of the other party | |
|
a_title_c
varchar (64) | ||
|
a_first_name_c
varchar (64) | ||
|
a_middle_name_c
varchar (64) | ||
|
a_last_name_c
varchar (64) | the name of the other party | |
|
p_branch_code_c
varchar (20) | The bank code/branch code/sort code of the other party. | |
|
p_bic_c
varchar (22) | BIC (Bank Identifier Code)/SWIFT code of the other party | |
|
a_bank_account_number_c
varchar (40) | The account number in the bank of the other party | |
|
a_iban_c
varchar (128) | The IBAN (International Bank Account Number) of the other party. | |
|
a_transaction_type_code_c
varchar (40) | This can be recurring income, recurring payment, income, payment, direct debit, etc. | |
|
a_transaction_amount_n
numeric (24, 10) default: 0 NOT NULL | The amount in the currency of the bank account | |
|
a_description_c
varchar (512) | This description was given when the transfer was initiated | |
|
a_date_effective_d
date default: CURRENT_DATE NOT NULL | The date when this transaction became valid or available | |
|
a_ep_match_key_i
integer | set this value to the match (either new match or set automatically) | a_ep_match |
|
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_transaction_fk1: a_statement_key_i => a_ep_statement a_ep_transaction_fk2: a_ep_match_key_i => a_ep_match a_ep_transaction_fkcr: s_created_by_c => s_user a_ep_transaction_fkmd: s_modified_by_c => s_user | ||